InterviewSolution
| 1. |
What Is The Benefit Of Making Automatic Control File Backup To On? |
|
Answer» Remember that CONTROL file is absolutely necessary during a RECOVERY. Below command can be used to have automatic control file backup to be TAKEN. This is highly recommended. RMAN> configure controlfile autobackup on Now at the end of every RMAN backup command, RMAN automatically backs up the control file. EVEN when you make some changes via SQL*Plus( say creating a new tablespace or adding or renaming a datafile or an online redo log member), the control file is automatically backed up. Also, you can restore RMAN’s backup and recovery information (called RMAN’s repository), when you lose all your control files and aren’t using the optional recovery catalog. Remember that control file is absolutely necessary during a recovery. Below command can be used to have automatic control file backup to be taken. This is highly recommended. RMAN> configure controlfile autobackup on Now at the end of every RMAN backup command, RMAN automatically backs up the control file. Even when you make some changes via SQL*Plus( say creating a new tablespace or adding or renaming a datafile or an online redo log member), the control file is automatically backed up. Also, you can restore RMAN’s backup and recovery information (called RMAN’s repository), when you lose all your control files and aren’t using the optional recovery catalog. |
|