Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

9

主题
1#
发表于 2013-3-1 17:13:48 | 查看: 3558| 回复: 2
本帖最后由 zxjlqh 于 2013-3-1 17:15 编辑

环境:版本11.2.0.3
双节点rac+单standby

切换前,把RAC节点2已关闭掉,只留下节点1.
切换结束后,新primary顺利打开,rac节点1只能到mount,不能alter database open read only;

日志输出:

Fri Mar 01 17:08:41 2013
alter database open read only
This instance was first to open
Beginning standby crash recovery.
Serial Media Recovery started
Fri Mar 01 17:08:41 2013
Managed Standby Recovery starting Real Time Apply
Media Recovery Waiting for thread 2 sequence 148
Fri Mar 01 17:09:44 2013
Standby crash recovery need archive log for thread 2 sequence 148 to continue.
Please verify that primary database is transporting redo logs to the standby database.
Wait timeout: thread 2 sequence 148
Standby crash recovery aborted due to error 16016.
Errors in file /u01/app/oracle/diag/rdbms/thirdb/thirdb1/trace/thirdb1_ora_20324.trc:
ORA-16016: 线程 2 sequence# 148 的归档日志不可用
Recovery interrupted!
Completed standby crash recovery.
Abort recovery for domain 0
Errors in file /u01/app/oracle/diag/rdbms/thirdb/thirdb1/trace/thirdb1_ora_20324.trc:
ORA-10458: standby database requires recovery
ORA-01194: 文件 1 需要更多的恢复来保持一致性
ORA-01110: 数据文件 1: '+DATA02/thirdb/datafile/system.272.804163627'
ORA-10458 signalled during: alter database open read only...





2#
发表于 2013-3-1 17:40:22
原来的primary 的redo还有未同步过来的,把原来primary的归档、redo通过拷贝及flush刷到新的primary库上,然后apply。最后open。

回复 只看该作者 道具 举报

3#
发表于 2013-3-4 09:41:34
我还是搞不定,能QQ远程协助搞下吗?17409585

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 10:15 , Processed in 0.063784 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569