本文共 4985 字，大约阅读时间需要 16 分钟。
1、首先要设置控制文件自动备份
2、自动化恢复脚本，使用如下命令restore controlfile from autobackup;
此命令会找到最新的控制文件进行恢复，以下做一个测试来验证。
多次备份数据文件，生成多个控制文件备份。然后进行恢复操作，发现找到最近备份的控制文件进行恢复，我们也可以按照时间进行控制文件的删除。操作过程如下：RMAN> show all;RMAN configuration parameters for database with db_unique_name ORCL are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION ON;CONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP ON;CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE MAXSETSIZE TO UNLIMITED; # defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultCONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl1.f'; # defaultRMAN> delete backup of controlfile completed before 'sysdate-1/10';using channel ORA_DISK_1List of Backup PiecesBP Key BS Key Pc# Cp# Status Device Type Piece Name------- ------- --- --- ----------- ----------- ----------2 2 1 1 AVAILABLE DISK /u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-1515642676-20180927-004 4 1 1 AVAILABLE DISK /u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-1515642676-20180927-01Do you really want to delete the above objects (enter YES or NO)? noRMAN> RMAN> list backup of controlfile;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------2 Full 17.70M DISK 00:00:02 27-SEP-2018 11:08:08 BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20180927×××10806 Piece Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-1515642676-20180927-00 Control File Included: Ckp SCN: 794221 Ckp time: 27-SEP-2018 11:08:06BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------4 Full 17.70M DISK 00:00:05 27-SEP-2018 11:09:18 BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20180927×××10913 Piece Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-1515642676-20180927-01 Control File Included: Ckp SCN: 794259 Ckp time: 27-SEP-2018 11:09:13BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------6 Full 17.70M DISK 00:00:01 27-SEP-2018 14:13:46 BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20180927×××41345 Piece Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-1515642676-20180927-02 Control File Included: Ckp SCN: 801298 Ckp time: 27-SEP-2018 14:13:45BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------8 Full 17.70M DISK 00:00:01 27-SEP-2018 14:15:02 BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20180927×××41501 Piece Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-1515642676-20180927-03 Control File Included: Ckp SCN: 801359 Ckp time: 27-SEP-2018 14:15:01BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------10 Full 17.70M DISK 00:00:01 27-SEP-2018 14:16:06 BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20180927×××41605 Piece Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-1515642676-20180927-04 Control File Included: Ckp SCN: 801655 Ckp time: 27-SEP-2018 14:16:05BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------------12 Full 17.70M DISK 00:00:01 27-SEP-2018 14:16:27 BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20180927×××41626 Piece Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-1515642676-20180927-05 Control File Included: Ckp SCN: 801678 Ckp time: 27-SEP-2018 14:16:26RMAN> restore controlfile to '/tmp/control01.clt' from autobackup;Starting restore at 27-SEP-2018 14:28:50using channel ORA_DISK_1channel ORA_DISK_1: looking for AUTOBACKUP on day: 20180927channel ORA_DISK_1: AUTOBACKUP found: c-1515642676-20180927-05channel ORA_DISK_1: restoring control file from AUTOBACKUP c-1515642676-20180927-05channel ORA_DISK_1: control file restore from AUTOBACKUP completeFinished restore at 27-SEP-2018 14:28:53RMAN>
转载于:https://blog.51cto.com/roidba/2286606