OCP試題解析之053-17 CONFIGURE CONTROLFILE AUTOBACKUP ON，ocpcontrolfile

OCP試題解析之053-17 CONFIGURE CONTROLFILE AUTOBACKUP ON，ocpcontrolfile

17.You configure AUTOBACKUP to ON in 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

原答案：A  

正確答案:  AD

【解析】

此處的atuobackup on 指：CONFIGURE CONTROLFILE AUTOBACKUP ON。

此時有2種情況會觸發自動備份控制檔案：

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. If theCONFIGURE CONTROLFILE AUTOBACKUP command is set to ON (by default it is OFF), 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

 

手動備份控制檔案：

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

• Run BACKUP CURRENT CONTROLFILE .

• Include a backup of the control file within any backup by using the INCLUDE CURRENT CONTROLFILE option of the BACKUP command.

• Back up data file 1, because RMAN automatically includes the control file and server parameter file in backups of data file 1

 

A、rman執行backup命令；

D、資料庫結構發生改變，如：新增或刪除資料表空間操作。11g有控制檔案自動延遲備份特性，詳細參考：

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

E、手動備份控制檔案，rman命令下執行備份命令 指定include current controlfile條件。