\u5ba2\u6237\u5728\u6253\u5f00FLASHBACK\u7684\u65f6\u5019\u78b0\u5230\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002<\/p>\n
\u8be6\u7ec6\u7684\u9519\u8bef\u5982\u4e0b\uff1a<\/p>\n
Tue Oct 18 10:55:02 2011\r\nALTER DATABASE MOUNT\r\nTue Oct 18 10:55:06 2011\r\nSetting recovery target incarnation to 1\r\nTue Oct 18 10:55:06 2011\r\nSuccessful mount of redo thread 1, with mount id 830459142\r\nTue Oct 18 10:55:06 2011\r\nDatabase mounted in Exclusive Mode\r\nCompleted: ALTER DATABASE MOUNT\r\nTue Oct 18 13:05:08 2011\r\nALTER SYSTEM SET db_recovery_file_dest_size='200G' SCOPE=BOTH;\r\nTue Oct 18 13:05:13 2011\r\nALTER SYSTEM SET db_recovery_file_dest='\/flashback' SCOPE=BOTH;\r\nTue Oct 18 13:05:17 2011\r\nALTER SYSTEM SET db_flashback_retention_target=4320 SCOPE=BOTH;\r\nTue Oct 18 13:06:00 2011\r\nShutting down instance: further logons disabled\r\nTue Oct 18 13:06:00 2011\r\nStopping background process CJQ0\r\nTue Oct 18 13:06:00 2011\r\nStopping background process MMNL\r\nTue Oct 18 13:06:01 2011\r\nStopping background process MMON\r\nTue Oct 18 13:06:02 2011\r\nShutting down instance (immediate)\r\nLicense high water mark = 1\r\nTue Oct 18 13:06:02 2011\r\nStopping Job queue slave processes, flags = 7\r\nTue Oct 18 13:06:02 2011\r\nJob queue slave processes stopped\r\nTue Oct 18 13:06:02 2011\r\nALTER DATABASE CLOSE NORMAL\r\nORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...\r\nTue Oct 18 13:06:02 2011\r\nALTER DATABASE DISMOUNT\r\nCompleted: ALTER DATABASE DISMOUNT\r\nARCH: Archival disabled due to shutdown: 1089\r\nShutting down archive processes\r\nArchiving is disabled\r\nArchive process shutdown avoided: 0 active\r\nARCH: Archival disabled due to shutdown: 1089\r\nShutting down archive processes\r\nArchiving is disabled\r\nArchive process shutdown avoided: 0 active\r\nTue Oct 18 13:07:29 2011\r\nStarting ORACLE instance (normal)\r\nsskgpgetexecname failed to get name\r\nLICENSE_MAX_SESSION = 0\r\nLICENSE_SESSIONS_WARNING = 0\r\nPicked latch-free SCN scheme 3\r\nAutotune of undo retention is turned on. \r\nIMODE=BR\r\nILAT =616\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.4.0.\r\nSystem parameters with non-default values:\r\n_trace_files_public = TRUE\r\nprocesses = 2800\r\nsessions = 5600\r\ntimed_statistics = TRUE\r\n__shared_pool_size = 905969664\r\nshared_pool_size = 838860800\r\n__large_pool_size = 16777216\r\n__java_pool_size = 16777216\r\n__streams_pool_size = 0\r\nshared_pool_reserved_size= 83886080\r\nnls_language = american\r\nnls_territory = america\r\nnls_sort = binary\r\nnls_date_format = DD-MON-RR\r\nnls_numeric_characters = .,\r\nnls_comp = binary\r\nnls_length_semantics = CHAR\r\nsga_target = 8589934592\r\ncontrol_files = \/oradata\/accdb\/cntrl01.dbf, \/oradata\/accdb\/cntrl02.dbf, \/oradata\/accdb\/cntrl03.dbf\r\ndb_block_checksum = TRUE\r\ndb_block_size = 8192\r\n__db_cache_size = 7633633280\r\ncompatible = 10.2.0\r\nlog_archive_config = DG_CONFIG=(ACCDB,ACCPRI)\r\nlog_archive_dest_1 = LOCATION=\/archlog\r\nlog_archive_dest_2 = SERVICE=ACCDB LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ACCDB\r\nlog_archive_dest_state_1 = enable\r\nlog_archive_dest_state_2 = enable\r\nlog_archive_max_processes= 3\r\nfal_client = ACCPRI\r\nfal_server = ACCDB\r\nlog_buffer = 14230528\r\nlog_checkpoint_interval = 100000\r\nlog_checkpoint_timeout = 1200\r\ndb_files = 512\r\ndb_recovery_file_dest = \/flashback\r\ndb_recovery_file_dest_size= 214748364800\r\nstandby_file_management = AUTO\r\nlog_checkpoints_to_alert = FALSE\r\ndb_flashback_retention_target= 4320\r\ndml_locks = 10000\r\nundo_management = AUTO\r\nundo_tablespace = APPS_UNDOTS1\r\ndb_block_checking = FALSE\r\ndb_domain = ccic\r\nglobal_names = TRUE\r\nsession_cached_cursors = 500\r\nutl_file_dir = \/usr\/tmp, \/usr\/tmp, \/oracle\/accdb\/10.2.0\/appsutil\/outbound\/ACCDB_accountdb, \/usr\/tmp\r\nplsql_native_library_dir = \/oracle\/accdb\/10.2.0\/plsql\/nativelib\r\nplsql_native_library_subdir_count= 149\r\nplsql_code_type = INTERPRETED\r\nplsql_optimize_level = 2\r\njob_queue_processes = 2\r\n_system_trig_enabled = TRUE\r\ncursor_sharing = EXACT\r\nparallel_min_servers = 0\r\nparallel_max_servers = 8\r\nbackground_dump_dest = \/oracle\/admin\/ACCDB\/bdump\r\nuser_dump_dest = \/oracle\/admin\/ACCDB\/udump\r\nmax_dump_file_size = 20480\r\ncore_dump_dest = \/oracle\/admin\/ACCDB\/cdump\r\ndb_name = ACCDB\r\ndb_unique_name = ACCPRI\r\nopen_cursors = 1000\r\n_sort_elimination_cost_ratio= 5\r\n_b_tree_bitmap_plans = FALSE\r\n_fast_full_scan_enabled = FALSE\r\n_sqlexec_progression_cost= 2147483647\r\n_like_with_bind_as_equality= TRUE\r\npga_aggregate_target = 4294967296\r\nworkarea_size_policy = AUTO\r\noptimizer_secure_view_merging= FALSE\r\naq_tm_processes = 1\r\nolap_page_pool_size = 41943040\r\nPMON started with pid=2, OS id=3736548\r\nPSP0 started with pid=3, OS id=5767232\r\nMMAN started with pid=4, OS id=2556302\r\nDBW0 started with pid=5, OS id=5112274\r\nDBW1 started with pid=6, OS id=4457358\r\nDBW2 started with pid=7, OS id=3604948\r\nDBW3 started with pid=8, OS id=4915548\r\nLGWR started with pid=9, OS id=3867168\r\nCKPT started with pid=10, OS id=2818092\r\nSMON started with pid=11, OS id=2949892\r\nRECO started with pid=12, OS id=4063580\r\nCJQ0 started with pid=13, OS id=4785010\r\nMMON started with pid=14, OS id=4588312\r\nMMNL started with pid=15, OS id=3015526\r\nTue Oct 18 13:07:31 2011\r\nALTER DATABASE MOUNT\r\nTue Oct 18 13:07:35 2011\r\nSetting recovery target incarnation to 1\r\nTue Oct 18 13:07:35 2011\r\nSuccessful mount of redo thread 1, with mount id 830491155\r\nTue Oct 18 13:07:35 2011\r\nDatabase mounted in Exclusive Mode\r\nCompleted: ALTER DATABASE MOUNT\r\nTue Oct 18 13:07:55 2011\r\nalter database flashback on\r\nTue Oct 18 13:07:55 2011\r\ndb_recovery_file_dest_size of 204800 MB is 0.01% used. This is a\r\nuser-specified limit on the amount of space that will be used by this\r\ndatabase for recovery-related files, and does not reflect the amount of\r\nspace available in the underlying filesystem or ASM diskgroup.\r\nAllocated 15265600 bytes in shared pool for flashback generation buffer\r\nStarting background process RVWR\r\nRVWR started with pid=17, OS id=4260856\r\nTue Oct 18 13:07:55 2011\r\nFlashback Database Enabled \r\nTue Oct 18 13:07:55 2011\r\nErrors in file \/oracle\/admin\/ACCDB\/udump\/accdb_ora_4129208.trc:\r\nORA-00600: internal error code, arguments: [krfg_first_barrier1], [1], [], [], [], [], [], []\r\nORA-600 signalled during: alter database flashback on...<\/pre>\n\u4e4b\u6240\u4ee5\u8981\u5217\u51fa\u8fd9\u4e48\u591a\u7684\u8bb0\u5f55\u662f\u6709\u610f\u4e49\u7684\uff0c\u5bf9\u4e8e\u4e00\u822c\u7684ORA-600\u800c\u8a00\uff0c\u53ea\u9700\u8981\u540e\u97624\u884c\u800c\u5df2\uff0c\u4f46\u662f\u5bf9\u4e8e\u5f53\u524d\u7684\u95ee\u9898\u662f\u4e0d\u591f\u7684\uff0c\u4e8b\u5b9e\u4e0a\u5982\u679c\u4e0d\u662f\u7bc7\u5e45\uff0c\u6211\u6253\u7b97\u628a\u6574\u4e2aalert\u6587\u4ef6\u4e2d\u7684\u5185\u5bb9\u90fd\u8d34\u4e0a\u3002
\n\u7b80\u5355\u4ecb\u7ecd\u4e00\u4e0b\u60c5\u51b5\uff0c\u5ba2\u6237\u6253\u7b97\u5728STANDBY\u6570\u636e\u5e93\u4e0a\u6253\u5f00FLASHBACK\uff0c\u8fd9\u6837\u5907\u5e93\u53ef\u4ee5\u6253\u5f00\u8fdb\u884c\u8bfb\u5199\u4fee\u6539\uff0c\u5728\u4fee\u6539\u5b8c\u6bd5\u540e\uff0c\u53ef\u4ee5\u6062\u590d\u5230\u6253\u5f00\u4e4b\u524d\u7684\u72b6\u6001\uff0c\u518d\u6b21\u8f6c\u6362\u6210STANDBY\u6570\u636e\u5e93\u7684\u89d2\u8272\uff0c\u800c\u4e0d\u9700\u8981\u7531\u4e8e\u5907\u5e93\u7684\u6253\u5f00\uff0c\u91cd\u5efa\u6574\u4e2aSTANDBY\u6570\u636e\u5e93\u3002
\n\u672c\u6765\u8fd9\u4e2a\u64cd\u4f5c\u5728\u5ba2\u6237\u8fd9\u8fb9\u5df2\u7ecf\u8fdb\u884c\u8fc7\u51e0\u6b21\uff0c\u4ece\u6765\u6ca1\u6709\u78b0\u5230\u8fc7\u4ec0\u4e48\u95ee\u9898\uff0c\u4e0d\u8fc7\u8fd9\u6b21\u8fd9\u4e2a\u6570\u636e\u5e93\u7684STANDBY\u73af\u5883\u662f\u65b0\u5efa\u7acb\u7684\uff0c\u800cFLASHBACK\u8fd9\u79cd\u65b0\u6280\u672f\uff0c\u78b0\u5230\u4ec0\u4e48bug\u4e5f\u4e0d\u5947\u602a\u3002
\n\u53d1\u73b0\u8fd9\u4e2a\u9519\u8bef\u540e\uff0c\u9996\u5148\u53bbmetalink\u4e0a\u67e5\u8be2\uff0c\u7ed3\u679c\u53d1\u73b0\u8fd9\u4e2a\u9519\u8bef\u5728metalink\u4e0a\u6839\u672c\u6ca1\u6709\u8bb0\u5f55\uff0c\u770b\u6765\u8fd9\u65f6\u4e00\u4e2a\u51fa\u73b0\u51e0\u7387\u5f88\u4f4e\u7684\u95ee\u9898\u3002\u867d\u7136FLASHBACK\u7528\u7684\u4eba\u6bd4\u8f83\u5c11\uff0c\u4f46\u662f\u4ece10g\u51fa\u73b0\uff0c\u523011.2\uff0c\u8fd8\u662f\u7ecf\u5386\u4e86\u4e00\u6bb5\u65f6\u95f4\u4e86\uff0c\u5982\u679c\u662f\u5e38\u89c4\u7684\u95ee\u9898\uff0c\u4e0d\u592a\u53ef\u80fd\u6ca1\u6709\u4efb\u4f55\u8bb0\u5f55\u3002
\n\u8be6\u7ec6\u7684\u9519\u8bef\u65e5\u5fd7\u6587\u4ef6\uff1a
\nDump file \/oracle\/admin\/ACCDB\/udump\/accdb_ora_4129208.trc
\nOracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options
\nORACLE_HOME = \/oracle\/product\/db10gr2
\nSystem name: AIX
\nNode name: Paccdb2
\nRelease: 1
\nVersion: 6
\nMachine: 00F67AD94C00
\nInstance name: ACCDB
\nRedo thread mounted by this instance: 1
\nOracle process number: 16
\nUnix process pid: 4129208, image: oracle@Paccdb2 (TNS V1-V3)
\n*** ACTION NAME:() 2011-10-18 13:07:55.437
\n*** MODULE NAME:(sqlplus@Paccdb2 (TNS V1-V3)) 2011-10-18 13:07:55.437
\n*** SERVICE NAME:() 2011-10-18 13:07:55.437
\n*** SESSION ID:(5586.3) 2011-10-18 13:07:55.437
\n*** 2011-10-18 13:07:55.437
\nksedmp: internal or fatal error
\nORA-00600: internal error code, arguments: [krfg_first_barrier1], [1], [], [], [], [], [], []
\nCurrent SQL statement for this session:
\nalter database flashback on
\n—– Call Stack Trace —–
\ncalling call entry argument values in hex
\nlocation type point (? means dubious value)
\n——————– ——– ——————– —————————-
\nksedst+001c bl ksedst1 000000000 ? 000000000 ?
\nksedmp+0290 bl ksedst 104A52AA8 ?
\nksfdmp+0018 bl 03F4E238
\nkgerinv+00dc bl _ptrgl
\nkgeasnmierr+004c bl kgerinv 000000000 ? 000000000 ?
\n 000009732 ? 00147AE14 ?
\n 700000010018078 ?
\nkrfg_first_barrier_ bl kgeasnmierr 110196398 ? 110490040 ?
\nw_fba+00e8 104C03194 ? 100000001 ?
\n 000000000 ? 000000001 ?
\n 104C03D84 ? 1056A1010 ?
\nkrfg_first_barrier+ bl krfg_first_barrier_ 000000000 ? 000000000 ?
\n001c w_fba 000000000 ? 004D25FF8 ?
\nkrf_enable_flashbac bl krfg_first_barrier
\nk_db+0098
\nadbdrv+d9b0 bl krf_enable_flashbac 000000000 ?
\n k_db
\nopiexe+2c18 bl adbdrv
\nopiosq0+19f0 bl opiexe 000000000 ? 000000000 ?
\n FFFFFFFFFFF8EB0 ?
\nkpooprx+0168 bl opiosq0 3EC779438 ? 700000010003520 ?
\n 7000001EC7793B8 ?
\n A4000110196398 ?
\nkpoal8+0400 bl kpooprx FFFFFFFFFFFB704 ?
\n FFFFFFFFFFFB470 ?
\n 1B0000001B ? 100000001 ?
\n 000000000 ? A40000000000A4 ?
\n 000000000 ? 1103A80D8 ?
\nopiodr+0ae0 bl _ptrgl
\nttcpip+1020 bl _ptrgl
\nopitsk+1124 bl ttcpip 1100CB7A0 ? FFFFFFFFFFFBA00 ?
\n 000000000 ? 11044F7B0 ?
\n FFFFFFFFFFFB970 ?
\n 442442226B736800 ?
\n 9000000000D9B74 ? 110451E00 ?
\nopiino+0990 bl opitsk 1E00000000 ? 000000000 ?
\nopiodr+0ae0 bl _ptrgl
\nopidrv+0484 bl 01FBA1C8
\nsou2o+0090 bl opidrv 3C02ABB45C ? 4A0071EB0 ?
\n FFFFFFFFFFFF640 ?
\nopimai_real+01bc bl 01FB7F8C
\nmain+0098 bl opimai_real 000000000 ? 000000000 ?
\n__start+0070 bl main 000000000 ? 000000000 ?
\n——————— Binary Stack Dump ———————
\n\u7b80\u7565\u7684\u770b\u4e86\u4e00\u4e0bTRACE\u6587\u4ef6\uff0c\u5e76\u6ca1\u6709\u53d1\u73b0\u53ef\u7591\u7684\u5730\u65b9\uff0c\u67e5\u8be2\u4e86\u4e00\u4e0b\u6570\u636e\u5e93\u7684\u72b6\u6001\uff1a<\/p>\n
SQL> select name, log_mode, controlfile_type, open_mode, database_role, flashback_on from v$database;\r\nNAME LOG_MODE CONTROLFILE_TY OPEN_MODE DATABASE_ROLE FLASHBACK_ON\r\n---------- --------------- -------------- ---------- --------------- ---------------\r\nACCDB ARCHIVELOG BACKUP MOUNTED PRIMARY YES<\/pre>\n\u867d\u7136\u62a5\u4e86ORA-600\u9519\u8bef\uff0c\u4f46\u662fFLASHBACK\u5df2\u7ecf\u6253\u5f00\u4e86\uff0c\u800c\u4e14\u5728\u5bf9\u5e94\u7684\u672a\u77e5\u4e5f\u53d1\u73b0FLASHBACK\u65e5\u5fd7\u6587\u4ef6\u6210\u529f\u521b\u5efa\u3002\u6b64\u5916\u8fd8\u6709\u4e00\u4e2a\u7591\u70b9\uff0c\u5c31\u662f\u63a7\u5236\u6587\u4ef6\u548c\u6570\u636e\u5e93\u7684\u89d2\u8272\u4e0d\u6b63\u786e\uff0c\u6309\u9053\u7406\u6765\u8bf4\uff0c\u63a7\u5236\u6587\u4ef6\u7684\u72b6\u6001\u5e94\u8be5\u662fSTANDBY\uff0c\u800c\u6570\u636e\u5e93\u7684\u89d2\u8272\u4e5f\u5e94\u8be5\u662fSTANDBY\u3002\u4e8e\u662f\u548c\u5177\u4f53\u64cd\u4f5c\u7684DBA\u6c9f\u901a\u4e86\u4e00\u4e0b\uff0c\u53d1\u73b0\u4e86\u95ee\u9898\u7684\u6240\u5728\u3002
\n\u539f\u6765\u8fd9\u4e2aSTANDBY\u73af\u5883\u8fd8\u6839\u672c\u6ca1\u6709\u5efa\u7acb\u8d77\u6765\uff0c\u73b0\u5728\u6570\u636e\u5e93\u53ea\u662f\u5229\u7528BACKUP\u7684\u63a7\u5236\u6587\u4ef6\u6062\u590d\u4e86\u63a7\u5236\u6587\u4ef6\u800c\u5df2\uff0c\u6570\u636e\u5e93\u7684\u6570\u636e\u6587\u4ef6\u8fd8\u6839\u672c\u5c31\u6ca1\u6709\u6062\u590d\uff0c\u4e5f\u5c31\u662f\u8bf4\u4e0d\u4f46\u6ca1\u6709\u5efa\u7acb\u6210STANDBY\u73af\u5883\uff0c\u6570\u636e\u5e93\u672c\u8eab\u8fd8\u4e0d\u5b58\u5728\uff0c\u8fd9\u65f6\u5019\u5f00\u542fFLASHBACK\u5f53\u7136\u4f1a\u6709\u95ee\u9898\u3002
\n\u6b63\u5e38\u5e94\u8be5\u5148\u521b\u5efaSTANDBY\u73af\u5883\uff0c\u786e\u8ba4\u4e3b\u5e93\u548c\u5907\u5e93\u4e4b\u95f4\u5173\u7cfb\u5efa\u7acb\u4e14\u65e5\u5fd7\u5e94\u7528\u6b63\u5e38\uff0c\u7136\u540e\u5728\u5907\u5e93\u4e0a\u5f00\u542fFLASHBACK\u3002\u8fd9\u6837\u770b\u6765\uff0c\u8fd9\u4e2aORA-600\u9519\u8bef\u5728metalink\u4e0a\u627e\u4e0d\u5230\u4e5f\u662f\u6b63\u5e38\u7684\uff0c\u6bd5\u7adf\u8fd9\u4e2a\u9519\u8bef\u592a\u4f4e\u7ea7\u4e86\u3002
\n\u4e0d\u8fc7Oracle\u5e94\u8be5\u5c06\u9519\u8bef\u4fe1\u606f\u66f4\u660e\u786e\u4e00\u4e9b\uff0c\u800c\u4e0d\u662f\u62a5\u4e00\u4e2a\u4e00\u822c\u4eba\u90fd\u770b\u4e0d\u61c2\u7684ORA-600\u9519\u8bef\u5c31\u5b8c\u4e8b\u4e86\uff0c\u4ece\u8fd9\u4e2a\u89d2\u5ea6\u8bb2\uff0c\u8fd9\u4e2a\u95ee\u9898\u4e5f\u7b97\u662f\u4e00\u4e2a\u5c0fbug\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5ba2\u6237\u5728\u6253\u5f00FLASHBACK\u7684\u65f6\u5019\u78b0\u5230\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002 \u8be6\u7ec6\u7684\u9519\u8bef\u5982\u4e0b\uff1a Tue Oct 18 10:55:02 2011 ALTER DATABASE MOUNT Tue Oct 18 10:55:06 2011 Setting recovery target incarnation to 1 Tue Oct 18 10:55:06 2011 Successful mount of redo thread 1, with mount id 830459142 Tue Oct 18 10:55:06 … Continue reading