OCP-1Z0-053-V12.02-313题

313.What command would you issue to enable automated backups of control files?

A. alter database controlfile autobackup on

B. alter system controlfile autobackup on

C. configure controlfile autobackup on

D. enable controlfile autobackup

Answer: C

答案解析：

RMAN> show all;

RMAN configuration parameters for database with db_unique_name TEST0910 are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_test0910.f'; # default

将默认值

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

改为

CONFIGURE CONTROLFILE AUTOBACKUP ON就可以自动备份控制文件了。

CONTROLFILE AUTOBACKUP

Controls the control file autobackup feature.

Note: You should enable control file autobackup feature when using RMAN without a recovery catalog.

ON

Specifies that RMAN should perform a control file autobackup in the following circumstances:

After every BACKUPor CREATE CATALOG command issued at the RMAN prompt.
Whenever a BACKUP command within a RUN block is followed by a command that is not BACKUP.
After every RUN block if the last command in the block was BACKUP.
After structural changes for databases in ARCHIVELOG mode. The autobackup after structural changes does not occur for databases in NOARCHIVELOG mode.