- 最后登录
- 2017-6-20
- 在线时间
- 12 小时
- 威望
- 0
- 金钱
- 110
- 注册时间
- 2013-1-14
- 阅读权限
- 10
- 帖子
- 28
- 精华
- 0
- 积分
- 0
- UID
- 865
|
1#
发表于 2013-3-1 17:13:48
|
查看: 3559 |
回复: 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...
|
|