如果数据库运行在归档模式,则可以在数据库处于OPEN状态时对它进行备份。
这种备份称为不一致备份,因为在恢复的过程中需要redo数据来使数据库达到一致的状态。
如果具有恢复备份需要的归档重做日志,则打开不一致的数据库备份和一致的数据库备份会一样的高效。
-- 备份数据库和所有的归档重做日志到默认的备份设备 --0. 使数据库运行于归档模式 --1. 确定快速恢复区的位置 sys@TESTDB11>show parameter db_recovery_file_dest
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------------- db_recovery_file_dest string /u01/app/oracle/fast_recovery_area db_recovery_file_dest_size big integer 4122M --2.查看快速恢复区中的内容 [oracle@S1011:/export/home/oracle]$ cd $ORACLE_BASE/fast_recovery_area [oracle@S1011:/u01/app/oracle/fast_recovery_area]$ ls TestDB11 TESTDB11 --3.备份数据库和所有的归档重做日志文件 RMAN> backup database plus archivelog;
Starting backup at 04-JUL-13 current log archived allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=47 device type=DISK channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=89 RECID=1 STAMP=819268921 input archived log thread=1 sequence=90 RECID=2 STAMP=819369206 input archived log thread=1 sequence=91 RECID=3 STAMP=819370332 input archived log thread=1 sequence=92 RECID=4 STAMP=819384246 input archived log thread=1 sequence=93 RECID=5 STAMP=819487734 input archived log thread=1 sequence=94 RECID=6 STAMP=819495418 input archived log thread=1 sequence=95 RECID=7 STAMP=819621139 input archived log thread=1 sequence=96 RECID=8 STAMP=819622169 input archived log thread=1 sequence=97 RECID=9 STAMP=819671244 input archived log thread=1 sequence=98 RECID=10 STAMP=819706967 input archived log thread=1 sequence=99 RECID=11 STAMP=819712632 input archived log thread=1 sequence=100 RECID=12 STAMP=819799585 input archived log thread=1 sequence=101 RECID=13 STAMP=819879532 input archived log thread=1 sequence=102 RECID=14 STAMP=819892613 channel ORA_DISK_1: starting piece 1 at 04-JUL-13 channel ORA_DISK_1: finished piece 1 at 04-JUL-13 piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/backupset/2013_07_04/o1_mf_annnn_TAG20130704T115653_8xcbbpv0_.bkp tag=TAG20130704T115653 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35 Finished backup at 04-JUL-13
Starting backup at 04-JUL-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=00001 name=/u01/app/oracle/oradata/TestDB11/system01.dbf input datafile file number=00002 name=/u01/app/oracle/oradata/TestDB11/sysaux01.dbf input datafile file number=00005 name=/u01/app/oracle/oradata/TestDB11/example01.dbf input datafile file number=00003 name=/u01/app/oracle/oradata/TestDB11/undotbs01.dbf input datafile file number=00006 name=/u01/app/oracle/oradata/TestDB11/application01.dbf input datafile file number=00007 name=/u01/app/oracle/oradata/TestDB11/project01.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/TestDB11/users01.dbf channel ORA_DISK_1: starting piece 1 at 04-JUL-13 channel ORA_DISK_1: finished piece 1 at 04-JUL-13 piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/backupset/2013_07_04/o1_mf_nnndf_TAG20130704T115729_8xcbcv92_.bkp tag=TAG20130704T115729 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:07:45 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 including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 04-JUL-13 channel ORA_DISK_1: finished piece 1 at 04-JUL-13 piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/backupset/2013_07_04/o1_mf_ncsnf_TAG20130704T115729_8xcbtgn3_.bkp tag=TAG20130704T115729 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 04-JUL-13
Starting backup at 04-JUL-13 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1079901/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1079901/