|
Category :
Database
Resources -> Backup and Recovery
DB Version
:
Oracle 9i
OS Details :
Sun Solaris9
Following
are the steps that need to be done to recover from the loss or
corruption of online redo log group that's currently not active. The database needs to be in archivelog
mode for these steps to work and also the following conditions should
be met:
- The lost or corrupted redo is
not the current redo log being written to by the LGWR.
- The lost redo log file has
already been archived.
- There are more than two online
redo log groups within the database.
Step 0:
Startup and mount the database
but do not open it.
SQL> startup mount
Step 1:
Create a temporary online redo
log group with a member redo log file in it.
SQL> alter database add
logfile group 4 '/oradata/oralogs/redotemp01.dbf' size 20M;
Step 2:
Drop the online log group with
the missing / corrupted log files.
SQL> alter database drop
logfile group 2;
Step 3:
Recreate the group dropped in
step2 above
SQL> alter database add
logfile group 2 '/oradata/oralogs/redo02.dbf' size 20M;
Step 4:
Drop the temporary redo log
group created in step 1 and remove the associated redo log files.
Step 5:
Open the database and make it
available to the users.
SQL> alter database open; |
