at 12-MAY-15
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=18 RECID=4 STAMP=879548173
channel ORA_DISK_1: starting piece 1 at 12-MAY-15
channel ORA_DISK_1: finished piece 1 at 12-MAY-15
piece handle=+FLASH/bys9/backupset/2015_05_12/annnf0_tag20150512t225614_0.261.879548175 tag=TAG20150512T225614 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+FLASH/bys9/archivelog/2015_05_12/thread_1_seq_18.262.879548173 RECID=4 STAMP=879548173
Finished backup at 12-MAY-15
Starting Control File and SPFILE Autobackup at 12-MAY-15
piece handle=+FLASH/bys9/autobackup/2015_05_12/s_879548179.262.879548187 comment=NONE
Finished Control File and SPFILE Autobackup at 12-MAY-15
RMAN> list backup of controlfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 9.36M DISK 00:00:09 12-MAY-15
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20150512T225618
Piece Name: +FLASH/bys9/autobackup/2015_05_12/s_879548179.262.879548187
Control File Included: Ckp SCN: 259666 Ckp time: 12-MAY-15
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1 11.22M DISK 00:00:03 12-MAY-15
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20150512T225434
Piece Name: +FLASH/bys9/backupset/2015_05_12/annnf0_tag20150512t225434_0.263.879548075
List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 15 214735 11-APR-15 239087 21-APR-15
1 16 239087 21-APR-15 259310 12-MAY-15
1 17 259310 12-MAY-15 259604 12-MAY-15
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3 4.00K DISK 00:00:02 12-MAY-15
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20150512T225614
Piece Name: +FLASH/bys9/backupset/2015_05_12/annnf0_tag20150512t225614_0.261.879548175
List of Archived Logs in backup set 3
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 18 259604 12-MAY-15 259652 12-MAY-15
RMAN> list backup of database;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 434.60M DISK 00:01:20 12-MAY-15
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20150512T225442
Piece Name: /home/oracle/full_BYS9_20150512_2
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 259619 12-MAY-15 +DATA01/bys9/datafile/system.260.876770855
2 Full 259619 12-MAY-15 +DATA01/bys9/datafile/sysaux.261.876770927
3 Full 259619 12-MAY-15 +DATA01/bys9/datafile/undotbs1.262.876770987
4 Full 259619 12-MAY-15 +DATA01/bys9/datafile/users.264.876771015
##########
######################
实验二：创建不同块大小的表空间，测试不同块大小的表空间，也不能备份到同一个备份PIECE中。 SQL> select file#,name,bl |