备库无法打开:
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-10458: standby database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '+DATA/phub/datafile/system.258.884216521'
日志报错:
Standby Crash Recovery aborted due to error 16016.
Errors in file /u01/app/oracle/admin/PHUB/diag/rdbms/phub/PHUB/trace/PHUB_ora_5643.trc:
ORA-16016: archived log for thread 1 sequence# 16 unavailable
Wait timeout: thread 2 sequence 14
Standby Crash Recovery aborted due to error 16016.
Errors in file /u01/app/oracle/admin/PHUB/diag/rdbms/phub/PHUB/trace/PHUB_ora_5971.trc:
ORA-16016: archived log for thread 2 sequence# 14 unavailable
从主库上把这两个日志拷贝到备库:
然后注册;
SQL> alter database register physical logfile '/home/oracle/thread_1_seq_16.365.883970323';
Database altered.
SQL> alter database register physical logfile '/home/oracle/thread_2_seq_14.363.884216233';
Database altered.
再open 数据库;
SQL> alter database open;
Database altered.
后台日志:
Beginning Standby Crash Recovery.
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
Sun Jul 05 00:33:32 2015
Media Recovery Log /home/oracle/thread_1_seq_16.365.883970323
Media Recovery Log /home/oracle/thread_2_seq_14.363.884216233
Incomplete Recovery applied until change 43399676704 time 07/02/2015 03:17:58
Completed Standby Crash Recovery.
Sun Jul 05 00:33:34 2015
SMON: enabling cache recovery
Dictionary check beginning
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。