ADG 切换成snapshot遭遇ora 600，不能mount

huqianhao

今天在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.8

1. SQL> alter database recover managed standby database cancel;
   
2. 
   
3. Database altered.
   
4. 
   
5. SQL> show db_reco
   
6. SP2-0158: unknown SHOW option "db_reco"
   
7. SQL> show parameter db_re
   
8. 
   
9. NAME                                     TYPE         VALUE
   
10. ------------------------------------ ----------- ------------------------------
    
11. db_recovery_file_dest                     string         +FRA
    
12. db_recovery_file_dest_size             big integer 400G
    
13. db_recycle_cache_size                     big integer 0
    
14. SQL> archive log list
    
15. Database log mode               Archive Mode
    
16. Automatic archival               Enabled
    
17. Archive destination               +FRA
    
18. Oldest online log sequence     46809
    
19. Next log sequence to archive   0
    
20. Current log sequence               46817
    
21. SQL>
    
22. SQL> alter database flashback on;
    
23. 
    
24. Database altered.
    
25. 
    
26. SQL> alter database convert to snapshot standby;
    
27. alter database convert to snapshot standby
    
28. *
    
29. ERROR at line 1:
    
30. ORA-01013: user requested cancel of current operation
    
31. 
    
32. 
    
33. 
    
34. SQL> alter database convert to snapshot standby;
    
35. alter database convert to snapshot standby
    
36. *
    
37. ERROR at line 1:
    
38. ORA-38784: Cannot create restore point 'SNAPSHOT_STANDBY_REQUIRED_12/12/2013 13:59:21'.
    
39. ORA-38788: More standby database recovery is needed
    
40. 
    
41. 
    
42. SQL> shutdown immediate
    
43. ORA-01109: database not open
    
44. 
    
45. 
    
46. Database dismounted.
    
47. ORACLE instance shut down.
    
48. SQL> startup mount;
    
49. ORACLE instance started.
    
50. 
    
51. Total System Global Area 1.0689E+10 bytes
    
52. Fixed Size                    2237776 bytes
    
53. Variable Size                 2214595248 bytes
    
54. Database Buffers         8388608000 bytes
    
55. Redo Buffers                   84033536 bytes
    
56. ORA-00600: internal error code, arguments: [control file RSBY_RDI/IC mismatch], [0], [], [], [], [], [], [], [], [],
    
57. [], []
    
58. 
    
59. 
    
60. SQL> select open_mode from v$database;
    
61. select open_mode from v$database
    
62.                       *
    
63. ERROR at line 1:
    
64. ORA-01507: database not mounted
    
65. 
    
66. 
    
67. SQL> alter database convert to snapshot standby;
    
68. alter database convert to snapshot standby
    
69. *
    
70. ERROR at line 1:
    
71. ORA-01507: database not mounted
    
72. 
    
73. 
    
74. SQL> shutdown immediate;
    
75. ORA-01507: database not mounted
    
76. 
    
77. 
    
78. ORACLE instance shut down.
    
79. SQL> startup mount
    
80. ORACLE instance started.
    
81. 
    
82. Total System Global Area 1.0689E+10 bytes
    
83. Fixed Size                    2237776 bytes
    
84. Variable Size                 2214595248 bytes
    
85. Database Buffers         8388608000 bytes
    
86. Redo Buffers                   84033536 bytes
    
87. ORA-00600: internal error code, arguments: [control file RSBY_RDI/IC mismatch], [0], [], [], [], [], [], [], [], [],
    
88. [], []
    
89. 
    
90. 
    
91. SQL> startup mount ;
    
92. ORA-01081: cannot start already-running ORACLE - shut it down first
    
93. SQL> shutdown immediate;
    
94. ORA-01507: database not mounted
    
95. 
    
96. 
    
97. ORACLE instance shut down.
    
98. SQL> startup mount;
    
99. ORACLE instance started.
    
100. 
     
101. Total System Global Area 1.0689E+10 bytes
     
102. Fixed Size                    2237776 bytes
     
103. Variable Size                 2214595248 bytes
     
104. Database Buffers         8388608000 bytes
     
105. Redo Buffers                   84033536 bytes
     
106. ORA-00600: internal error code, arguments: [control file RSBY_RDI/IC mismatch], [0], [], [], [], [], [], [], [], [],
     
107. [], []

复制代码

huqianhao

alert 和trace日志见附件。 12-12 log.rar (1018.55 KB, 下载次数: 1631)

2013-12-12 20:59 上传

点击文件名下载附件

Liu Maclean(刘相兵

ODM FINDING:
Bug 13254862  ORA-600 [control file RSBY_RDI/IC mismatch] 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 [control file RSBY_RDI/IC mismatch]

       

    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 [control file RSBY_RDI/IC mismatch] 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.
     

Liu Maclean(刘相兵

Bugs fixed in the 11.2.0.4 Patch Set

中描述已修复 13254862  

你也可以考虑打one-off patch

huqianhao

Liu Maclean(刘相兵 发表于 2013-12-14 16:46
Bugs fixed in the 11.2.0.4 Patch Set

中描述已修复 13254862  

打过这个补丁，没效果，后来重新恢复啦

rongshiyuan

我的是单实例11.2.0.4版本，linux 5.8 64bi平台下，在执行alter database convert to snapshot standby;报ORA-38784 ORA-38788，还没查到问题

rongshiyuan

rongshiyuan 发表于 2014-9-28 11:23
我的是单实例11.2.0.4版本，linux 5.8 64bi平台下，在执行alter database convert to snapshot standby;报O ...

最后发现与只读表空间有关，将其变成read write就可以convert to snapshot standby