Sunday, August 29, 2010

ORA-16014: log 4 sequence# 20 not archived, no available destinations

RAC environment with ASM.

While try to open the database, got the following error:

SQL> alter database open;alter database open*ERROR at line 1:ORA-16014: log 4 sequence# 20 not archived, no available destinationsORA-00312: online log 4 thread 2:'+PASS_DATA/upstrprd_prime/onlinelog/group_4.266.720285169'ORA-00312: online log 4 thread 2:'+PASS_FLASH/upstrprd_prime/onlinelog/group_4.260.720285169'

Looks like some online log files are corrupted.

The solution:

SQL> alter database clear unarchived logfile group 4;
Database altered.
SQL> alter database open;alter database open*ERROR at line 1:ORA-16014: log 3 sequence# 21 not archived, no available destinationsORA-00312: online log 3 thread 2:'+PASS_DATA/upstrprd_prime/onlinelog/group_3.265.720285169'ORA-00312: online log 3 thread 2:'+PASS_FLASH/upstrprd_prime/onlinelog/group_3.259.720285169'
SQL> alter database clear unarchived logfile group 3;
Database altered.
SQL> alter database open;
Database altered.
SQL>

Perform a backup after open the database.

No comments: