Analysis of OCP questions 053-17 configure controlfile autobackup on, ocpcontrolfile

Analysis of OCP questions 053-17 configure controlfile autobackup on, ocpcontrolfile

17. You configure AUTOBACKUP to ON an RMAN session. When will RMAN back up the control file?

(Choose all that apply .)
A. When you run an rman backup command
B. When you run an RMAN ALLOCATE command
C. When you add or drop a table in the SYSTEM tablespace
D. When you change the physical structure of the database, such as dropping a tablespace

E. When you specify the including controlfile clause

Original answer:

Correct answer: AD

[Resolution]

The atuobackup on here refers to configure controlfile autobackup on.

In either case, the automatic backup control file is triggered:

You can back up the control file when the database is mounted or open. RMAN uses a snapshot control file to ensure a read-

Consistent version. IfCONFIGURE CONTROLFILE AUTOBACKUPCommand is setON(By default it isOFF), Then RMAN automatically

Backs up the control file and server parameter file after every backup and after database structural changes. The control file

Autobackup contains metadata about the previous backup, which is crucial fordisaster recovery

 

Manual backup control file:

If the autobackup feature is not set, then you must manually back up the control file in one of the following ways:

• RunBACKUP CURRENT CONTROLFILE.

• Include a backup of the control file within any backup by usingINCLUDE CURRENT CONTROLFILEOption ofBACKUPCommand.

• Back up data file1, Because RMAN automatically between des the control file and server parameter file in backups of data file1

 

A. rman executes the backup command;

D. The database structure is changed, for example, adding or deleting a tablespace. The 11g automatic backup delay feature is available for control files. For details, refer:

Http://blog.chinaunix.net/uid-22948773-id-3347991.html

E. Manually back up the control file. Run the BACKUP command under the rman command to specify the include current controlfile condition.