Dear ALL DG EXPERTS,
CRMS - Primary - (Flashback option NOT enabled)
STBYCRMS - Standby - (Flashback option enabled)
>> On Primary relocated all online redo log files
$ mv redo0* /tmp
SQL> alter system switch logfile;
System altered.
>> Error from alert log of Primary database
Wed May 04 16:39:42 2016
Errors in file /u01/app/oracle/diag/rdbms/crms/crms/trace/crms_arc2_5403.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/crms/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
>> Failover process
DGMGRL> connect sys/passwd@STBY_CRMSDB
DGMGRL> failover to stbycrms;
Performing failover NOW, please wait...
Failover succeeded, new primary is "stbycrms"
SQL> select standby_became_primary_scn from v$database;
STANDBY_BECAME_PRIMARY_SCN
--------------------------
1065790
>> now primary is down
SQL> shutdown abort;
ORACLE instance shut down.
Do not want rebuild once again. I am looking for some good options to make (former primary database) as standby database.
Without flashback option on primary db , i am struggling to move forward.
Could anyone help me to resolve this ?