In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
Which two events would cause the control file to be backed up automatically? (Choose two)
A.
A tablespace is taken offline.
B.
The database instance is restarted.
C.
A new data file is added to an existing tablespace.
D.
A successful backup is recorded in the RMAN repository.
E.
The RMAN connection is disconnected from the target database.
Explanation:
If CONFIGURE CONTROLFILE AUTOBACKUP is ON, then RMAN automatically backs up the control file and the current server parameter file (if used to start up the database) in one of two circumstances: when a successful backup must be recorded in the RMAN repository, and when a structural change to the database affects the contents of the control file which therefore must be backed up.
Ref.:
Backup and Recovery Advanced User�s Guide 10g Release 2 (10.2). Page: 2-29.
I Want to discuss why the answer “A” is not marked as a valid answer.
According with Oracle Documentation the change of the status of tablespace will generate a Control File Autobackup. In this case put the tablespace offline cause a change of the status of tablespace.
I do son test on a 10.2.0.4.0 Oracle Database Standart Edition and the operation to put offline a tablespace automatically backed up the control file.
What do you think?
Oracle® Database Backup and Recovery Advanced User’s Guide
10g Release 2 (10.2)
Part Number B14191-03
”
2 RMAN Backups Concepts
When RMAN Performs Control File AutobackupsControl File Autobackups After Database Structural Changes
The control file is also automatically backed up after database structural changes such as adding a new tablespace, altering the state of a tablespace or datafile (for example, bringing it online), adding a new online redo log, renaming a file, adding a new redo thread, and so on. Losing this information would compromise your ability to recover the database.
“
At the beginning I mark A as correct thinking on your explanation but perhaps bringing offlina a tblespace doesnt compromise the ability to recover and bringing it online yes?? I dunno but I’ll remember what the exam wants to be answered 😉