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

2023-10-08 22:32

文章标签 313 ocp 1z0 053 v12.02

本文主要是介绍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.