关于归档日志的备份:
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
从上述两个归档日志的备份来看,无论如何指定需要备份的数据库归档,最终结果都是所有的归档日志均做备份,同时将指定的数据库也做了备份。