《RMAN中对控制的几种备份方法.doc》由会员分享，可在线阅读，更多相关《RMAN中对控制的几种备份方法.doc（7页珍藏版）》请在金锄头文库上搜索。
1、RMAN中对控制文件的几种备份方法【备份】RMAN中对控制文件的几种备份方法上一篇 / 下一篇 2010-01-26 22:56:37 / 个人分类：备份与恢复 查看( 260 ) / 评论( 0 ) / 评分( 0 / 0 ) 控制文件对于Oracle数据库来说是至关重要的，这里简单的介绍几种在RMAN中对控制文件的备份方法。1.进入RMAN命令行界面secoolersecDB /oracle/oradata$ rman target /Recovery Manager: Release 10.2.0.3.0 - Production on Wed Dec 16 16:39:15 2009C
2、opyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database: SECOOLER (DBID=21803462)RMAN2.修改控制文件备份方式为自动备份RMAN configure controlfile autobackup on;new RMAN configuration parameters:CONFIGURE CONTROLFILE AUTOBACKUP ON;new RMAN configuration parameters are successfully stored3.确认
3、参数是否修改成功，成功。RMAN show CONTROLFILE AUTOBACKUP;RMAN configuration parameters are:CONFIGURE CONTROLFILE AUTOBACKUP ON;4.修改控制文件的备份文件的存放位置，这里注意一下其中的“%F”不可或缺。RMAN configure controlfile autobackup format for device type disk to /orabackup/%F;new RMAN configuration parameters:CONFIGURE CONTROLFILE AUTOBACKU
4、P FORMAT FOR DEVICE TYPE DISK TO /orabackup/%F;new RMAN configuration parameters are successfully stored5.确认一下备份文件备份位置参数是否修改成功。成功。RMAN show controlfile autobackup format;RMAN configuration parameters are:CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO /orabackup/%F;6.此时使用“backup data
5、base”命令可以出发控制文件的备份RMAN backup database;Starting backup at 2009-12-16 16:54:21using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=146 devtype=DISKchannel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(
6、s) in backupsetinput datafile fno=00001 name=/oracle/oradata/secooler/system01.dbfinput datafile fno=00002 name=/oracle/oradata/secooler/undotbs01.dbfinput datafile fno=00003 name=/oracle/oradata/secooler/sysaux01.dbfinput datafile fno=00004 name=/oracle/oradata/secooler/users01.dbfchannel ORA_DISK_
7、1: starting piece 1 at 2009-12-16 16:54:22channel ORA_DISK_1: finished piece 1 at 2009-12-16 16:54:25piece handle=/oracle/app/oracle/flash_recovery_area/SECOOLER/backupset/2009_12_16/o1_mf_nnndf_TAG20091216T165421_5lk81y4j_.bkp tag=TAG20091216T165421 comment=NONEchannel ORA_DISK_1: backup set comple
8、te, elapsed time: 00:00:03Finished backup at 2009-12-16 16:54:25Starting Control File and SPFILE Autobackup at 2009-12-16 16:54:25piece handle=/orabackup/c-21803462-20091216-00 comment=NONEFinished Control File and SPFILE Autobackup at 2009-12-16 16:54:267.在RMAN中使用“backup current controlfile”亦可完成控制文
9、件的备份。RMAN backup current controlfile;Starting backup at 2009-12-16 22:34:31using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=141 devtype=DISKchannel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s)
10、 in backupsetincluding current control file in backupsetchannel ORA_DISK_1: starting piece 1 at 2009-12-16 22:34:31channel ORA_DISK_1: finished piece 1 at 2009-12-16 22:34:32piece handle=/oracle/app/oracle/flash_recovery_area/SECOOLER/backupset/2009_12_16/o1_mf_ncnnf_TAG20091216T223431_5lkvzqp6_.bkp
11、 tag=TAG20091216T223431 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 2009-12-16 22:34:32Starting Control File and SPFILE Autobackup at 2009-12-16 22:34:32piece handle=/orabackup/c-21803462-20091216-01 comment=NONEFinished Control File and SPFILE Autob
12、ackup at 2009-12-16 22:34:338.在RMAN中得到曾经备份过的控制文件信息RMAN list backup of controlfile;List of Backup Sets=BS Key Type LV Size Device Type Elapsed Time Completion Time- - - - - - -2 Full 6.80M DISK 00:00:00 2009-12-16 16:54:25 BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20091216T165425 Piece Name:
13、 /orabackup/c-21803462-20091216-00 Control File Included: Ckp SCN: 742397 Ckp time: 2009-12-16 16:54:25BS Key Type LV Size Device Type Elapsed Time Completion Time- - - - - - -3 Full 6.77M DISK 00:00:00 2009-12-16 22:34:31 BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20091216T223431 Piece Name
14、: /oracle/app/oracle/flash_recovery_area/SECOOLER/backupset/2009_12_16/o1_mf_ncnnf_TAG20091216T223431_5lkvzqp6_.bkp Control File Included: Ckp SCN: 763491 Ckp time: 2009-12-16 22:34:31BS Key Type LV Size Device Type Elapsed Time Completion Time- - - - - - -4 Full 6.80M DISK 00:00:00 2009-12-16 22:34:32 BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20091216T223432 Piece Name: /orabackup/c-21803462-20091216-01 Control File Included: Ckp SCN: 763495 Ckp time: 2009-12-16 22:34:329.使用R
