Earlier this week (10-April), I had done a Switchover from the 2node RAC database to a SingleInstance database.
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: 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: Selected log 6 for thread 1
Continuing the series of posts on the RAC/ASM to SingleInstance/FileSystem DataGuard configuration … With both instances RAC1 and RAC2 running, I have redo shipping from both instances to the single instance STBY.(In my test server with 3 VMs, it takes a number of minutes to have all 3 instances running and communicating with each other … so there are spurious ORA and TNS errors until the 3 instances have stabilized.
For some weird reason, I can not get my OpenVPN server to come up at boot time using systemd on an Ubuntu Linux 16.04 LTS server.
Most default installation guides for Grid Infrastructure will have you creating a DATA Disk Group during the install.
Building on a previous blog post (you could read it before or after this post), here’s a quick demo of a caveat or quirk with V$RMAN_BACKUP_JOB_DETAILS.