{"id":1085,"date":"2015-12-22T13:50:07","date_gmt":"2015-12-22T05:50:07","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=1085"},"modified":"2015-12-22T14:01:39","modified_gmt":"2015-12-22T06:01:39","slug":"oracle11g%e5%a4%87%e5%ba%93%e6%8a%a5ora-00367%e5%92%8cora-19527%e7%9a%84%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=1085","title":{"rendered":"Oracle11g\u5907\u5e93\u62a5ORA-00367\u548cORA-19527\u7684\u95ee\u9898"},"content":{"rendered":"

\u9996\u5148\u770b\u4e00\u4e0balter.log\u6587\u4ef6\u4e2d\u7684\u9519\u8bef\u4fe1\u606f(\u7247\u6bb5):
\nTue Dec 22 06:00:47 2015<\/em>
\n SRL log 13 needs clearing because log has not been created<\/em>
\n Errors in file \/app\/sungard\/oracle\/diag\/rdbms\/futures8_standby\/futures8\/trace\/futures8_rfs_29400.trc:<\/em>
\n ORA-00367: checksum error in log file header<\/em>
\n ORA-00315: log 13 of thread 0, wrong thread # 1 in header<\/em>
\n ORA-00312: online log 13 thread 0: ‘\/ora_data\/oradata\/futures8_standby\/redo03.log’<\/em>
\n SRL log 14 needs clearing because log has not been created<\/em>
\n Errors in file \/app\/sungard\/oracle\/diag\/rdbms\/futures8_standby\/futures8\/trace\/futures8_rfs_29400.trc:<\/em>
\n ORA-00367: checksum error in log file header<\/em>
\n ORA-00315: log 14 of thread 0, wrong thread # 1 in header<\/em>
\n ORA-00312: online log 14 thread 0: \u2018\/ora_data\/oradata\/futures8_standby\/redo04.log’<\/em><\/p>\n

Oracle\u5b98\u65b9\u7ed9\u51fa\u7684\u5f15\u8d77\u8fd9\u4e09\u4e2a\u9519\u7684\u539f\u56e0\u548c\u5904\u7406\u7684\u529e\u6cd5:
\n—————————————————————————————-<\/em>
\n Error: ORA-00367<\/em>
\n Cause: The file header for the redo log contains a checksum that does not match<\/em>
\n the value calculated from the file header as read from disk. This means<\/em>
\n the file header is corrupted<\/em>
\n Action: Find the correct file and try again.<\/em>
\n —————————————————————————————-<\/em>
\n Error: ORA-00315<\/em>
\n Cause: The online log is corrupted or is an old version.<\/em>
\n Action: Find and install correct version of log or reset logs.<\/em>
\n —————————————————————————————-<\/em>
\n Error: ORA-00312<\/em>
\n Cause: The control file change sequence number in the log file is greater<\/em>
\n than the number in the control file. This implies that the wrong control<\/em>
\n file is being used. Note that repeatedly causing this error can make it<\/em>
\n stop happening without correcting the real problem.<\/em>
\n Action: Use the current control file or do backup control file recovery to make the<\/em>
\n control file current. Be sure to follow all restrictions on doing a backup<\/em>
\n control file recovery.<\/em>
\n —————————————————————————————-<\/em><\/p>\n

\u6839\u636e\u5b98\u65b9\u63d0\u793a\u53ef\u4ee5\u770b\u51fa,\u662f\u56e0\u4e3a\u63a7\u5236\u6587\u4ef6\u4e2d\u8bb0\u5f55\u7684SCN\u5c0f\u4e8e\u65e5\u5fd7\u6587\u4ef6\u5934\u90e8\u8bb0\u5f55\u7684SCN\u5f15\u8d77\u7684,\u4ece\u800c\u9700\u8981\u901a\u8fc7\u8fd8\u539f\u6700\u65b0\u7684\u63a7\u5236\u6587\u4ef6\u6765\u89e3\u51b3;\u8fd9\u79cd\u65b9\u5f0f\u662f\u975e\u5e38\u9ebb\u70e6\u7684,\u8fd8\u9700\u8981\u8fd8\u539f\u6570\u636e\u6587\u4ef6\u5e76\u4ee5resetlogs\u7684\u65b9\u5f0f\u6253\u5f00;
\n\u9664\u4e86\u4ee5\u4e0a\u529e\u6cd5,\u8fd8\u53ef\u4ee5\u901a\u8fc7\u6e05\u7a7a\u65e5\u5fd7\u6587\u4ef6\u7684\u65b9\u5f0f,\u6765\u540c\u6b65\u63a7\u5236\u6587\u4ef6\u548c\u65e5\u5fd7\u5934SCN:
\nALTER DATABASE CLEAR LOGFILE GROUP 13;<\/em><\/p>\n

\u547d\u4ee4\u6267\u884c\u4e4b\u540e\u4f1a\u62a5\u53e6\u5916\u7684\u9519\u8bef:
\nORA-19527: physical standby redo log must be renamed <\/em>
\nORA-00312: online log 13 thread 0: \u2018\/ora_data\/oradata\/futures8_standby\/redo03.log’<\/em><\/p>\n

\u8fd9\u4e2a\u9519\u8bef\u662f10gR2\u4e4b\u540e\u529f\u80fd\u7684\u589e\u5f3a\u5f15\u8d77\u7684:\u5728\u505a\u4e3b\u5907\u5207\u6362\u7684\u65f6\u5019,\u9700\u8981\u5c06\u5907\u5e93\u7684\u8054\u673a\u65e5\u5fd7\u6587\u4ef6\u6e05\u9664(CLEAR ONLINE REDO LOGFILE),\u4e3a\u4e86\u52a0\u5febSWITCHOVER\u7684\u901f\u5ea6,Oracle10gR2\u4e4b\u540e\u5728\u5c06\u5907\u5e93\u7f6e\u4e8eMANGED STANDBY\u72b6\u6001\u7684\u65f6\u5019\u5c31\u63d0\u524d\u5c06\u8fd9\u4e2aCLEAR\u7684\u52a8\u4f5c\u505a\u4e86\uff0c\u8fd9\u4e2a\u60f3\u6cd5\u662f\u597d\u7684\uff0c\u53ea\u662f\u5b9e\u73b0\u6709\u70b9\u7cdf\u7cd5,\u7136\u540e\u4f1a\u5728alert.log\u6587\u4ef6\u91cc\u8bb0\u5f55\u9519\u8bef\u4e00\u5806\u9519\u8bef;
\nThis is in fact an Enhancement to the Data Guard Technology introduced in 10.2.0.<\/em>
\nThe Goal here is to improve speed of Switchover and Failover. In previous Versions a Role Transition would require to clear the Online Redo Logfiles before it can become a Primary Database. Now we attempt to clear the Online Redo Logfiles when starting Managed Recovery.<\/em>
\nIf the Files exist then they will be cleared, but if they do not exist we report the Error, attempts to create the Online Redo Logfiles and starts Recovery. Even if this is not possible because of different Structure and log_file_name_convert is not set, MRP does not fail; it only raises these Errors.<\/em>
\nAs an extra Enhancement if the Online Redologs do exist you must specify the log_file_name_convert Parameter even if there is no difference in the Name. This has been implemented to reduce the chances that the Primary Online Redologs are cleared when MRP starts. It is the equivalent of asking – Are you sure you want the logs to be called this….<\/em>
\nIf the log_file_name_convert parameter is not set then the ORA-19527 is reported and the log file is not cleared at this time..<\/em>
\nSolution to stop both of these errors is to ensure log_file_name_convert is set correctly. If the File Structure is the same on the Primary and Standby Database you can set log_file_name_convert to a dummy Value;<\/em><\/p>\n

\u597d\u5728\u7ed9\u51fa\u4e86\u89e3\u51b3\u529e\u6cd5,\u53ea\u9700\u8981\u8bbe\u7f6eLOG_FILE_NAME_CONVERT\u53c2\u6570\u5373\u53ef,\u5373\u4fbf\u662f\u4e3b\u5907\u76ee\u5f55\u662f\u4e00\u81f4\u7684,\u90a3\u4e48\u5b8c\u6574\u7684\u89e3\u51b3\u529e\u6cd5\u5982\u4e0b:
\nALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;<\/em>
\nALTER SYSTEM SET LOG_FILE_NAME_CONVERT=’\/ora_data\/oradata\/futures8\/’,’\/ora_data\/oradata\/futures8\/’,’\/ora_data\/oradata\/futures8_standby\/’,’\/ora_data\/oradata\/futures8_standby\/’ SCOPE=SPFILE;<\/em>
\nSTARTUP IMMEDIATE;<\/em>
\nSTARTUP MOUNT;<\/em>
\nALTER DATABASE CLEAR LOGFILE GROUP 13;<\/em>
\nALTER DATABASE CLEAR LOGFILE GROUP 14;<\/em>
\nALTER DATABASE CLEAR LOGFILE GROUP 15;<\/em>
\nALTER DATABASE CLEAR LOGFILE GROUP 16;<\/em>
\nALTER DATABASE CLEAR LOGFILE GROUP 17;<\/em>
\nALTER DATABASE CLEAR LOGFILE GROUP 18;<\/em>
\nALTER DATABASE RECOVER MANAGED STANDBY DATABASE [USING CURRENT LOGFILE] DISCONNECT FROM SESSION;<\/em>
\n\u53c2\u8003\u6587\u6863:Note 1532566.1, Note 352879.1<\/p>\n","protected":false},"excerpt":{"rendered":"

\u9996\u5148\u770b\u4e00\u4e0balter.log\u6587\u4ef6\u4e2d\u7684\u9519\u8bef\u4fe1\u606f(\u7247\u6bb5): Tue Dec 22 06:00:47 2015 SR […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[34],"class_list":["post-1085","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1085","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1085"}],"version-history":[{"count":4,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1085\/revisions"}],"predecessor-version":[{"id":1090,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1085\/revisions\/1090"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1085"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}