636.Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)
A. Backup retention policy
B. Default backup device type
C. Default destinations for backups
D. Multiple backup device types for single backup
E. Default section size for backups
Answer: ABC
答案解析:
参考:http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmconfb.htm#BRADV89399
Showing and Clearing Persistent RMAN Configurations
You can use the SHOW command to display the current value of RMAN configured settings for the target database. You can also view whether these commands are currently set to their default values.
To view or change your CONFIGURE command settings:
-
Start RMAN and connect to a target database and a recovery catalog (if used).
-
Run the RMAN
SHOWcommand.For example, run
SHOW ALLas shown in Example 5-1 (sample output included). The output includes both parameters that you have changed and those that are set to the default. The configuration is displayed as the series of RMAN commands required to re-create the configuration. You can save the output in a text file and use this command file to re-create the configuration on the same or a different database.SHOW ALL;RMAN configuration parameters for database with db_unique_name PROD1 are:CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;CONFIGURE BACKUP OPTIMIZATION ON;CONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP ON;CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # defaultCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultCONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_DEVICE=tape1)';CONFIGURE MAXSETSIZE TO UNLIMITED; # defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO '/disk1/oracle/dbs/snapcf_ev.f'; # defaultYou can also use the
SHOWcommand with the name of a particular configuration. For example, you can view the retention policy and default device type as follows:SHOW RETENTION POLICY;SHOW DEFAULT DEVICE TYPE; -
Optionally, use the
CONFIGURE ... CLEARcommand to return any configuration to its default value, as shown in the following examples:CONFIGURE BACKUP OPTIMIZATION CLEAR;CONFIGURE RETENTION POLICY CLEAR;CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;

本文介绍了如何使用RMAN命令来查看和清除Oracle数据库的持久化配置设置,包括备份保留策略、默认备份设备类型及默认备份目标等。同时,提供了如何显示当前配置值以及将其还原为默认值的方法。
2503

被折叠的 条评论
为什么被折叠?



