12cR1 RAC Posts — 8g : Switchover from RAC Primary to SingleInstance Standby

Continuing this series of posts where I have a SingleInstance/FileSystem Standby database for a RAC/ASM database … Checking the status of the configuration : DGMGRL> show configuration;Configuration - rac Protection Mode: MaxPerformance Members: rac - Primary database stby - Physical standby databaseFast-Start Failover: DISABLEDConfiguration Status:SUCCESS (status updated 28 seconds ago)DGMGRL>SQL> select thread#, max(sequence#) 2 from v$archived_log 3 group by thread# 4 order by 1 5 / THREAD# MAX(SEQUENCE#)---------- -------------- 1 66 2 36SQL> alter system archive log current;System altered.RFS[2]: Selected log 8 for thread 2 sequence 38 dbid 2519807290 branch 931825279Mon Apr 10 23:03:17 2017Archived Log entry 39 added for thread 2 sequence 37 ID 0x96312536 dest 1:Mon Apr 10 23:03:18 2017Media Recovery Waiting for thread 2 sequence 38 (in transit)Mon Apr 10 23:03:18 2017Recovery of Online Redo Log: Thread 2 Group 8 Seq 38 Reading mem 0 Mem# 0: /u01/app/oracle/oradata/STBY/onlinelog/group_8.300.937936389 Mem# 1: /u01/app/oracle/fast_recovery_area/STBY/onlinelog/group_8.306.937936389RFS[1]: Selected log 6 for thread 1

12cR1 RAC Posts — 8b : DUPLICATE DATABASE FOR STANDBY

Continuing the previous post, where I have done the pre-setup…(A reminder : This is a SingleInstance Standby on FileSystem for a RAC Database with a PDB on ASM) On the SingleInstance Node (for the Standby database) Precreate the required folders for the database (and redo and control) files (I later realised that the “onlinelog” folders for the SEED and PDB are not required) [oracle@oem132 ~]$ cd /u01/app/oracle/oradata[oracle@oem132 oradata]$ mkdir STBY[oracle@oem132 oradata]$ cd STBY[oracle@oem132 STBY]$ mkdir datafile[oracle@oem132 STBY]$ mkdir onlinelog[oracle@oem132 STBY]$ mkdir 44bbc69ce8f552aee053334ea8c07365[oracle@oem132 STBY]$ mkdir fd9ac20f64d244d7e043b6a9e80a2f2f[oracle@oem132 STBY]$ cd 44*[oracle@oem132 44bbc69ce8f552aee053334ea8c07365]$ mkdir datafile tempfile[oracle@oem132 44bbc69ce8f552aee053334ea8c07365]$ cd ../fd*[oracle@oem132 fd9ac20f64d244d7e043b6a9e80a2f2f]$ mkdir datafile tempfile[oracle@oem132 fd9ac20f64d244d7e043b6a9e80a2f2f]$[oracle@oem132 STBY]$[oracle@oem132 STBY]$ cd /u01/app/oracle/fast_recovery_area[oracle@oem132 fast_recovery_area]$ mkdir STBY[oracle@oem132 fast_recovery_area]$ cd STBY[oracle@oem132 STBY]$ mkdir onlinelog[oracle@oem132 STBY]$ mkdir 44bbc69ce8f552aee053334ea8c07365[oracle@oem132 STBY]$ mkdir fd9ac20f64d244d7e043b6a9e80a2f2f[oracle@oem132 STBY]$ cd 44*[oracle@oem132 44bbc69ce8f552aee053334ea8c07365]$ mkdir onlinelog[oracle@oem132 44bbc69ce8f552aee053334ea8c07365]$ cd ../fd*[oracle@oem132 fd9ac20f64d244d7e043b6a9e80a2f2f]$ mkdir onlinelog[oracle@oem132 fd9ac20f64d244d7e043b6a9e80a2f2f]$[oracle@oem132 STBY]$ Note that the names of the two folders for the SEED and the PDB are in *lower

12cR1 RAC Posts — 6 :Running the Cluster Verification Utility

With a successful RAC Cluster, running the Cluster Verification Utility [oracle@collabn1 ~]$ cluvfy stage -post crsinst -n collabn1,collabn2Performing post-checks for cluster services setupChecking node reachability...Node reachability check passed from node "collabn1"Checking user equivalence...User equivalence check passed for user "oracle"Checking node connectivity...Checking hosts config file...Verification of the hosts config file successfulCheck: Node connectivity using interfaces on subnet "192.168.78.0"Node connectivity passed for subnet "192.168.78.0" with node(s) collabn2,collabn1TCP connectivity check passed for subnet "192.168.78.0"Check: Node connectivity using interfaces on subnet "172.16.100.0"Node connectivity passed for subnet "172.16.100.0" with node(s) collabn1,collabn2TCP connectivity check passed for subnet "172.16.100.0"Checking subnet mask consistency...Subnet mask consistency check passed for subnet "192.168.78.0".Subnet mask consistency check passed for subnet "172.16.100.0".Subnet mask consistency check passed.Node connectivity check passedChecking multicast communication...Checking subnet "172.16.100.0" for multicast communication with multicast group "224.0.0.251"...Check of subnet "172.16.100.0" for multicast communication with multicast group "224.0.0.251" passed.Check of multicast communication passed.Checking whether the ASM filter driver is active and