{"id":111,"date":"2017-12-22T10:20:35","date_gmt":"2017-12-22T04:20:35","guid":{"rendered":"https:\/\/qtvz.com\/?p=111"},"modified":"2017-12-22T10:24:07","modified_gmt":"2017-12-22T04:24:07","slug":"%e8%ae%b0%e5%bd%95%e4%b8%80%e6%ac%a1ora-006002252%e6%95%85%e9%9a%9c%e8%a7%a3%e5%86%b3","status":"publish","type":"post","link":"https:\/\/qtvz.com\/111.html","title":{"rendered":"\u8bb0\u5f55\u4e00\u6b21ORA-00600[2252]\u6545\u969c\u89e3\u51b3"},"content":{"rendered":"

\u6570\u636e\u5e93alert\u65e5\u5fd7\u62a5ORA-00600<\/a>[2252]<\/strong><\/p>\n

Wed Jun 06 08:56:02 2012\r\nThread 1 cannot allocate new log, sequence 552\r\nCheckpoint not complete\r\n  Current log# 1 seq# 551 mem# 0: D:\\ORACLE\\PRODUCT\\10.2.0\\ORADATA\\ORCL\\REDO01.LOG\r\nThread 1 advanced to log sequence 552\r\n  Current log# 2 seq# 552 mem# 0: D:\\ORACLE\\PRODUCT\\10.2.0\\ORADATA\\ORCL\\REDO02.LOG\r\nSun Jun 06 09:39:19 2010\r\nErrors in file d:\\oracle\\product\\10.2.0\\admin\\orcl\\bdump\\orcl_m000_3344.trc:\r\nORA-00600<\/a>: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [2252], [2834], [4076554712], [], [], [], [], []\r\n \r\nErrors in file d:\\oracle\\product\\10.2.0\\admin\\orcl\\bdump\\orcl_m000_3344.trc:\r\nORA-00600<\/a>: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [2252], [2834], [4076554712], [], [], [], [], []\r\n \r\nSun Jun 06 10:19:49 2010\r\nErrors in file d:\\oracle\\product\\10.2.0\\admin\\orcl\\bdump\\orcl_m000_4904.trc:\r\nORA-00600<\/a>: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [2252], [2834], [4076555573], [], [], [], [], []\r\n \r\nSun Jun 06 10:20:49 2010\r\nErrors in file d:\\oracle\\product\\10.2.0\\admin\\orcl\\bdump\\orcl_m000_5984.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [2252], [2834], [4076555594], [], [], [], [], []\r\n \r\nSun Jun 06 10:21:49 2010\r\nErrors in file d:\\oracle\\product\\10.2.0\\admin\\orcl\\bdump\\orcl_m000_4204.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [2252], [2834], [4076555614], [], [], [], [], []\r\n \r\nSun Jun 06 10:22:49 2010\r\nErrors in file d:\\oracle\\product\\10.2.0\\admin\\orcl\\bdump\\orcl_m000_5896.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [2252], [2834], [4076555634], [], [], [], [], []\r\n \r\nSun Jun 06 10:23:49 2010\r\nErrors in file d:\\oracle\\product\\10.2.0\\admin\\orcl\\bdump\\orcl_m000_4612.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [2252], [2834], [4076555654], [], [], [], [], []\r\n \r\nSun Jun 06 10:24:49 2010\r\nErrors in file d:\\oracle\\product\\10.2.0\\admin\\orcl\\bdump\\orcl_m000_4696.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [2252], [2834], [4076555676], [], [], [], [], []\r\n \r\nSun Jun 06 10:25:50 2010\r\nErrors in file d:\\oracle\\product\\10.2.0\\admin\\orcl\\bdump\\orcl_m000_5568.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [2252], [2834], [4076555696], [], [], [], [], []\r\n \r\nSun Jun 06 10:26:50 2010\r\nErrors in file d:\\oracle\\product\\10.2.0\\admin\\orcl\\bdump\\orcl_m000_5776.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [2252], [2834], [4076555716], [], [], [], [], []\r\n \r\n--\u542f\u52a8\u6570\u636e\u5e93\r\nMon Jun 07 09:18:39 2010\r\nStarting ORACLE instance (normal)\r\nLICENSE_MAX_SESSION = 0\r\nLICENSE_SESSIONS_WARNING = 0\r\nMon Jun 07 09:18:49 2010\r\nPicked latch-free SCN scheme 2\r\nUsing LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST\r\nAutotune of undo retention is turned on. \r\nIMODE=BR\r\nILAT =18\r\nLICENSE_MAX_USERS = 0\r\nSYS auditing is disabled\r\nksdpec: called for event 13740 prior to event group initialization\r\nStarting up ORACLE RDBMS Version: 10.2.0.1.0.\r\nSystem parameters with non-default values:\r\n  processes                = 150\r\n  __shared_pool_size       = 100663296\r\n  __large_pool_size        = 12582912\r\n  __java_pool_size         = 4194304\r\n  __streams_pool_size      = 0\r\n  spfile                   = D:\\ORACLE\\PRODUCT\\10.2.0\\DB_1\\DBS\\SPFILEORCL.ORA\r\n  nls_language             = SIMPLIFIED CHINESE\r\n  nls_territory            = CHINA\r\n  sga_target               = 452984832\r\n  control_files            = D:\\ORACLE\\PRODUCT\\10.2.0\\ORADATA\\ORCL\\CONTROL01.CTL\r\n  db_block_size            = 8192\r\n  __db_cache_size          = 327155712\r\n  compatible               = 10.2.0.1.0\r\n  db_file_multiblock_read_count= 16\r\n  db_recovery_file_dest    = D:\\oracle\\product\\10.2.0\/flash_recovery_area\r\n  db_recovery_file_dest_size= 2147483648\r\n  undo_management          = AUTO\r\n  undo_tablespace          = UNDOTBS1\r\n  remote_login_passwordfile= EXCLUSIVE\r\n  db_domain                = \r\n  dispatchers              = (protocol=TCP)\r\n  shared_servers           = 1\r\n  job_queue_processes      = 10\r\n  audit_file_dest          = D:\\ORACLE\\PRODUCT\\10.2.0\\ADMIN\\ORCL\\ADUMP\r\n  background_dump_dest     = D:\\ORACLE\\PRODUCT\\10.2.0\\ADMIN\\ORCL\\BDUMP\r\n  user_dump_dest           = D:\\ORACLE\\PRODUCT\\10.2.0\\ADMIN\\ORCL\\UDUMP\r\n  core_dump_dest           = D:\\ORACLE\\PRODUCT\\10.2.0\\ADMIN\\ORCL\\CDUMP\r\n  db_name                  = orcl\r\n  open_cursors             = 300\r\n  pga_aggregate_target     = 149946368\r\nPSP0 started with pid=3, OS id=3028\r\nMMAN started with pid=4, OS id=3528\r\nPMON started with pid=2, OS id=2772\r\nDBW0 started with pid=5, OS id=816\r\nCKPT started with pid=7, OS id=3372\r\nSMON started with pid=8, OS id=2584\r\nRECO started with pid=9, OS id=3976\r\nCJQ0 started with pid=10, OS id=1912\r\nMMON started with pid=11, OS id=624\r\nMon Jun 07 09:19:00 2010\r\nstarting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...\r\nMMNL started with pid=12, OS id=2696\r\nMon Jun 07 09:19:00 2010\r\nstarting up 1 shared server(s) ...\r\nLGWR started with pid=6, OS id=3128\r\nMon Jun 07 09:19:04 2010\r\nalter database mount exclusive\r\nMon Jun 07 09:19:09 2010\r\nSetting recovery target incarnation to 2\r\nMon Jun 07 09:19:10 2010\r\nSuccessful mount of redo thread 1, with mount id 1248834568\r\nMon Jun 07 09:19:10 2010\r\nDatabase mounted in Exclusive Mode\r\nCompleted: alter database mount exclusive\r\nMon Jun 07 09:19:10 2010\r\nalter database open\r\nMon Jun 07 09:19:15 2010\r\nBeginning crash recovery of 1 threads\r\n parallel recovery started with 2 processes\r\nMon Jun 07 09:19:18 2010\r\nStarted redo scan\r\nMon Jun 07 09:19:19 2010\r\nCompleted redo scan\r\n 13 redo blocks read, 7 data blocks need recovery\r\nMon Jun 07 09:19:20 2010\r\nStarted redo application at\r\n Thread 1: logseq 552, block 28631\r\nMon Jun 07 09:19:20 2010\r\nRecovery of Online Redo Log: Thread 1 Group 2 Seq 552 Reading mem 0\r\n  Mem# 0 errs 0: D:\\ORACLE\\PRODUCT\\10.2.0\\ORADATA\\ORCL\\REDO02.LOG\r\nMon Jun 07 09:19:20 2010\r\nCompleted redo application\r\nMon Jun 07 09:19:20 2010\r\nCompleted crash recovery at\r\n Thread 1: logseq 552, block 28644, scn 12176013920948\r\n 7 data blocks read, 7 data blocks written, 13 redo blocks read\r\nMon Jun 07 09:19:28 2010\r\nErrors in file d:\\oracle\\product\\10.2.0\\admin\\orcl\\udump\\orcl_ora_2688.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [2252], [2834], [4076604085], [], [], [], [], []<\/pre>\n
 <\/p>\n
\u901a\u8fc7\u8fd9\u4e9b\u65e5\u5fd7\u53ef\u4ee5\u770b\u51fa\u6570\u636e\u5e93\u4e00\u76f4\u5728\u62a5ORA-00600[2252],\u5728\u540e\u6765\u56e0\u67d0\u79cd\u539f\u56e0\u6570\u636e\u5e93\u5f02\u5e38\u91cd\u542f\u540e\u542f\u52a8\u4e0d\u4e86.\u4ed4\u7ec6\u89c2\u5bdf\u53ef\u4ee5\u53d1\u73b0\u7cfb\u7edf\u663e\u793a\u7684\u65f6\u95f4\u662f2010\u5e746\u67087\u65e5\u548c\u5f53\u524d\u65f6\u95f4\u76f8\u5dee\u4e86\u6574\u6574\u4e24\u5e74.
\nAt any point in time, the Oracle Database calculates a \u201cnot to exceed\u201d limit for the number of SCNs a database can have used, based on the number of seconds elapsed since 1988, multiplied by 16,384. This is known as the database\u2019s current maximum SCN limit. Doing this ensures that Oracle Databases will ration SCNs over time, allowing over 500 years of data processing for any Oracle Database.<\/p>\n
\u9519\u8bef\u539f\u56e0<\/strong>
\n\u6839\u636e\u9519\u8bef\u63d0\u793a\u8ba1\u7b97scn(2834\u4e3a\u73b0\u5728\u7cfb\u7edf\u7684SCN WRAP\uff0c4076604085\u5c31\u662fBASE)=2834*2^32+4076604085=12176013920949
\n\u6839\u636e\u6570\u636e\u5e93\u65e5\u5fd7\u663e\u793a\u7cfb\u7edf\u65f6\u95f4\u8ba1\u7b97\u6700\u5927scn\u503c:<\/p>\n
\n
\n
SQL>select to_number( ((to_date('20100607 09:19:28','yyyymmdd hh24:mi:ss')-\r\n  2 to_date('19880101','yyyymmdd'))*24*3600*16*1024),'999999999999999999') max_scn from dual;\r\n \r\n   MAX_SCN\r\n--------------\r\n11598377254912<\/pre>\n
 <\/p>\n<\/div>\n<\/div>\n
\u901a\u8fc7\u8fd9\u91cc\u7684\u8ba1\u7b97\u53ef\u4ee5\u77e5\u9053\u6570\u636e\u5e93\u5f53\u524d\u7684SCN\u5927\u4e8e\u7cfb\u7edf\u65f6\u95f4\u70b9\u4e0a\u5141\u8bb8\u7684\u6700\u5927\u65f6\u95f4\u7684SCN,\u4ece\u800c\u51fa\u73b0ORA-00600[2252]\u9519\u8bef.<\/p>\n
\u89e3\u51b3\u65b9\u6cd5<\/strong>
\n\u77e5\u9053\u4e86\u6570\u636e\u5e93\u62a5\u8be5\u9519\u8bef\u7684\u539f\u56e0,\u90a3\u4e48\u89e3\u51b3\u8be5\u95ee\u9898\u5f88\u7b80\u5355,\u4fee\u6539\u7cfb\u7edf\u65f6\u95f4\u5230\u6b63\u786e\u7684\u65f6\u95f4\u70b9\u5373\u53ef<\/p>\n
\n
\n
SQL> select to_number(((sysdate-to_date('19880101','yyyymmdd'))*24*3600*16*1024),\r\n   2 '999999999999999999') max_scn from dual;\r\n \r\n   MAX_SCN\r\n--------------\r\n12634899464192<\/pre>\n
 <\/p>\n<\/div>\n<\/div>\n
\u8be5SCN\u5927\u4e8e\u6570\u636e\u5e93\u5f53\u524dSCN\u6240\u6709\u6570\u636e\u5e93\u4e0d\u4f1a\u62a5ORA-00600[2252]\u9519\u8bef\u53ef\u4ee5\u6b63\u5e38\u542f\u52a8.<\/p>\n
\n