First page Back Continue Last page Graphics
…NOCATALOG Mode
Protect control file!
- Contains history of backups and archive logs
- Needed to RESTORE and RECOVER
- Duplex with control_files parameter
- Backup frequently
- Use 9i AUTOBACKUP feature
Notes:
In the event of a RESTORE/RECOVERY operation, RMAN relies on the control file for a record of backups taken when a recovery catalog is not used. What happens if you lose the control file in this mode? That depends on a few things:
Oracle9i and AUTOBACKUP ON – Easy to RESTORE CONTROLFILE. Oracle9i and AUTOBACKUP OFF – Difficult, possibly impossible, to recover.
Note this warning about loss of control files is included in the Oracle8i Backup and Recovery manual:
“WARNING: It is difficult to restore and recover if you lose your control files and do not use a recovery catalog. The only way to restore and recover when you have lost all control files and need to restore and recover datafiles is to call OracleWorldWide Support (WWS). WWS will need to know:
The current schema of the database.
Which files were backed up.
When the files were backed up.
The names of the backup pieces containing the files.”
Overcome this problem by using the Oracle9i control file AUTOBACKUP feature. See Lesson 5: Backup with RMAN for details on using AUTOBACKUP.