Hi ALL,
11gR2
OL6
I have PRIMARY and STANDBY databases.
I want to test my standby to be activated permanently just for testing purposes, without disrupting or disturbing the primary (PROD) database
My goal is to have two primary database co-existing.
I want to do the following:
Forced Database Failover changes one standby database to a primary database. Application data may be lost neccessitating the reinstantiation of the primary and all standby databases.
Are the following commands applicable?
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
ALTER DATABASE ACTIVATE STANDBY DATABASE;
I tried them but I got error:
SQL>
SQL> RECOVER MANAGED STANDBY DATABASE CANCEL;
Media recovery complete.
SQL>
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-00314: log 4 of thread 1, expected sequence# 11576 doesn't match 11423
ORA-00312: online log 4 thread 1: '/home/oraprod/PROD/data/stby2.log'
SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;
ALTER DATABASE ACTIVATE STANDBY DATABASE
*
ERROR at line 1:
ORA-00314: log 4 of thread 1, expected sequence# 11576 doesn't match 11423
ORA-00312: online log 4 thread 1: '/home/oraprod/PROD/data/stby2.log'
Please help...
Kind regards,
jc