Database Backup and Recovery (MOSC)

MOSC Banner

Restore RMAN from backup standby

edited Mar 22, 2012 2:49PM in Database Backup and Recovery (MOSC) 2 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center