ITPub博客

首页 > 数据库 > Oracle > Backup And Recovery User's Guide-从RMAN开始-备份数据库-备份处于归档模式的数据库

Backup And Recovery User's Guide-从RMAN开始-备份数据库-备份处于归档模式的数据库

原创 Oracle 作者:luisedalian 时间:2014-02-12 09:24:08 0 删除 编辑

如果数据库运行在归档模式,则可以在数据库处于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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    5642323