Restore RMAN from backup standby
Hi expertsMy production and standby database version 10.2.0.3 on AIX system not RAC. I use backup RMAN on standby, control file auto backup on standby.
My error, after recover database from backup. I don't active standby database to primary or open read only.
- database role
SQL> select database_role from v$database;
DATABASE_ROLE
----------------
PHYSICAL STANDBY
- status online redo logs
SQL> SELECT to_char(first_change#), archived, status FROM v$log WHERE THREAD#=1 ORDER BY First_change#;
TO_CHAR(FIRST_CHANGE#) ARC STATUS
---------------------------------------- --- ----------------
5992054520741 YES CLEARING
5992054682402 YES CLEARING
5992054688864 YES CLEARING
5992054688961 YES CLEARING
6029636397266 YES CLEARING_CURRENT
- This is my error
My error, after recover database from backup. I don't active standby database to primary or open read only.
- database role
SQL> select database_role from v$database;
DATABASE_ROLE
----------------
PHYSICAL STANDBY
- status online redo logs
SQL> SELECT to_char(first_change#), archived, status FROM v$log WHERE THREAD#=1 ORDER BY First_change#;
TO_CHAR(FIRST_CHANGE#) ARC STATUS
---------------------------------------- --- ----------------
5992054520741 YES CLEARING
5992054682402 YES CLEARING
5992054688864 YES CLEARING
5992054688961 YES CLEARING
6029636397266 YES CLEARING_CURRENT
- This is my error
0