Backup And Recovery User's Guide-從RMAN開始-練習:對資料庫進行增量備份

LuiseDalian發表於2014-02-12

練習:對資料庫進行增量備份

--對資料庫進行增量備份

--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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章