初识RMAN5：清除RMAN所有配置

不存在一个命令能将RMAN所有配置都重置为默认值，只能一个个的来进行清除，汇总命令如下，注意通道的配置，有几个通道channel就写几个配置，当然多了也无所谓，但是不能少。

CONFIGURE RETENTION POLICY clear;
CONFIGURE BACKUP OPTIMIZATION clear;
CONFIGURE DEFAULT DEVICE TYPE clear;
CONFIGURE CONTROLFILE AUTOBACKUP clear;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK clear;
CONFIGURE DEVICE TYPE DISK clear;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK clear;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK clear;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK clear;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK clear;
CONFIGURE MAXSETSIZE clear;
CONFIGURE ENCRYPTION FOR DATABASE clear;
CONFIGURE ENCRYPTION ALGORITHM clear;
CONFIGURE COMPRESSION ALGORITHM clear;
CONFIGURE RMAN OUTPUT clear; # 12c
CONFIGURE ARCHIVELOG DELETION POLICY clear;
CONFIGURE SNAPSHOT CONTROLFILE NAME clear;

RMAN> show all
2> ;

db_unique_name 为 CYANG 的数据库的 RMAN 配置参数为:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'c:\app\oracle\rman\rman_ctl_%F.bk';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXOPENFILES 32;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   'C:\app\oracle\rman\rman2_%U.bk';
CONFIGURE MAXSETSIZE TO 8 G;
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 RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\APP\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SNCFCYANG.ORA'; # default

#进行清除

RMAN> CONFIGURE RETENTION POLICY clear;

RMAN 配置参数已成功重置为默认值

RMAN> CONFIGURE BACKUP OPTIMIZATION clear;

RMAN 配置参数已成功重置为默认值

RMAN> CONFIGURE DEFAULT DEVICE TYPE clear;

RMAN 配置参数已成功重置为默认值
释放的通道: ORA_DISK_1
释放的通道: ORA_DISK_2

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP clear;

RMAN 配置参数已成功重置为默认值

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK clear;

旧的 RMAN 配置参数:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'c:\app\oracle\rman\rman_ctl_%F.bk';
RMAN 配置参数已成功重置为默认值

RMAN> CONFIGURE DEVICE TYPE DISK clear;

旧的 RMAN 配置参数:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
RMAN 配置参数已成功重置为默认值

RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK clear;

RMAN 配置参数已成功重置为默认值

RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK clear;

旧的 RMAN 配置参数:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXOPENFILES 32;
已成功删除旧的 RMAN 配置参数

RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK clear;

旧的 RMAN 配置参数:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   'C:\app\oracle\rman\rman2_%U.bk';
已成功删除旧的 RMAN 配置参数

RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK clear;

RMAN 配置参数已成功重置为默认值

RMAN> CONFIGURE MAXSETSIZE clear;

旧的 RMAN 配置参数:
CONFIGURE MAXSETSIZE TO 8 G;
RMAN 配置参数已成功重置为默认值

RMAN> CONFIGURE ENCRYPTION FOR DATABASE clear;

RMAN 配置参数已成功重置为默认值

RMAN> CONFIGURE ENCRYPTION ALGORITHM clear;

RMAN 配置参数已成功重置为默认值

RMAN> CONFIGURE COMPRESSION ALGORITHM clear;

RMAN 配置参数已成功重置为默认值

RMAN> CONFIGURE RMAN OUTPUT clear; # 12c

RMAN 配置参数已成功重置为默认值

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY clear;

RMAN 配置参数已成功重置为默认值

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME clear;

RMAN 配置参数已成功重置为默认值

#清除完成后再重新查看一下

RMAN> show all;

db_unique_name 为 CYANG 的数据库的 RMAN 配置参数为:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # 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 RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\APP\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SNCFCYANG.ORA'; # default

RMAN>