备库无法打开:sql> alter database open;alter database open*ERROR at line 1:ORA-10458: standby database requ
备库无法打开:
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
--结束END--
本文标题: DG ora-ORA-16016错误
本文链接: https://lsjlt.com/news/42531.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
2024-10-23
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0