1: a power outage occurs on the weekend. The newly configured Intranet Test Database activedataguard is automatically disabled. After the master database is started this morning, the following error is reported: [oracle @ db1 ~] $ SqlplusnologSQL * Plus: Release11.2.0.1.0Pro
1: a power outage occurs on the weekend. The newly configured Intranet Test Database activedataguard is automatically disabled. After the master database is started this morning, the following error is reported: [oracle @ db1 ~] $ Sqlplus/nologSQL * Plus: Release11.2.0.1.0Pro
1: a power outage occurred on the weekend. The newly configured Intranet Test Database active replicuard environment is automatically disabled. The following error is reported after the master database is started in Hong Kong.
[Oracle @ db1 ~] $ Sqlplus/nologSQL * Plus: Release 11.2.0.1.0 Production on Mon Jun 17 17:00:57 2013 Copyright (c) 1982,200 9, Oracle. all rights reserved. SQL> conn/as sysdbaConnected to an idle instance. SQL> startupORACLE instance started. total System Global Area 1.3362E + 10 bytesFixed Size2217952 bytesVariable Size6777997344 bytesDatabase Buffers6576668672 bytesRedo Buffers4960256 bytesDatabase mounted. ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [6], [301353], [301354], [], [], [], [], [], [], [], [], []
2: first, recover the database and then try to pull the database. The problem persists.
SQL> recover database; Media recovery complete. SQL> alter database open; alter database open * ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [6], [301353], [301354], [], [], [], [], [], [], []
3: view the alert Log and related trace files to determine whether problems may occur in the control file.
[Oracle @ db1 ~] $ Tail-f alert_db.logErrors in file/u01/app/oracle/diag/rdbms/db1/db/trace/db_ora_32462.trc: ORA-00600: internal error code, arguments: [warn], [1], [6], [301353], [301354], [], [], [], [], [], [], [] Errors in file/u01/app/oracle/diag/rdbms/db1/db/trace/db_ora_32462.trc: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1] [6], [301353], [301354], [], [], [], [], [], [], [] ORA-600 signalled: alter database open... trace dumping is refreshing Ming id = [cdmp_20130617170117] Mon Jun 17 17:02:13 2013 Sweep [inc] [24153]: completedSweep [inc2] [24153]: completedMon Jun 17 17:02:38 2013 alter database recover databaseMedia Recovery Start started logmerger processParallel Media Recovery started with 4 slavesMon Jun 17 17:02:38 2013 Recovery of Online Redo Log: thread 1 Group 3 Seq 6 Reading mem 0 Mem #0:/u01/app/oracle/oradata/DB/onlinelog/o1_mf_3_8vpmjgoq _. log Mem #1:/u01/app/oracle/flash_recovery_area/DB/onlinelog/o1_mf_3_8vpmkm9x _. logMedia Recovery Complete (db) Completed: alter database recover databaseMon Jun 17 17:02:54 2013 alter database openBeginning crash recovery of 1 threads parallel recovery started with 3 processesStarted redo scanCompleted redo scan read 152 KB redo, 0 data blocks need recoveryErrors in file/u01/app/oracle/diag/rdbms/db1/db/trace/db_ora_32462.trc (incident = 24154): ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [6], [301353], [301354], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/db1/db/incident/incdir_24154/db_ora_32462_i24154.trcMon Jun 17 17:02:55 2013 Trace dumping is achieved Ming id = [cdmp_20130617170255] Aborting crash recovery due to error 600 errors in file/u01/app/oracle/diag/rdbms/db1/db/trace/db_ora_32462.trc: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [6], [301353], [301354], [], [], [], [], [], [], [], [], [] Errors in file/u01/app/oracle/diag/rdbms/db1/db/trace/db_ora_32462.trc: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [6], [301353], [301354], [], [], [], [], [], [], [] ORA-600 signalled during: alter database open... mon Jun 17 17:03:13 2013 Sweep [inc] [24154]: completedSweep [inc2] [24154]: completed
4: The trace control script is generated to restore the control file.
SQL> select open_mode from v $ database; OPEN_MODE--------------------MOUNTEDSQL> alter database backup controlfile to trace as '/tmp/1. ctl'; Database altered. [oracle @ db1 ~] $ Cat/tmp/1. ctlCREATE controlfile reuse database "DB" noresetlogs force logging limit 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 logfile group 1 ('/u01/app/oracle/oradata/DB/onlinelog/login _. log', '/u01/app/oracle/flash_recovery_area/DB/onlinelog/o1_mf_1_8vpmdryt _. log ') SIZE 512 m blocksize 512, GROUP 2 ('/u01/app/oracle/oradata/DB/onlinelog/o1_mf_2_8vpmfqmw _. log', '/u01/app/oracle/flash_recovery_area/DB/onlinelog/o1_mf_2_8vpmhk2z _. log ') SIZE 512 m blocksize 512, GROUP 3 ('/u01/app/oracle/oradata/DB/onlinelog/o1_mf_3_8vpmjgoq _. log', '/u01/app/oracle/flash_recovery_area/DB/onlinelog/o1_mf_3_8vpmkm9x _. log ') SIZE 512 m blocksize 512---standby logfile -- GROUP 4 (--'/u01/app/oracle/oradata/DB1/onlinelog/o1_mf_4_8vpq6nvy _. log', -- '/u01/app/oracle/flash_recovery_area/DB1/onlinelog/o1_mf_4_8vpq7wk8 _. log' --) SIZE 512 m blocksize 512, -- GROUP 5 (-- '/u01/app/oracle/oradata/DB1/onlinelog/o1_mf_5_8vpqbh6s _. log', -- '/u01/app/oracle/flash_recovery_area/DB1/onlinelog/o1_mf_5_8vpqcmbj _. log' --) SIZE 512 m blocksize 512, -- GROUP 6 (-- '/u01/app/oracle/oradata/DB1/onlinelog/o1_mf_6_8vp1_3rz _. log', -- '/u01/app/oracle/flash_recovery_area/DB1/onlinelog/ow.mf_6_8vp1_v5w _. log' --) SIZE 512 m blocksize 512, -- GROUP 7 (-- '/u01/app/oracle/oradata/DB1/onlinelog/o1_mf_7_8vpqgw0j _. log', -- '/u01/app/oracle/flash_recovery_area/DB1/onlinelog/o1_mf_7_8vpqhcql _. log' --) SIZE 512 m blocksize 512 DATAFILE '/u01/app/oracle/oradata/DB/datafile/o1_mf_system_8vpm8hf3 _. dbf', '/u01/app/oracle/oradata/DB/datafile/o1_mf_sysaux_8vpm8hjq _. dbf', '/u01/app/oracle/oradata/DB/datafile/o1_mf_undotbs1_8vpm8hl4 _. dbf', '/u01/app/oracle/oradata/DB/datafile/o1_mf_users_8vpm8hn1 _. dbf 'character SET ZHS16GBK; SQL> shutdown immediateORA-01109: database not openDatabase dismounted. ORACLE instance shut down. SQL> startup nomountORACLE instance started. total System Global Area 1.3362E + 10 bytesFixed Size2217952 bytesVariable bytes bytesDatabase Buffers6576668672 bytesRedo Buffers4960256 bytesSQL >@/ tmp/1.ctl; Control file created.
