Backup And Recovery User's Guide-從RMAN開始-備份資料庫-備份處於歸檔模式的資料庫

LuiseDalian發表於2014-02-12

如果資料庫執行在歸檔模式,則可以在資料庫處於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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章