Backup And Recovery User's Guide-從RMAN開始-備份資料庫-備份處於歸檔模式的資料庫
如果資料庫執行在歸檔模式,則可以在資料庫處於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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Backup And Recovery User's Guide-從RMAN開始-備份處於非歸檔模式的資料庫GUIIDE模式資料庫
- Backup And Recovery User's Guide-備份資料庫-備份處於非歸檔模式的資料庫GUIIDE資料庫模式
- Backup And Recovery User's Guide-從RMAN開始-備份資料庫-增量備份GUIIDE資料庫
- Backup And Recovery User's Guide-從RMAN開始-備份資料庫GUIIDE資料庫
- Backup And Recovery User's Guide-備份處於非歸檔模式的資料庫GUIIDE模式資料庫
- Backup And Recovery User's Guide-備份資料庫-使用RMAN備份資料庫檔案GUIIDE資料庫
- Backup And Recovery User's Guide-從RMAN開始-備份資料庫-典型的備份選項GUIIDE資料庫
- Backup And Recovery User's Guide-備份資料庫-使用RMAN備份歸檔重做日誌GUIIDE資料庫
- Backup And Recovery User's Guide-備份資料庫-使用RMAN備份控制檔案GUIIDE資料庫
- Backup And Recovery User's Guide-從RMAN開始-驗證資料庫檔案和備份GUIIDE資料庫
- Backup And Recovery User's Guide-備份資料庫-RMAN備份概覽-RMAN備份的目的GUIIDE資料庫
- Backup And Recovery User's Guide-備份資料庫-備份歸檔重做日誌檔案GUIIDE資料庫
- Backup And Recovery User's Guide-備份資料庫-RMAN備份概覽-為RMAN備份指定TAGGUIIDE資料庫
- Backup And Recovery User's Guide-備份資料庫-使用RMAN備份表空間和資料檔案GUIIDE資料庫
- Backup And Recovery User's Guide-備份資料庫-RMAN備份概覽-為RMAN備份指定格式GUIIDE資料庫
- Backup And Recovery User's Guide-從RMAN開始-RMAN操作報表-資料庫檔案和備份報告GUIIDE資料庫
- Backup And Recovery User's Guide-從RMAN開始-練習:對資料庫進行增量備份GUIIDE資料庫
- Backup And Recovery User's Guide-備份資料庫-RMAN備份概覽-進行壓縮備份GUIIDE資料庫
- Backup And Recovery User's Guide-對於SUSPENDED資料庫的備份GUIIDE資料庫
- Backup And Recovery User's Guide-備份資料庫-RMAN備份概覽-指定備份輸出選項GUIIDE資料庫
- Backup And Recovery User's Guide-備份RMAN備份-關於備份的備份GUIIDE
- Backup And Recovery User's Guide-為長期儲存建立資料庫備份-歸檔備份的目的GUIIDE資料庫
- Backup And Recovery User's Guide-備份RMAN備份-使用RMAN備份備份集GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-維護RMAN備份-cross-checking備份GUIIDEROS
- Backup And Recovery User's Guide-從RMAN開始-維護RMAN備份-刪除過期的備份GUIIDE
- Backup And Recovery User's Guide-為長期儲存建立資料庫備份-歸檔備份的基本概念GUIIDE資料庫
- Backup And Recovery User's Guide-備份和歸檔資料-一致和不一致RMAN備份GUIIDE
- Backup And Recovery User's Guide-備份RMAN備份-用RMAN備份映象拷貝備份GUIIDE
- Backup And Recovery User's Guide-使用RMAN備份歸檔重做日誌GUIIDE
- Backup And Recovery User's Guide-恢復處於非歸檔模式的資料庫GUIIDE模式資料庫
- Backup And Recovery User's Guide-備份RMAN備份-備份集的多重拷貝GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-RMAN操作報表-列表顯示備份GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-使用閃回資料庫來回退資料庫GUIIDE資料庫
- Backup And Recovery User's Guide-從RMAN開始-恢復整個資料庫GUIIDE資料庫
- Backup And Recovery User's Guide-備份RMAN備份-備份保留期對備份的備份的影響GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-開始使用RMAN並連線到資料庫GUIIDE資料庫
- Backup And Recovery User's Guide-只備份需要備份的歸檔重做日誌檔案GUIIDE
- Backup And Recovery User's Guide-備份資料庫-聯機重做日誌切換GUIIDE資料庫