DG ora-ORA-16016错误


备库无法打开:
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 unavailableWait 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

相关推荐: RAC_OCR管理的示例分析

这篇文章给大家介绍RAC_OCR管理的示例分析,内容非常详细,感兴趣的小伙伴们可以参考借鉴,希望对大家能有所帮助。管理OCROCR是Oracle RAC配置信息仓库,它管理集群节点的相关信息及实例到节点的映射信息。组成CRS的进程以及其他支持集群的应用程序使用…

免责声明:本站发布的图片视频文字,以转载和分享为主,文章观点不代表本站立场,本站不承担相关法律责任;如果涉及侵权请联系邮箱:360163164@qq.com举报,并提供相关证据,经查实将立刻删除涉嫌侵权内容。

(0)
打赏 微信扫一扫 微信扫一扫
上一篇 01/19 10:27
下一篇 01/19 10:28