OracleRMAN物理備份技術之RMAN配置

　　RMAN配置介紹

　　執行show all命令可以顯示rman的當前配置

　　

　　RMAN> show all;

　　使用目標數據庫控制文件替代恢復目錄

　　RMAN 配置參數為

　　

　　CONFIGURE RETENTION POLICY TO REDUNDANCY ; # 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 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO ; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO ; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM AES; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO D:\ORACLE\PRODUCT\\DB_\
DATABASE\S NCFROMEORA; # default

　　如果想恢復某項設置我們執行如下命令CONFIGURE…… CLEAR

　　大部分配置項的值都是TO後邊的內容個別的除外例如

　　

　　CONFIGURE ENCRYPTION FOR DATABASE OFF RMAN> configure retention policy to redundancy ;

　　新的 RMAN 配置參數

　　

　　CONFIGURE RETENTION POLICY TO REDUNDANCY ;

　　已成功存儲新的 RMAN 配置參數

　　

　　RMAN> show all;

　　RMAN 配置參數為

　　

　　CONFIGURE RETENTION POLICY TO REDUNDANCY ; 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 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO ; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO ; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM AES; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO D:\ORACLE\PRODUCT\\DB_\
DATABASE\S NCFROMEORA; # default RMAN> configure retention policy clear;

　　舊的 RMAN 配置參數

　　

　　CONFIGURE RETENTION POLICY TO REDUNDANCY ;

　　RMAN 配置參數已成功重置為默認值

　　

　　RMAN> show all;

　　RMAN 配置參數為

　　

　　CONFIGURE RETENTION POLICY TO REDUNDANCY ; # 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 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO ; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO ; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM AES; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO D:\ORACLE\PRODUCT\\DB_\
DATABASE\S NCFROMEORA; # default

From:http://tw.wingwit.com/Article/program/Oracle/201311/18479.html