Код:
SQL> select * from v$logfile;
GROUP# STATUS
---------- -------
MEMBER
--------------------------------------------------------------------------------
1
D:\ORACLE\ORADATA\DBVALENT\REDO01.LOG
2
D:\ORACLE\ORADATA\DBVALENT\REDO02.LOG
3
D:\ORACLE\ORADATA\DBVALENT\REDO03.LOG
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 233101 5242880 1 NO INACTIVE
661351075 25-MAR-09
2 1 233102 5242880 1 NO ACTIVE
661354475 25-MAR-09
3 1 233103 5242880 1 NO CURRENT
661360712 25-MAR-09
применял лекарство как написанно в этой теме результат получил аналогичный
Код:
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 661354475 generated at 03/25/2009 11:39:51 needed for thread
1
ORA-00289: suggestion : D:\ORACLE\ORA81\RDBMS\ARC33102.001
ORA-00280: change 661354475 for thread 1 is in sequence #233102
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
'D:\ORACLE\ORADATA\DBVALENT\REDO01.LOG'
ORA-00310: archived log contains sequence 233101; sequence 233102 required
ORA-00334: archived log: 'D:\ORACLE\ORADATA\DBVALENT\REDO01.LOG'
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\DBVALENT\SYSTEM01.DBF'
что скажет общественность ? :(