ADG 切换成snapshot遭遇ora 600，不能mount
本帖最后由 huqianhao 于 2013-12-12 20:55 编辑今天在ADG备库准备切换成snapshot standby，直接在open状态执行了切换命令，报错了。重启后，不能mount啦。求大神分析下原因及解决办法。是否可以不用重新搭建ADG就可以解决？
操作系统：Red Hat Enterprise Linux Server release 5.8
oracle版本：11.2.0.3.0（打11.2.0.3.8的PSU没打成功）
Grid版本：11.2.0.3.8
备库为单实例的，主库为RAC，版本为11.2.0.3.8SQL> alter database recover managed standby database cancel;
Database altered.
SQL> show db_reco
SP2-0158: unknown SHOW option "db_reco"
SQL> show parameter db_re
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +FRA
db_recovery_file_dest_size big integer 400G
db_recycle_cache_size big integer 0
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +FRA
Oldest online log sequence 46809
Next log sequence to archive 0
Current log sequence 46817
SQL>
SQL> alter database flashback on;
Database altered.
SQL> alter database convert to snapshot standby;
alter database convert to snapshot standby
*
ERROR at line 1:
ORA-01013: user requested cancel of current operation
SQL> alter database convert to snapshot standby;
alter database convert to snapshot standby
*
ERROR at line 1:
ORA-38784: Cannot create restore point 'SNAPSHOT_STANDBY_REQUIRED_12/12/2013 13:59:21'.
ORA-38788: More standby database recovery is needed
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size 2237776 bytes
Variable Size 2214595248 bytes
Database Buffers 8388608000 bytes
Redo Buffers 84033536 bytes
ORA-00600: internal error code, arguments: , , [], [], [], [], [], [], [], [],
[], []
SQL> select open_mode from v$database;
select open_mode from v$database
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> alter database convert to snapshot standby;
alter database convert to snapshot standby
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size 2237776 bytes
Variable Size 2214595248 bytes
Database Buffers 8388608000 bytes
Redo Buffers 84033536 bytes
ORA-00600: internal error code, arguments: , , [], [], [], [], [], [], [], [],
[], []
SQL> startup mount ;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size 2237776 bytes
Variable Size 2214595248 bytes
Database Buffers 8388608000 bytes
Redo Buffers 84033536 bytes
ORA-00600: internal error code, arguments: , , [], [], [], [], [], [], [], [],
[], [] alert 和trace日志见附件。 ODM FINDING:
Bug 13254862 ORA-600 mounting instance after NID
Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions BELOW 12.1
Versions confirmed as being affected
11.2.0.3
11.2.0.2
Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in
12.1.0.1 (Base Release)
11.2.0.4 (Future Patch Set)
Symptoms:
Related To:
Internal Error May Occur (ORA-600)
ORA-600
Physical Standby Database / Dataguard
Description
When creating a backup controlfile (including standby controlfile) from
a snapshot standby (ssby) controlfile, standby related fields are not
clean up properly. This can lead to problems such as an
ORA-600 when mounting an instance
after using NID.
With this fix if NID detected snapshot standby related fields in
controlfile, it prints an alert message and removes the snapshot
standby related fields.
Bugs fixed in the 11.2.0.4 Patch Set
中描述已修复 13254862
你也可以考虑打one-off patch Liu Maclean(刘相兵 发表于 2013-12-14 16:46 static/image/common/back.gif
Bugs fixed in the 11.2.0.4 Patch Set
中描述已修复 13254862
打过这个补丁，没效果，后来重新恢复啦 我的是单实例11.2.0.4版本，linux 5.8 64bi平台下，在执行alter database convert to snapshot standby;报ORA-38784 ORA-38788，还没查到问题 rongshiyuan 发表于 2014-9-28 11:23 static/image/common/back.gif
我的是单实例11.2.0.4版本，linux 5.8 64bi平台下，在执行alter database convert to snapshot standby;报O ...
最后发现与只读表空间有关，将其变成read write就可以convert to snapshot standby
页:
[1]