Backup And Recovery User's Guide-從RMAN開始-練習:對資料庫進行增量備份
練習:對資料庫進行增量備份
--對資料庫進行增量備份 --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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 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-建立和更新增量備份-進行增量備份GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-備份資料庫-備份處於歸檔模式的資料庫GUIIDE資料庫模式
- Backup And Recovery User's Guide-備份資料庫-RMAN備份概覽-進行壓縮備份GUIIDE資料庫
- Backup And Recovery User's Guide-進行增量備份-進行VSS快照的增量備份(略)GUIIDE
- Backup And Recovery User's Guide-RMAN備份概念-增量備份-累積增量備份-練習GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-維護RMAN備份-cross-checking備份GUIIDEROS
- 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備份概覽-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開始-維護RMAN備份-刪除過期的備份GUIIDE
- Backup And Recovery User's Guide-備份資料庫-使用RMAN備份控制檔案GUIIDE資料庫
- Backup And Recovery User's Guide-備份資料庫-RMAN備份概覽-為RMAN備份指定TAGGUIIDE資料庫
- Backup And Recovery User's Guide-對於SUSPENDED資料庫的備份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開始-使用閃回資料庫來回退資料庫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開始-概覽RMAN環境GUIIDE
- Backup And Recovery User's Guide-備份資料庫-使用RMAN備份歸檔重做日誌GUIIDE資料庫
- Backup And Recovery User's Guide-建立和更新增量備份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備份概覽-指定備份輸出選項GUIIDE資料庫
- Backup And Recovery User's Guide-備份RMAN備份-用RMAN備份映象拷貝備份GUIIDE