ORA-600 -3005和ORA-600-2662/2663

oracle metalink  给出ORA-600   3005解决方案：

 

Solution

 

1.  Check the current state ofdatafiles and online redo logs

 

a.  Compare SCN(checkpoint_change#) from datafile headers:

 

selectstatus,checkpoint_change#,checkpoint_time, resetlogs_change#, resetlogs_time,count(*), fuzzy from v$datafile_header

group bystatus,checkpoint_change#,checkpoint_time, resetlogs_change#, resetlogs_time,fuzzy;

 

b. with the online log files (first_change#):

 

col member form a60

select v1.thread#, v1.group#, member,sequence#, first_change#, archived, v1.status from v$log v1, v$logfile v2 wherev1.group#=v2.group#;

 

NOTE: in most cases, the online redo logfile will be the one with v1.status = CURRENT

 

2.  Run instance recoverymanually

 

a.  Issue the command:

 

recover database using backup controlfileuntil cancel;

 

b.  when prompted, give it thefull online redo log file name associated with the THREAD#suggested. 

 

c.  Oracle should return:

 

Log applied.

Media recovery complete.

 

3.  Open the database withresetlogs:

alter database open resetlogs;

 

实际操作步骤：

SQL> selectstatus,checkpoint_change#,checkpoint_time, resetlogs_change#, resetlogs_time,count(*), fuzzy from v$datafile_header

  2 group by status,checkpoint_change#,checkpoint_time, resetlogs_change#,resetlogs_time, fuzzy;

 

STATUS  CHECKPOINT_CHANGE# CHECKPOINRESETLOGS_CHANGE# RESETLOGS   COUNT(*)FUZ

------------------------- --------- ----------------- --------- ---------- ---

ONLINE