{"id":634,"date":"2012-03-05T22:57:56","date_gmt":"2012-03-05T14:57:56","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=634"},"modified":"2012-03-07T23:25:13","modified_gmt":"2012-03-07T15:25:13","slug":"ora-6002758%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=634","title":{"rendered":"ORA-600(2758)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u6237\u6570\u636e\u5e93\u5f02\u5e38DOWN\u673a\uff0c\u5728\u542f\u52a8\u8fc7\u7a0b\u4e2d\u51fa\u73b0\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002<br \/>\n\u7531\u4e8e\u6389\u7535\u5bfc\u81f4\u4e86\u5ba2\u6237\u6570\u636e\u5e93\u51fa\u73b0\u4e86\u63a7\u5236\u6587\u4ef6\u7684\u4e0d\u4e00\u81f4\uff0c\u5c1d\u8bd5\u542f\u52a8\u62a5\u9519\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>SQL> startup\r\nORACLE instance started.\r\nTotal System Global Area 126950956 bytes\r\nFixed Size 454188 bytes\r\nVariable Size 92274688 bytes\r\nDatabase Buffers 33554432 bytes\r\nRedo Buffers 667648 bytes\r\n*\r\nORA-00214: controlfile 'D:\\ORACLE\\ORADATA\\SXXHDTS\\CONTROL03.CTL' version 2623 inconsistent with file 'D:\\ORACLE\\ORADATA\\SXXHDTS\\CONTROL02.CTL' version 2619<\/pre>\n<p>\u663e\u7136\u8fd9\u662f\u63a7\u5236\u6587\u4ef6\u4e0d\u4e00\u81f4\u5bfc\u81f4\u7684\uff0c\u5c06\u6700\u65b0\u7684\u63a7\u5236\u6587\u4ef6CONTROL03.CTL\u8986\u76d6\u8f83\u65e7\u7684CONTROL02.CTL\u548cCONTROL01.CTL\uff0c\u518d\u6b21\u5c1d\u8bd5\u6253\u5f00\uff0c\u62a5\u9519\u6570\u636e\u5e93\u9700\u8981\u6062\u590d\uff1a<\/p>\n<pre lang='SQL'>SQL> recover database;\r\nMedia recovery complete.\r\n\u7136\u540e\u5c1d\u8bd5\u6253\u5f00\u6570\u636e\u5e93\u78b0\u5230ORA-600[2758]\u9519\u8bef\uff1a\r\nSQL> alter database open;\r\nalter database open\r\n*\r\nERROR at line 1:\r\nORA-00600: internal error code, arguments: [2758], [1], [4294967295], [204800], [10], [], [], []<\/pre>\n<p>\u68c0\u67e5\u544a\u8b66\u65e5\u5fd7\uff0c\u53ef\u4ee5\u53d1\u73b0\u66f4\u591a\u7684\u4fe1\u606f\uff1a<\/p>\n<pre lang='SQL'>Mon Jan 09 12:02:08 2012\r\nStarting ORACLE instance (normal)\r\nLICENSE_MAX_SESSION = 0\r\nLICENSE_SESSIONS_WARNING = 0\r\nSCN scheme 2\r\nUsing log_archive_dest parameter default value\r\nLICENSE_MAX_USERS = 0\r\nSYS auditing is disabled\r\nStarting up ORACLE RDBMS Version: 9.2.0.1.0.\r\nSystem parameters with non-default values:\r\nprocesses = 150\r\ntimed_statistics = TRUE\r\nshared_pool_size = 50331648\r\nlarge_pool_size = 8388608\r\njava_pool_size = 33554432\r\ncontrol_files = D:\\oracle\\oradata\\sxxhdts\\CONTROL01.CTL, D:\\oracle\\oradata\\sxxhdts\\CONTROL02.CTL, D:\\oracle\\oradata\\sxxhdts\\CONTROL03.CTL\r\ndb_block_size = 8192\r\ndb_cache_size = 25165824\r\ncompatible = 9.2.0.0.0\r\ndb_file_multiblock_read_count= 16\r\nfast_start_mttr_target = 300\r\nundo_management = AUTO\r\nundo_tablespace = UNDOTBS1\r\nundo_retention = 10800\r\nremote_login_passwordfile= EXCLUSIVE\r\ndb_domain = \r\ninstance_name = sxxhdts\r\ndispatchers = (PROTOCOL=TCP) (SERVICE=sxxhdtsXDB)\r\njob_queue_processes = 10\r\nhash_join_enabled = TRUE\r\nbackground_dump_dest = D:\\oracle\\admin\\sxxhdts\\bdump\r\nuser_dump_dest = D:\\oracle\\admin\\sxxhdts\\udump\r\ncore_dump_dest = D:\\oracle\\admin\\sxxhdts\\cdump\r\nsort_area_size = 524288\r\ndb_name = sxxhdts\r\nopen_cursors = 300\r\nstar_transformation_enabled= FALSE\r\nquery_rewrite_enabled = FALSE\r\npga_aggregate_target = 25165824\r\naq_tm_processes = 1\r\nPMON started with pid=2\r\nDBW0 started with pid=3\r\nLGWR started with pid=4\r\nCKPT started with pid=5\r\nSMON started with pid=6\r\nRECO started with pid=7\r\nCJQ0 started with pid=8\r\nQMN0 started with pid=9\r\nMon Jan 09 12:02:11 2012\r\nstarting up 1 shared server(s) ...\r\nstarting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...\r\nMon Jan 09 12:02:19 2012\r\nalter database mount\r\nMon Jan 09 12:02:22 2012\r\nORA-214 signalled during: alter database mount...\r\nMon Jan 09 12:13:28 2012\r\nalter database mount\r\nMon Jan 09 12:13:31 2012\r\nORA-214 signalled during: alter database mount...\r\nMon Jan 09 12:39:11 2012\r\nalter database mount\r\nMon Jan 09 12:39:14 2012\r\nORA-214 signalled during: alter database mount\r\n...\r\nMon Jan 09 12:41:17 2012\r\nalter database mount\r\nMon Jan 09 12:41:21 2012\r\nSuccessful mount of redo thread 1, with mount id 633859757.\r\nMon Jan 09 12:41:21 2012\r\nDatabase mounted in Exclusive Mode.\r\nCompleted: alter database mount\r\nMon Jan 09 12:41:27 2012\r\nalter database open\r\nORA-1113 signalled during: alter database open...\r\nMon Jan 09 12:43:21 2012\r\nShutting down instance: further logons disabled\r\nShutting down instance (immediate)\r\nLicense high water mark = 4\r\nWaiting for dispatcher 'D000' to shutdown\r\nAll dispatchers and shared servers shutdown\r\nMon Jan 09 12:43:23 2012\r\nALTER DATABASE CLOSE NORMAL\r\nORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...\r\nMon Jan 09 12:43:23 2012\r\nALTER DATABASE DISMOUNT\r\nCompleted: ALTER DATABASE DISMOUNT\r\nARCH: Archiving is disabled\r\nShutting down archive processes\r\nArchiving is disabled\r\nArchive process shutdown avoided: 0 active\r\nARCH: Archiving is disabled\r\nShutting down archive processes\r\nArchiving is disabled\r\nArchive process shutdown avoided: 0 active\r\nMon Jan 09 12:45:57 2012\r\nStarting ORACLE instance (normal)\r\nLICENSE_MAX_SESSION = 0\r\nLICENSE_SESSIONS_WARNING = 0\r\nSCN scheme 2\r\nUsing log_archive_dest parameter default value\r\nLICENSE_MAX_USERS = 0\r\nSYS auditing is disabled\r\nStarting up ORACLE RDBMS Version: 9.2.0.1.0.\r\nSystem parameters with non-default values:\r\nprocesses = 150\r\ntimed_statistics = TRUE\r\nshared_pool_size = 50331648\r\nlarge_pool_size = 8388608\r\njava_pool_size = 33554432\r\n.\r\n.\r\n.\r\naq_tm_processes = 1\r\nPMON started with pid=2\r\nDBW0 started with pid=3\r\nLGWR started with pid=4\r\nCKPT started with pid=5\r\nSMON started with pid=6\r\nRECO started with pid=7\r\nCJQ0 started with pid=8\r\nQMN0 started with pid=9\r\nMon Jan 09 12:46:00 2012\r\nstarting up 1 shared server(s) ...\r\nstarting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...\r\nMon Jan 09 12:46:00 2012\r\nALTER DATABASE MOUNT\r\nMon Jan 09 12:46:04 2012\r\nSuccessful mount of redo thread 1, with mount id 633842120.\r\nMon Jan 09 12:46:04 2012\r\nDatabase mounted in Exclusive Mode.\r\nCompleted: ALTER DATABASE MOUNT\r\nMon Jan 09 12:52:21 2012\r\nALTER DATABASE RECOVER database \r\nMon Jan 09 12:52:21 2012\r\nMedia Recovery Start\r\nWARNING! Recovering data file 2 from a fuzzy backup. It might be an online\r\nbackup taken without entering the begin backup command.\r\nWARNING! Recovering data file 4 from a fuzzy backup. It might be an online\r\nbackup taken without entering the begin backup command.\r\nWARNING! Recovering data file 5 from a fuzzy backup. It might be an online\r\nbackup taken without entering the begin backup command.\r\nWARNING! Recovering data file 6 from a fuzzy backup. It might be an online\r\nbackup taken without entering the begin backup command.\r\nWARNING! Recovering data file 8 from a fuzzy backup. It might be an online\r\nbackup taken without entering the begin backup command.\r\nWARNING! Recovering data file 9 from a fuzzy backup. It might be an online\r\nbackup taken without entering the begin backup command.\r\nWARNING! Recovering data file 10 from a fuzzy backup. It might be an online\r\nbackup taken without entering the begin backup command.\r\nStarting datafile 2 recovery in thread 1 sequence 317\r\nDatafile 2: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\UNDOTBS01.DBF'\r\nStarting datafile 4 recovery in thread 1 sequence 317\r\nDatafile 4: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\DRSYS01.DBF'\r\nStarting datafile 5 recovery in thread 1 sequence 317\r\nDatafile 5: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\EXAMPLE01.DBF'\r\nStarting datafile 6 recovery in thread 1 sequence 317\r\nDatafile 6: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\INDX01.DBF'\r\nStarting datafile 8 recovery in thread 1 sequence 317\r\nDatafile 8: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\TOOLS01.DBF'\r\nStarting datafile 9 recovery in thread 1 sequence 317\r\nDatafile 9: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\USERS01.DBF'\r\nStarting datafile 10 recovery in thread 1 sequence 317\r\nDatafile 10: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\XDB01.DBF'\r\nMedia Recovery Log \r\nRecovery of Online Redo Log: Thread 1 Group 1 Seq 317 Reading mem 0\r\nMem# 0 errs 0: D:\\ORACLE\\ORADATA\\SXXHDTS\\REDO01.LOG\r\nMedia Recovery Complete\r\nCompleted: ALTER DATABASE RECOVER database \r\nMon Jan 09 12:52:32 2012\r\nalter database open\r\nMon Jan 09 12:52:32 2012\r\nThread 1 opened at log sequence 317\r\nCurrent log# 1 seq# 317 mem# 0: D:\\ORACLE\\ORADATA\\SXXHDTS\\REDO01.LOG\r\nSuccessful open of redo thread 1.\r\nMon Jan 09 12:52:32 2012\r\nErrors in file d:\\oracle\\admin\\sxxhdts\\bdump\\sxxhdts_lgwr_5956.trc:\r\nORA-00345: redo log write error block 4294967295 count 1\r\nORA-00312: online log 1 thread 1: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\REDO01.LOG'\r\nORA-27069: skgfdisp: attempt to do I\/O beyond the range of the file\r\nOSD-04026: \u4f20\u9012\u7684\u53c2\u6570\u65e0\u6548\u3002 (OS 4294967295)\r\nMon Jan 09 12:52:33 2012\r\nErrors in file d:\\oracle\\admin\\sxxhdts\\bdump\\sxxhdts_lgwr_5956.trc:\r\nORA-00340: IO error processing online log 1 of thread 1\r\nORA-00345: redo log write error block 4294967295 count 1\r\nORA-00312: online log 1 thread 1: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\REDO01.LOG'\r\nORA-27069: skgfdisp: attempt to do I\/O beyond the range of the file\r\nOSD-04026: \u4f20\u9012\u7684\u53c2\u6570\u65e0\u6548\u3002 (OS 4294967295)\r\nLGWR: terminating instance due to error 340\r\nMon Jan 09 12:52:33 2012\r\nErrors in file d:\\oracle\\admin\\sxxhdts\\bdump\\sxxhdts_pmon_4752.trc:\r\nORA-00340: IO error processing online log of thread \r\nInstance terminated by LGWR, pid = 5956\r\nMon Jan 09 13:02:04 2012\r\nStarting ORACLE instance (normal)\r\nLICENSE_MAX_SESSION = 0\r\nLICENSE_SESSIONS_WARNING = 0\r\nSCN scheme 2\r\nUsing log_archive_dest parameter default value\r\nLICENSE_MAX_USERS = 0\r\nSYS auditing is disabled\r\nStarting up ORACLE RDBMS Version: 9.2.0.1.0.\r\nSystem parameters with non-default values:\r\nprocesses = 150\r\ntimed_statistics = TRUE\r\nshared_pool_size = 50331648\r\n.\r\n.\r\n.\r\naq_tm_processes = 1\r\nPMON started with pid=2\r\nDBW0 started with pid=3\r\nLGWR started with pid=4\r\nCKPT started with pid=5\r\nSMON started with pid=6\r\nRECO started with pid=7\r\nCJQ0 started with pid=8\r\nQMN0 started with pid=9\r\nMon Jan 09 13:02:07 2012\r\nstarting up 1 shared server(s) ...\r\nstarting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...\r\nMon Jan 09 13:02:08 2012\r\nALTER DATABASE MOUNT\r\nMon Jan 09 13:02:12 2012\r\nSuccessful mount of redo thread 1, with mount id 633838736.\r\nMon Jan 09 13:02:12 2012\r\nDatabase mounted in Exclusive Mode.\r\nCompleted: ALTER DATABASE MOUNT\r\nMon Jan 09 13:02:24 2012\r\nalter database open\r\nMon Jan 09 13:02:25 2012\r\nBeginning crash recovery of 1 threads\r\nMon Jan 09 13:02:25 2012\r\nStarted first pass scan\r\nMon Jan 09 13:02:25 2012\r\nCompleted first pass scan\r\n0 redo blocks read, 0 data blocks need recovery\r\nMon Jan 09 13:02:25 2012\r\nStarted recovery at\r\nThread 1: logseq 317, block 4294967295, scn 0.22473385\r\nRecovery of Online Redo Log: Thread 1 Group 1 Seq 317 Reading mem 0\r\nMem# 0 errs 0: D:\\ORACLE\\ORADATA\\SXXHDTS\\REDO01.LOG\r\nMon Jan 09 13:02:25 2012\r\nEnded recovery at\r\nThread 1: logseq 317, block 4294967295, scn 0.22493386\r\n0 data blocks read, 0 data blocks written, 0 redo blocks read\r\nMon Jan 09 13:02:25 2012\r\nErrors in file d:\\oracle\\admin\\sxxhdts\\udump\\sxxhdts_ora_4844.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801\uff0c\u53c2\u6570: [2758], [1], [4294967295], [204800], [8], [], [], []\r\nORA-600 signalled during: alter database open\r\n...<\/pre>\n<p>\u544a\u8b66\u65e5\u5fd7\u4e2d\u4e8b\u5b9e\u4e0a\u8bb0\u5f55\u4e86\u66f4\u5b8c\u6574\u7684\u4fe1\u606f\uff0c\u5728\u7b2c\u4e00\u6b21\u5c1d\u8bd5\u6253\u5f00\u6570\u636e\u5e93\u7684\u65f6\u5019\uff0c\u62a5\u9519\u4fe1\u606f\u66f4\u5c06\u8be6\u5c3d\uff0c\u6307\u51faOracle\u5c1d\u8bd5\u5728\u5199REDO01.LOG\u65e5\u5fd7\u65f6\uff0c\u8fd4\u56de\u4e86\u64cd\u4f5c\u7cfb\u7edf\u9519\u8bef\u3002\u800cOracle\u5c1d\u8bd5\u5199\u7684REDO\u7684\u4f4d\u7f6e\u6070\u597d\u662f4G-1\uff0c\u5982\u679c\u5bf9\u6bd4\u7b2c\u4e8c\u6b21\u6253\u5f00\u65f6ORA-600\u9519\u8bef\u7684\u4fe1\u606f\uff0c\u5c31\u53ef\u4ee5\u770b\u5230\uff0c\u4e8b\u5b9e\u4e0a\u4e24\u6b21\u62a5\u9519\u63cf\u8ff0\u7684\u662f\u76f8\u540c\u7684\u95ee\u9898\u30022758\u9519\u8bef\u7684\u7b2c\u4e8c\u4e2a\u53c2\u65701\u6307\u7684\u5c31\u662fGROUP 1\uff0c\u800c4294967295\u5c31\u662f\u524d\u9762\u62a5\u9519\u7684\u4fe1\u606f\u3002<br \/>\n\u663e\u7136\u5bfc\u81f4\u9519\u8bef\u7684\u539f\u56e0\u662f\u7531\u4e8eOracle\u5728\u5199\u65e5\u5fd7\u65f6\u51fa\u73b0\u4e86\u9519\u8bef\u3002\u7531\u4e8e\u6570\u636e\u5e93\u6ca1\u6709\u6253\u5f00\uff0c\u65e0\u6cd5\u6e05\u9664\u65e5\u5fd7\u6587\u4ef6\uff0c\u6240\u4ee5\u5e38\u89c4\u624b\u6bb5\u4e0d\u8d77\u4f5c\u7528\u3002<br \/>\n\u9664\u4e86\u901a\u8fc7BBED\u4fee\u6539\u63a7\u5236\u6587\u4ef6\u4e2d\u7684\u4fe1\u606f\u5916\uff0c\u8fd8\u53ef\u4ee5\u901a\u8fc7\u66f4\u5e38\u89c4\u4e00\u70b9\u7684\u624b\u6bb5\uff0c\u901a\u8fc7\u6dfb\u52a0\u9690\u542b\u53c2\u6570\u6765\u89e3\u51b3\uff1a<\/p>\n<pre lang='SQL'>Mon Jan 09 14:05:43 2012\r\nStarting ORACLE instance (normal)\r\nLICENSE_MAX_SESSION = 0\r\nLICENSE_SESSIONS_WARNING = 0\r\nSCN scheme 2\r\nUsing log_archive_dest parameter default value\r\nLICENSE_MAX_USERS = 0\r\nSYS auditing is disabled\r\nStarting up ORACLE RDBMS Version: 9.2.0.1.0.\r\nSystem parameters with non-default values:\r\nprocesses = 150\r\ntimed_statistics = TRUE\r\nshared_pool_size = 50331648\r\nlarge_pool_size = 8388608\r\njava_pool_size = 33554432\r\ncontrol_files = D:\\oracle\\oradata\\sxxhdts\\CONTROL01.CTL, D:\\oracle\\oradata\\sxxhdts\\CONTROL02.CTL, D:\\oracle\\oradata\\sxxhdts\\CONTROL03.CTL\r\ndb_block_size = 8192\r\ndb_cache_size = 25165824\r\ncompatible = 9.2.0.0.0\r\ndb_file_multiblock_read_count= 16\r\nfast_start_mttr_target = 300\r\n_allow_resetlogs_corruption= TRUE\r\nundo_management = AUTO\r\n.\r\n.\r\n.\r\naq_tm_processes = 1\r\nPMON started with pid=2\r\nDBW0 started with pid=3\r\nLGWR started with pid=4\r\nCKPT started with pid=5\r\nSMON started with pid=6\r\nRECO started with pid=7\r\nCJQ0 started with pid=8\r\nQMN0 started with pid=9\r\nMon Jan 09 14:05:46 2012\r\nstarting up 1 shared server(s) ...\r\nstarting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...\r\nMon Jan 09 14:05:47 2012\r\nALTER DATABASE MOUNT\r\nMon Jan 09 14:05:51 2012\r\nSuccessful mount of redo thread 1, with mount id 633898875.\r\nMon Jan 09 14:05:51 2012\r\nDatabase mounted in Exclusive Mode.\r\nCompleted: ALTER DATABASE MOUNT\r\nMon Jan 09 14:07:06 2012\r\nALTER DATABASE RECOVER database until cancel \r\nMon Jan 09 14:07:06 2012\r\nMedia Recovery Start\r\nMedia Recovery Not Required\r\nCompleted: ALTER DATABASE RECOVER database until cancel \r\nMon Jan 09 14:10:06 2012\r\nALTER DATABASE RECOVER database using backup controlfile until cancel \r\nMon Jan 09 14:10:06 2012\r\nMedia Recovery Start\r\nStarting datafile 1 recovery in thread 1 sequence 317\r\nDatafile 1: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\SYSTEM01.DBF'\r\nStarting datafile 2 recovery in thread 1 sequence 317\r\nDatafile 2: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\UNDOTBS01.DBF'\r\nStarting datafile 3 recovery in thread 1 sequence 317\r\nDatafile 3: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\CWMLITE01.DBF'\r\nStarting datafile 4 recovery in thread 1 sequence 317\r\nDatafile 4: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\DRSYS01.DBF'\r\nStarting datafile 5 recovery in thread 1 sequence 317\r\nDatafile 5: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\EXAMPLE01.DBF'\r\nStarting datafile 6 recovery in thread 1 sequence 317\r\nDatafile 6: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\INDX01.DBF'\r\nStarting datafile 7 recovery in thread 1 sequence 317\r\nDatafile 7: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\ODM01.DBF'\r\nStarting datafile 8 recovery in thread 1 sequence 317\r\nDatafile 8: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\TOOLS01.DBF'\r\nStarting datafile 9 recovery in thread 1 sequence 317\r\nDatafile 9: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\USERS01.DBF'\r\nStarting datafile 10 recovery in thread 1 sequence 317\r\nDatafile 10: 'D:\\ORACLE\\ORADATA\\SXXHDTS\\XDB01.DBF'\r\nMedia Recovery Log \r\nORA-279 signalled during: ALTER DATABASE RECOVER database using backup con...\r\nMon Jan 09 14:10:13 2012\r\nALTER DATABASE RECOVER CANCEL \r\nMedia Recovery Cancelled\r\nCompleted: ALTER DATABASE RECOVER CANCEL \r\nMon Jan 09 14:10:27 2012\r\nalter database open resetlogs\r\nMon Jan 09 14:10:27 2012\r\nRESETLOGS is being done without consistancy checks. This may result\r\nin a corrupted database. The database should be recreated.\r\nRESETLOGS after incomplete recovery UNTIL CHANGE 22473386\r\nResetting resetlogs activation ID 615377539 (0x24adea83)\r\nMon Jan 09 14:10:30 2012\r\nAssigning activation ID 633898875 (0x25c8877b)\r\nThread 1 opened at log sequence 1\r\nCurrent log# 1 seq# 1 mem# 0: D:\\ORACLE\\ORADATA\\SXXHDTS\\REDO01.LOG\r\nSuccessful open of redo thread 1.\r\nMon Jan 09 14:10:30 2012\r\nSMON: enabling cache recovery\r\nMon Jan 09 14:10:31 2012\r\nUndo Segment 1 Onlined\r\nUndo Segment 2 Onlined\r\nUndo Segment 3 Onlined\r\nUndo Segment 4 Onlined\r\nUndo Segment 5 Onlined\r\nUndo Segment 6 Onlined\r\nUndo Segment 7 Onlined\r\nUndo Segment 8 Onlined\r\nUndo Segment 9 Onlined\r\nUndo Segment 10 Onlined\r\nSuccessfully onlined Undo Tablespace 1.\r\nDictionary check beginning\r\nDictionary check complete\r\nMon Jan 09 14:10:31 2012\r\nSMON: enabling tx recovery\r\nMon Jan 09 14:10:31 2012\r\nDatabase Characterset is ZHS16GBK\r\nreplication_dependency_tracking turned off (no async multimaster replication found)\r\nCompleted: alter database open resetlogs<\/pre>\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u901a\u8fc7\u8bbe\u7f6e\u9690\u542b\u53c2\u6570_allow_resetlogs_corruption\u4e3aTRUE\uff0c\u5e76\u6267\u884c\u4e0d\u5b8c\u5168\u6062\u590d\uff0c\u6210\u529f\u6253\u5f00\u4e86\u6570\u636e\u5e93\u3002<br \/>\n\u5176\u5b9e\u8fd9\u79cd\u65b9\u5f0f\u5e76\u6ca1\u6709\u9020\u6210\u6570\u636e\u7684\u635f\u5931\uff0c\u53ea\u662f\u907f\u514d\u4e86\u6570\u636e\u5e93\u5728\u6253\u5f00\u7684\u65f6\u5019\u5c1d\u8bd5\u5728\u9519\u8bef\u7684\u504f\u79fb\u91cf\u4e0a\u53bb\u5bf9REDO\u8fdb\u884c\u5199\u64cd\u4f5c\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u6570\u636e\u5e93\u5f02\u5e38DOWN\u673a\uff0c\u5728\u542f\u52a8\u8fc7\u7a0b\u4e2d\u51fa\u73b0\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002 \u7531\u4e8e\u6389\u7535\u5bfc\u81f4\u4e86\u5ba2\u6237\u6570\u636e\u5e93\u51fa\u73b0\u4e86\u63a7\u5236\u6587\u4ef6\u7684\u4e0d\u4e00\u81f4\uff0c\u5c1d\u8bd5\u542f\u52a8\u62a5\u9519\u5982\u4e0b\uff1a SQL> startup ORACLE instance started. Total System Global Area 126950956 bytes Fixed Size 454188 bytes Variable Size 92274688 bytes Database Buffers 33554432 bytes Redo Buffers 667648 bytes * ORA-00214: controlfile &#8216;D:\\ORACLE\\ORADATA\\SXXHDTS\\CONTROL03.CTL&#8217; version 2623 inconsistent with file &#8216;D:\\ORACLE\\ORADATA\\SXXHDTS\\CONTROL02.CTL&#8217; version &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=634\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[511,512,517,513,514,515,8,516,486,509],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-ae","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/634"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=634"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/634\/revisions"}],"predecessor-version":[{"id":635,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/634\/revisions\/635"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}