Database inconsistancy
guyz need your help on this.
SQL> select error, fuzzy, status, checkpoint_change#, to_char(checkpoint_time, 'DD-MON-YYYY HH24:MI:SS') as checkpoint_time,
2 count(*) from v$datafile_header group by error, fuzzy, status, checkpoint_change#, checkpoint_time
3 order by checkpoint_change#, checkpoint_time;
ERROR FUZ STATUS CHECKPOINT_CHANGE# CHECKPOINT_TIME COUNT(*)
----------------------------------------------------------------- --- ---------- ------------------ -------------------- ----------------
YES ONLINE 5989251812515 19-MAR-2012 14:13:32 31
YES ONLINE 5989251839127 19-MAR-2012 14:13:38 20
YES ONLINE 5989251865646 19-MAR-2012 14:13:44 20
YES ONLINE 5989251903603 19-MAR-2012 14:13:51 20
-You can only have one checkpoint for all the files and fuzzy=NO in order to open the database clean or do clean upgrade
-The database require more recovery to put all files in sync and fuzzy=NO
SQL> select error, fuzzy, status, checkpoint_change#, to_char(checkpoint_time, 'DD-MON-YYYY HH24:MI:SS') as checkpoint_time,
2 count(*) from v$datafile_header group by error, fuzzy, status, checkpoint_change#, checkpoint_time
3 order by checkpoint_change#, checkpoint_time;
ERROR FUZ STATUS CHECKPOINT_CHANGE# CHECKPOINT_TIME COUNT(*)
----------------------------------------------------------------- --- ---------- ------------------ -------------------- ----------------
YES ONLINE 5989251812515 19-MAR-2012 14:13:32 31
YES ONLINE 5989251839127 19-MAR-2012 14:13:38 20
YES ONLINE 5989251865646 19-MAR-2012 14:13:44 20
YES ONLINE 5989251903603 19-MAR-2012 14:13:51 20
-You can only have one checkpoint for all the files and fuzzy=NO in order to open the database clean or do clean upgrade
-The database require more recovery to put all files in sync and fuzzy=NO
0