This was encountered at the point of opening the database after a successful restore of data files and necessary archive logs.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00392: log 1 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 1 thread 1: '+DATA'
Solution:
Check the redo log create destination.
SQL> show parameter create
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
create_bitmap_area_size integer 8388608
create_stored_outlines string
db_create_file_dest string +DATA
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
Set the parameters to reflect the filesystem based format to ensure redo logs are created in the appropriate destination.
SQL> alter system set db_create_file_dest='/filesystem_location/oradata';
System altered.
SQL> alter system set db_create_online_log_dest_1='/filesystem_location/onlinelog';
System altered.
SQL> alter system set db_create_online_log_dest_2='/filesystem_location/onlinelog';
System altered.
Check status of the affected redo group #1.
SQL> select status from v$log where GROUP#=1; STATUS ---------------- CLEARING_CURRENT
SQL> alter database clear unarchived logfile group 1; Database altered.
SQL> select group#, status from v$log where GROUP#=1; GROUP# STATUS ---------- ---------------- 1 CURRENT
Open the database
SQL> alter database open resetlogs; Database altered. SQL> select open_mode from v$database; OPEN_MODE -------------------- READ WRITE
No comments:
Post a Comment