Dělal jsem obnovu databáze (RAC do non-RAC) na jiný server, ale z důvodu nedostaku místa nedoběhla a když jsem chtěl pokračovat, měl jsem problém s otevřením databáze.
Problém
SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00392: log 18 of thread 2 is being cleared, operation not allowed ORA-00312: online log 18 thread 2: 'E:\ORACLE\FAST_RECOVERY_AREA\ORCL\ONLINELOG\O1_MF_18_%U_.LOG'
Řešení
SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC ---------- ---------- ---------- ---------- ---------- ---------- --- STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME ---------------- ------------- --------- ------------ --------- 11 1 0 157286400 512 1 NO CURRENT 3323115302 02-JUN-16 2.8147E+14 12 1 0 157286400 512 1 YES UNUSED 3322899496 02-JUN-16 3322999840 02-JUN-16 13 1 0 157286400 512 1 YES UNUSED 3322999840 02-JUN-16 3323108028 02-JUN-16 GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC ---------- ---------- ---------- ---------- ---------- ---------- --- STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME ---------------- ------------- --------- ------------ --------- 14 1 0 157286400 512 1 YES UNUSED 3323108028 02-JUN-16 3323115302 02-JUN-16 15 2 0 157286400 512 1 YES CLEARING 3322388870 02-JUN-16 3322655036 02-JUN-16 16 2 0 157286400 512 1 YES CLEARING 3322655036 02-JUN-16 3322899630 02-JUN-16 GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC ---------- ---------- ---------- ---------- ---------- ---------- --- STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME ---------------- ------------- --------- ------------ --------- 17 2 0 157286400 512 1 YES CLEARING 3322899630 02-JUN-16 3323115311 02-JUN-16 18 2 0 157286400 512 1 NO CLEARING_CURRENT 3323115311 02-JUN-16 2.8147E+14 8 rows selected. alter database clear logfile group 16; SQL> alter database clear logfile group 18; Database altered. SQL> alter database clear logfile group 17; Database altered. SQL> alter database clear logfile group 16; Database altered. SQL> alter database clear logfile group 15; Database altered. SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC ---------- ---------- ---------- ---------- ---------- ---------- --- STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME ---------------- ------------- --------- ------------ --------- 11 1 0 157286400 512 1 NO CURRENT 3323115302 02-JUN-16 2.8147E+14 12 1 0 157286400 512 1 YES UNUSED 3322899496 02-JUN-16 3322999840 02-JUN-16 13 1 0 157286400 512 1 YES UNUSED 3322999840 02-JUN-16 3323108028 02-JUN-16 GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC ---------- ---------- ---------- ---------- ---------- ---------- --- STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME ---------------- ------------- --------- ------------ --------- 14 1 0 157286400 512 1 YES UNUSED 3323108028 02-JUN-16 3323115302 02-JUN-16 15 2 0 157286400 512 1 YES UNUSED 3322388870 02-JUN-16 3322655036 02-JUN-16 16 2 0 157286400 512 1 YES UNUSED 3322655036 02-JUN-16 3322899630 02-JUN-16 GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC ---------- ---------- ---------- ---------- ---------- ---------- --- STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME ---------------- ------------- --------- ------------ --------- 17 2 0 157286400 512 1 YES UNUSED 3322899630 02-JUN-16 3323115311 02-JUN-16 18 2 0 157286400 512 1 NO CURRENT 3323115311 02-JUN-16 2.8147E+14 8 rows selected. SQL> alter database open resetlogs upgrade; Database altered.