1、Use the CONFIGURE CONTROLFILE AUTOBACKUP command to eanable

設置RMAN配置文件，將CONFIGE CONTROLFILE AUTOBACKUP 為ON狀態，可以是實現控制文件的備份。如果CONFIGURE CONTROLFILE AUTOBACKUP 為OFF,那么在備份system表空間的時候，也會備份congrol file。

2、when enabled,RMAN automatically performs a back up of the control file and current server parameter file after BACKUP or COPY commands.

3、Back ups also occur after structural changes to the database .

4、Backup is given a default name.

備份Controlfile與system parameter file的方法

（一）、設置如下配置參數，實現controlfile與system parameter file的備份?

RMAN> show all;RMAN configuration parameters for database with db_unique_name POLI are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; 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/oracle/dbs/snapcf_poli.f'; # default

?（二）、執行命令backup current controlfile，實現controlfile與spfile的備份;(單獨執行controlfile與spfile的命令)

RMAN> backup current controlfile;Starting backup at 23-MAR-13 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set channel ORA_DISK_1: starting piece 1 at 23-MAR-13 channel ORA_DISK_1: finished piece 1 at 23-MAR-13 piece handle=/u01/flash_recovery_area/POLI/backupset/2013_03_23/o1_mf_ncnnf_TAG20130323T234359_8nvmg18j_.bkp tag=TAG20130323T234359 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 Finished backup at 23-MAR-13Starting Control File Autobackup at 23-MAR-13 piece handle=/u01/flash_recovery_area/POLI/autobackup/2013_03_23/o1_mf_n_810863044_8nvmg4dv_.bkp comment=NONE Finished Control File Autobackup at 23-MAR-13

（三）、使用include子句，實現control file的備份

RMAN> backup datafile 4 include current controlfile;Starting backup at 23-MAR-13 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00004 name=/u01/oradata/poli/users01.dbf channel ORA_DISK_1: starting piece 1 at 23-MAR-13 channel ORA_DISK_1: finished piece 1 at 23-MAR-13 piece handle=/u01/flash_recovery_area/POLI/backupset/2013_03_23/o1_mf_nnndf_TAG20130323T234751_8nvmo843_.bkp tag=TAG20130323T234751 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set channel ORA_DISK_1: starting piece 1 at 23-MAR-13 channel ORA_DISK_1: finished piece 1 at 23-MAR-13 piece handle=/u01/flash_recovery_area/POLI/backupset/2013_03_23/o1_mf_ncnnf_TAG20130323T234751_8nvmod9y_.bkp tag=TAG20130323T234751 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 23-MAR-13Starting Control File Autobackup at 23-MAR-13 piece handle=/u01/flash_recovery_area/POLI/autobackup/2013_03_23/o1_mf_n_810863277_8nvmofjy_.bkp comment=NONE Finished Control File Autobackup at 23-MAR-13

（四）、使用SQL命令備份controlfile

RMAN> sql "alter database backup controlfile to ''/tmp/poli_df.bak''";sql statement: alter database backup controlfile to ''/tmp/poli_df.bak''

?

轉載于:https://www.cnblogs.com/arcer/archive/2013/03/23/2977904.html

總結

以上是生活随笔為你收集整理的使用RMAN备份控制文件(control file)和系统参数文件(spfile)的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。