ITPub博客

首页 > 数据库 > Oracle > Backup And Recovery User's Guide-从RMAN开始-练习:对数据库进行增量备份

Backup And Recovery User's Guide-从RMAN开始-练习:对数据库进行增量备份

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

练习:对数据库进行增量备份

--对数据库进行增量备份

--0. 使数据库运行在归档模式

    --1.RMAN连接到目标数据库

[oracle@S1011:/export/home/oracle]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jul 4 16:13:57 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TESTDB11 (DBID=2578856066)

--2. 创建level 0增量备份

RMAN> backup incremental level 0 database;

Starting backup at 04-JUL-13

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=35 device type=DISK

channel ORA_DISK_1: starting incremental level 0 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=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_nnnd0_TAG20130704T161551_8xcsj7rb_.bkp tag=TAG20130704T161551 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:05:57

channel ORA_DISK_1: starting incremental level 0 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_ncsn0_TAG20130704T161551_8xcsvhpm_.bkp tag=TAG20130704T161551 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 04-JUL-13

--3. 创建level 1累积增量备份

RMAN> backup incremental level 1 cumulative database;

Starting backup at 04-JUL-13

using channel ORA_DISK_1

channel ORA_DISK_1: starting incremental level 1 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=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_nnnd1_TAG20130704T162253_8xcsxh18_.bkp tag=TAG20130704T162253 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:07:05

channel ORA_DISK_1: starting incremental level 1 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_ncsn1_TAG20130704T162253_8xctbrds_.bkp tag=TAG20130704T162253 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 04-JUL-13

--4. 创建level 1差异增量备份

RMAN> backup incremental level 1 database;

Starting backup at 04-JUL-13

using channel ORA_DISK_1

channel ORA_DISK_1: starting incremental level 1 datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1080394/,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    5643943