Oracle 12C 新特性:關於歸檔日誌的備份
關於歸檔日誌的備份:
RMAN> backup archivelog all;
Starting backup at 2014/12/10 10:38:50
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 log thread=1 sequence=165 RECID=3 STAMP=865293027
input archived log thread=2 sequence=7 RECID=1 STAMP=865288883
input archived log thread=2 sequence=8 RECID=2 STAMP=865293024
input archived log thread=2 sequence=9 RECID=4 STAMP=865328414
input archived log thread=1 sequence=166 RECID=5 STAMP=865342807
input archived log thread=2 sequence=10 RECID=7 STAMP=865362889
input archived log thread=1 sequence=167 RECID=6 STAMP=865362869
input archived log thread=1 sequence=168 RECID=8 STAMP=865362890
input archived log thread=2 sequence=11 RECID=9 STAMP=865375273
input archived log thread=1 sequence=169 RECID=11 STAMP=865407611
input archived log thread=2 sequence=12 RECID=10 STAMP=865379040
input archived log thread=2 sequence=13 RECID=12 STAMP=865418414
input archived log thread=1 sequence=170 RECID=13 STAMP=865458005
input archived log thread=2 sequence=14 RECID=14 STAMP=865461643
input archived log thread=1 sequence=171 RECID=17 STAMP=865486506
input archived log thread=2 sequence=15 RECID=15 STAMP=865461711
input archived log thread=2 sequence=16 RECID=16 STAMP=865486505
input archived log thread=2 sequence=17 RECID=19 STAMP=865533659
input archived log thread=1 sequence=172 RECID=18 STAMP=865533657
input archived log thread=1 sequence=173 RECID=20 STAMP=865548080
input archived log thread=2 sequence=18 RECID=22 STAMP=865576838
input archived log thread=1 sequence=174 RECID=21 STAMP=865569624
input archived log thread=1 sequence=175 RECID=23 STAMP=865588301
input archived log thread=2 sequence=19 RECID=24 STAMP=865605820
input archived log thread=1 sequence=176 RECID=25 STAMP=865616406
input archived log thread=2 sequence=20 RECID=26 STAMP=865623625
input archived log thread=1 sequence=177 RECID=27 STAMP=865641607
input archived log thread=2 sequence=21 RECID=28 STAMP=865652432
input archived log thread=1 sequence=178 RECID=29 STAMP=865663260
input archived log thread=2 sequence=22 RECID=31 STAMP=865692038
input archived log thread=1 sequence=179 RECID=30 STAMP=865677627
input archived log thread=1 sequence=180 RECID=32 STAMP=865692040
input archived log thread=2 sequence=23 RECID=33 STAMP=865721886
input archived log thread=1 sequence=181 RECID=34 STAMP=865728009
input archived log thread=2 sequence=24 RECID=35 STAMP=865742445
input archived log thread=1 sequence=182 RECID=36 STAMP=865771254
input archived log thread=2 sequence=25 RECID=37 STAMP=865781920
input archived log thread=1 sequence=183 RECID=38 STAMP=865807254
input archived log thread=2 sequence=26 RECID=41 STAMP=865811408
input archived log thread=1 sequence=184 RECID=39 STAMP=865807359
input archived log thread=1 sequence=185 RECID=40 STAMP=865811407
input archived log thread=1 sequence=186 RECID=42 STAMP=865814687
input archived log thread=2 sequence=27 RECID=44 STAMP=865857620
input archived log thread=1 sequence=187 RECID=43 STAMP=865846803
input archived log thread=1 sequence=188 RECID=45 STAMP=865890033
input archived log thread=2 sequence=28 RECID=46 STAMP=865893651
input archived log thread=1 sequence=189 RECID=48 STAMP=865901143
input archived log thread=2 sequence=29 RECID=47 STAMP=865893764
input archived log thread=2 sequence=30 RECID=49 STAMP=865908013
input archived log thread=1 sequence=190 RECID=50 STAMP=865922416
input archived log thread=2 sequence=31 RECID=51 STAMP=865938853
input archived log thread=1 sequence=191 RECID=52 STAMP=865939133
input archived log thread=2 sequence=32 RECID=53 STAMP=865939135
channel ORA_DISK_1: starting piece 1 at 2014/12/10 10:39:02
channel ORA_DISK_1: finished piece 1 at 2014/12/10 10:39:47
piece handle=+ARCH/CLOUD/BACKUPSET/2014_12_10/annnf0_tag20141210t103900_0.278.865939143 tag=TAG20141210T103900 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
Finished backup at 2014/12/10 10:39:47
Starting Control File and SPFILE Autobackup at 2014/12/10 10:39:48
piece handle=+ARCH/CLOUD/AUTOBACKUP/2014_12_10/s_865939188.277.865939189 comment=NONE
Finished Control File and SPFILE Autobackup at 2014/12/10 10:39:49
RMAN> backup archivelog all database pdb01;
Starting backup at 2014/12/10 10:45:30
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 log thread=1 sequence=188 RECID=45 STAMP=865890033
input archived log thread=2 sequence=28 RECID=46 STAMP=865893651
input archived log thread=1 sequence=189 RECID=48 STAMP=865901143
input archived log thread=2 sequence=29 RECID=47 STAMP=865893764
input archived log thread=2 sequence=30 RECID=49 STAMP=865908013
input archived log thread=1 sequence=190 RECID=50 STAMP=865922416
input archived log thread=2 sequence=31 RECID=51 STAMP=865938853
input archived log thread=1 sequence=191 RECID=52 STAMP=865939133
input archived log thread=2 sequence=32 RECID=53 STAMP=865939135
input archived log thread=1 sequence=192 RECID=54 STAMP=865939442
input archived log thread=2 sequence=33 RECID=55 STAMP=865939444
input archived log thread=1 sequence=193 RECID=57 STAMP=865939532
input archived log thread=2 sequence=34 RECID=56 STAMP=865939531
channel ORA_DISK_1: starting piece 1 at 2014/12/10 10:45:36
channel ORA_DISK_1: finished piece 1 at 2014/12/10 10:45:43
piece handle=+ARCH/CLOUD/BACKUPSET/2014_12_10/annnf0_tag20141210t104535_0.278.865939537 tag=TAG20141210T104535 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00009 name=+DATA/CLOUD/09207FB3299032D4E055000000000001/DATAFILE/sysaux.287.865165777
input datafile file number=00008 name=+DATA/CLOUD/09207FB3299032D4E055000000000001/DATAFILE/system.286.865165777
input datafile file number=00011 name=+DATA/CLOUD/09207FB3299032D4E055000000000001/DATAFILE/mon_asmtbs.290.865760705
input datafile file number=00010 name=+DATA/CLOUD/09207FB3299032D4E055000000000001/DATAFILE/users.289.865165855
channel ORA_DISK_1: starting piece 1 at 2014/12/10 10:45:43
channel ORA_DISK_1: finished piece 1 at 2014/12/10 10:45:58
piece handle=+ARCH/CLOUD/09207FB3299032D4E055000000000001/BACKUPSET/2014_12_10/nnndf0_tag20141210t104535_0.317.865939543 tag=TAG20141210T104535 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 2014/12/10 10:45:58
Starting Control File and SPFILE Autobackup at 2014/12/10 10:45:58
piece handle=+ARCH/CLOUD/AUTOBACKUP/2014_12_10/s_865939558.316.865939559 comment=NONE
Finished Control File and SPFILE Autobackup at 2014/12/10 10:45:59
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
29 299.19M DISK 00:00:06 2014/12/10 10:45:41
BP Key: 29 Status: AVAILABLE Compressed: NO Tag: TAG20141210T104535
Piece Name: +ARCH/CLOUD/BACKUPSET/2014_12_10/annnf0_tag20141210t104535_0.278.865939537
List of Archived Logs in backup set 29
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 188 2855443 2014/12/09 09:00:01 2901502 2014/12/09 21:00:32
1 189 2901502 2014/12/09 21:00:32 2940886 2014/12/10 00:05:41
1 190 2940886 2014/12/10 00:05:41 2966958 2014/12/10 06:00:14
1 191 2966958 2014/12/10 06:00:14 2984480 2014/12/10 10:38:52
1 192 2984480 2014/12/10 10:38:52 2984758 2014/12/10 10:44:01
1 193 2984758 2014/12/10 10:44:01 2984883 2014/12/10 10:45:32
2 28 2867741 2014/12/09 12:00:19 2911287 2014/12/09 22:00:49
2 29 2911287 2014/12/09 22:00:49 2925974 2014/12/09 22:02:43
2 30 2925974 2014/12/09 22:02:43 2950235 2014/12/10 02:00:12
2 31 2950235 2014/12/10 02:00:12 2984280 2014/12/10 10:34:12
2 32 2984280 2014/12/10 10:34:12 2984484 2014/12/10 10:38:55
2 33 2984484 2014/12/10 10:38:55 2984762 2014/12/10 10:44:04
2 34 2984762 2014/12/10 10:44:04 2984879 2014/12/10 10:45:31
RMAN> list backup of database;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
30 Full 780.38M DISK 00:00:14 2014/12/10 10:45:57
BP Key: 30 Status: AVAILABLE Compressed: NO Tag: TAG20141210T104535
Piece Name: +ARCH/CLOUD/09207FB3299032D4E055000000000001/BACKUPSET/2014_12_10/nnndf0_tag20141210t104535_0.317.865939543
List of Datafiles in backup set 30
Container ID: 3, PDB Name: PDB01
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
8 Full 2984892 2014/12/10 10:45:43 +DATA/CLOUD/09207FB3299032D4E055000000000001/DATAFILE/system.286.865165777
9 Full 2984892 2014/12/10 10:45:43 +DATA/CLOUD/09207FB3299032D4E055000000000001/DATAFILE/sysaux.287.865165777
10 Full 2984892 2014/12/10 10:45:43 +DATA/CLOUD/09207FB3299032D4E055000000000001/DATAFILE/users.289.865165855
11 Full 2984892 2014/12/10 10:45:43 +DATA/CLOUD/09207FB3299032D4E055000000000001/DATAFILE/mon_asmtbs.290.865760705
RMAN> list backupset of controlfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
31 Full 18.17M DISK 00:00:01 2014/12/10 10:45:59
BP Key: 31 Status: AVAILABLE Compressed: NO Tag: TAG20141210T104558
Piece Name: +ARCH/CLOUD/AUTOBACKUP/2014_12_10/s_865939558.316.865939559
Control File Included: Ckp SCN: 2984907 Ckp time: 2014/12/10 10:45:58
RMAN> list backup of spfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
31 Full 18.17M DISK 00:00:01 2014/12/10 10:45:59
BP Key: 31 Status: AVAILABLE Compressed: NO Tag: TAG20141210T104558
Piece Name: +ARCH/CLOUD/AUTOBACKUP/2014_12_10/s_865939558.316.865939559
SPFILE Included: Modification time: 2014/12/09 22:00:11
SPFILE db_unique_name: CLOUD
RMAN> backup archivelog all database root;
Starting backup at 2014/12/10 10:50:58
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 log thread=1 sequence=188 RECID=45 STAMP=865890033
input archived log thread=2 sequence=28 RECID=46 STAMP=865893651
input archived log thread=1 sequence=189 RECID=48 STAMP=865901143
input archived log thread=2 sequence=29 RECID=47 STAMP=865893764
input archived log thread=2 sequence=30 RECID=49 STAMP=865908013
input archived log thread=1 sequence=190 RECID=50 STAMP=865922416
input archived log thread=2 sequence=31 RECID=51 STAMP=865938853
input archived log thread=1 sequence=191 RECID=52 STAMP=865939133
input archived log thread=2 sequence=32 RECID=53 STAMP=865939135
input archived log thread=1 sequence=192 RECID=54 STAMP=865939442
input archived log thread=2 sequence=33 RECID=55 STAMP=865939444
input archived log thread=1 sequence=193 RECID=57 STAMP=865939532
input archived log thread=2 sequence=34 RECID=56 STAMP=865939531
input archived log thread=2 sequence=35 RECID=58 STAMP=865939859
input archived log thread=1 sequence=194 RECID=59 STAMP=865939859
channel ORA_DISK_1: starting piece 1 at 2014/12/10 10:51:00
channel ORA_DISK_1: finished piece 1 at 2014/12/10 10:51:07
piece handle=+ARCH/CLOUD/BACKUPSET/2014_12_10/annnf0_tag20141210t105059_0.278.865939861 tag=TAG20141210T105059 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/CLOUD/DATAFILE/sysaux.262.864952711
input datafile file number=00005 name=+DATA/CLOUD/DATAFILE/undotbs1.264.864952717
input datafile file number=00001 name=+DATA/CLOUD/DATAFILE/system.260.864952703
input datafile file number=00006 name=+DATA/CLOUD/DATAFILE/undotbs2.267.864952747
input datafile file number=00007 name=+DATA/CLOUD/DATAFILE/users.268.864952749
channel ORA_DISK_1: starting piece 1 at 2014/12/10 10:51:07
channel ORA_DISK_1: finished piece 1 at 2014/12/10 10:51:42
piece handle=+ARCH/CLOUD/BACKUPSET/2014_12_10/nnndf0_tag20141210t105059_0.315.865939867 tag=TAG20141210T105059 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
Finished backup at 2014/12/10 10:51:42
Starting Control File and SPFILE Autobackup at 2014/12/10 10:51:42
piece handle=+ARCH/CLOUD/AUTOBACKUP/2014_12_10/s_865939902.314.865939903 comment=NONE
Finished Control File and SPFILE Autobackup at 2014/12/10 10:51:43
從上述兩個歸檔日誌的備份來看,無論如何指定需要備份的資料庫歸檔,最終結果都是所有的歸檔日誌均做備份,同時將指定的資料庫也做了備份。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28612416/viewspace-1379960/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 備份歸檔日誌
- 備份歸檔日誌檔案
- 備份之歸檔重做日誌備份
- 歸檔日誌大小 與使用rman 備份後的歸檔日誌產生的備份集大小的關係
- Oracle設定多個歸檔路徑生成多份歸檔日誌,Rman備份時也只備份其中的一份歸檔日誌Oracle
- oracle rman備份歸檔日誌需要先切換日誌嗎Oracle
- rman全庫備份備份歸檔日誌檔案
- Oracle使用備份檔案集恢復歸檔日誌Oracle
- RMAN備份歸檔日誌多份 %c
- 手工rm刪除歸檔日誌對備份歸檔日誌的影響
- 冷備份+歸檔日誌的恢復
- RMAN備份歸檔日誌指令碼指令碼
- 用RMAN備份歸檔日誌時檢查歸檔日誌是否存在
- 誤刪歸檔日誌除導致備份歸檔日誌失敗
- RMAN備份整庫和歸檔日誌的方法
- rman備份後為什麼要同時備份歸檔日誌
- oracle rman不能自動刪除歸檔日誌備份解決Oracle
- DELETE OBSOLETE不刪除歸檔日誌以及歸檔的備份集delete
- oracle歸檔日誌Oracle
- Oracle 歸檔日誌Oracle
- oracle 歸檔日誌開啟,關閉Oracle
- Oracle RMAN 不完全恢復(只有資料檔案備份,丟失歸檔日誌備份)Oracle
- RMAN備份資料檔案+控制檔案+歸檔日誌
- RMAN備份及恢復歸檔日誌的語法
- RMAN備份與恢復(新舊控制檔案及歸檔日誌)測試
- 關於歸檔日誌的切換測試
- oracle 關於-日誌檔案Oracle
- 備份與恢復--從備份的歸檔日誌中恢復資料
- 【Oracle】歸檔日誌管理-設定歸檔日誌路徑以及歸檔日誌冗餘Oracle
- RMAN備份與恢復(新舊控制檔案及歸檔日誌)測試(敘)
- ORACLE 歸檔日誌開啟關閉方法Oracle
- 歸檔oracle alert日誌Oracle
- Backup And Recovery User's Guide-只備份需要備份的歸檔重做日誌檔案GUIIDE
- oracle 12c 新特性之二:可以記錄DDL日誌Oracle
- 老虎是如何從備份集中恢復歸檔日誌
- 聯機重做日誌、歸檔日誌、備用重做日誌
- 通過nfs共享目錄實現oracle 歸檔日誌遠端備份NFSOracle
- TSM備份時因歸檔日誌丟失而導致備份失敗