To recover from loss of an active online redo log group in NOARCHIVELOG mode:
If the media failure is temporary, then correct the problem so that Oracle can reuse the group when required.
Restore the database from a consistent, whole database backup (datafiles and control files) as described in "Restoring Datafiles". For example, enter:
% cp /disk2/backup/*.f /disk1/oracle/dbs
Mount the database:
STARTUP MOUNT
Because online redo logs are not backed up, you cannot restore them with the datafiles and control files. In order to allow Oracle to reset the online redo logs, you must first mimic incomplete recovery:
RECOVER DATABASE UNTIL CANCEL
CANCEL
Open the database using the RESETLOGS option:
ALTER DATABASE OPEN RESETLOGS;
Shut down the database consistently. For example, enter:
SHUTDOWN IMMEDIATE
Make a whole database backup as described in "Making User-Managed Backups of the Whole Database". For example, enter:
% cp /disk1/oracle/dbs/*.f /disk2/backup
Partager