Re: Redo logs backup??
From: Charles Jardine <cj10_at_cam.ac.uk>
Date: 1996/06/06
Message-ID: <31B6C43A.4659_at_cam.ac.uk>#1/1
Date: 1996/06/06
Message-ID: <31B6C43A.4659_at_cam.ac.uk>#1/1
- Online backups are useless unless the database is running in ARCHIVELOG mode.
- In order to recover a database from an online backup you will need the archive copies of all the redo logs which were written while any tablespace was in BACKUP mode. This includes the redo log which was current at the moment of the final ALTER TABLSPACE ... END BACKUP. It is necessary to do an ALTER SYSTEM ARCHIVE LOG CURRENT after the last END BACKUP an then to write the relevant archive logs onto the backup tape. If you have the correct archive logs you won't need any of the actual redo log files.
- You will need a control file. Write the output of ALTER DATABASE BACKUP CONTROLFILE TO 'file' onto the tape.