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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle設定多個歸檔路徑生成多份歸檔日誌，Rman備份時也只備份其中的一份歸檔日誌Oracle
- oracle rman備份歸檔日誌需要先切換日誌嗎Oracle
- Oracle使用備份檔案集恢復歸檔日誌Oracle
- 手工rm刪除歸檔日誌對備份歸檔日誌的影響
- oracle歸檔日誌Oracle
- RMAN備份整庫和歸檔日誌的方法
- 歸檔oracle alert日誌Oracle
- Oracle歸檔日誌清理Oracle
- 【Oracle】歸檔日誌管理-設定歸檔日誌路徑以及歸檔日誌冗餘Oracle
- oracle 如何不備份已經備份的歸檔Oracle
- Oracle 12c 關閉歸檔模式Oracle模式
- 如何快速找到備份過最近、最大序號的歸檔日誌
- oracle 刪除過期的歸檔日誌Oracle
- oracle11G歸檔日誌管理Oracle
- Oracle12C新特性_DDL日誌Oracle
- Oralce資料庫關閉歸檔日誌並且刪除歸檔日誌資料庫
- 12C關於CDB、PDB 日誌檔案redo log的總結
- 【REDO】Oracle 日誌挖掘，分析歸檔日誌線上日誌主要步驟Oracle
- oracle dg 歸檔日誌恢復情況Oracle
- 【SQL】Oracle 歸檔日誌暴增原因分析SQLOracle
- Oracle歸檔日誌暴增排查優化Oracle優化
- ORACLE NBU調取oracle rman指令碼備份歸檔不自動刪除歸檔Oracle指令碼
- Oracle DataGuard歸檔日誌丟失處理方法Oracle
- oracle資料庫歸檔日誌量陡增分析Oracle資料庫
- oracle 12c rman備份pdbOracle
- 歸檔日誌挖掘
- PostgreSQL 歸檔日誌SQL
- Oracle 12C新特性-History命令Oracle
- Oracle 12C新特性In-MemoryOracle
- Oracle 12c 兩個新特性Oracle
- Oracle 12c新特性--ASMFD（ASM Filter Driver）特性OracleASMFilter
- 在Oracle中，如何定時刪除歸檔日誌檔案？Oracle
- Oracle 12c 備份與恢復Oracle
- 14. 日誌歸檔
- Oracle 12C新特性-RMAN恢復表Oracle
- Oracle 12c新特性---Rapid Home Provisioning (RHP)OracleAPI
- 12c日誌檔案路徑
- Oracle歸檔日誌所在目錄時間不對&&Oracle叢集日誌時間顯示錯誤Oracle
- 批量註冊歸檔日誌