oracle

ORACLE — запускаем после отключения питания

Это не руководство к действию, пишу для того чтобы не забыть.

Oracle 9i. Выключили питание. Пытаемся запустить. Вылезает ошибка (ругается на REDO.LOG). База в архивлог.

SQL> startup
ORACLE instance started.

Total System Global Area 1012753720 bytes
Fixed Size 455992 bytes
Variable Size 301989888 bytes
Database Buffers 704643072 bytes
Redo Buffers 5664768 bytes
Database mounted.
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: ‘..\REDO02.LOG’

SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: ‘..\REDO02.LOG’

SQL> shutdown abort
ORACLE instance shut down.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 1012753720 bytes
Fixed Size 455992 bytes
Variable Size 301989888 bytes
Database Buffers 704643072 bytes
Redo Buffers 5664768 bytes
SQL> alter database mount;

Database altered.

SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: ‘..\REDO02.LOG’

SQL> recover database until cancel using backup controlfile;
ORA-00279: change 1082125021 generated at 07/13/2019 13:58:16 needed for thread
1
ORA-00289: suggestion : ..\ARCHIVE\ARC00284.001
ORA-00280: change 1082125021 for thread 1 is in sequence #284

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 1082130243 generated at 07/13/2019 14:42:31 needed for thread
1
ORA-00289: suggestion : ..\ARCHIVE\ARC00285.001
ORA-00280: change 1082130243 for thread 1 is in sequence #285
ORA-00278: log file ‘..\ARCHIVE\ARC00284.001’ no longer
needed for this recovery

ORA-00279: change 1082135325 generated at 07/13/2019 15:29:06 needed for thread
1
ORA-00289: suggestion : ..\ARCHIVE\ARC00286.001
ORA-00280: change 1082135325 for thread 1 is in sequence #286
ORA-00278: log file ‘..\ARCHIVE\ARC00285.001’ no longer
needed for this recovery

ORA-00279: change 1082139955 generated at 07/13/2019 16:07:16 needed for thread
1
ORA-00289: suggestion : ..\ARCHIVE\ARC00287.001
ORA-00280: change 1082139955 for thread 1 is in sequence #287
ORA-00278: log file ‘..\ARCHIVE\ARC00286.001’ no longer
needed for this recovery

ORA-00279: change 1082144417 generated at 07/13/2019 16:45:04 needed for thread
1
ORA-00289: suggestion : ..\ARCHIVE\ARC00288.001
ORA-00280: change 1082144417 for thread 1 is in sequence #288
ORA-00278: log file ‘..\ARCHIVE\ARC00287.001’ no longer
needed for this recovery

ORA-00279: change 1082148861 generated at 07/13/2019 17:28:13 needed for thread
1
ORA-00289: suggestion : ..\ARCHIVE\ARC00289.001
ORA-00280: change 1082148861 for thread 1 is in sequence #289
ORA-00278: log file ‘..\ARCHIVE\ARC00288.001’ no longer
needed for this recovery

ORA-00279: change 1082155676 generated at 07/13/2019 18:23:04 needed for thread
1
ORA-00289: suggestion : ..\ARCHIVE\ARC00290.001
ORA-00280: change 1082155676 for thread 1 is in sequence #290
ORA-00278: log file ‘..\ARCHIVE\ARC00289.001’ no longer
needed for this recovery

ORA-00308: cannot open archived log
‘C:\ORACLE\ORADATA\MAGICASH\ARCHIVE\ARC00290.001’
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) ?? ??????? ????? ????????? ????.

SQL> recover database until cancel using backup controlfile;
ORA-00279: change 1082155676 generated at 07/13/2019 18:23:04 needed for thread
1
ORA-00289: suggestion : ..\ARCHIVE\ARC00290.001
ORA-00280: change 1082155676 for thread 1 is in sequence #290

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

Database altered.

SQL>

Пролистать наверх