/*
|| Oracle Secured Backup Listing 2
||
|| Demonstrates Oracle Secured Backup (OSB) features, including:
|| - How to back up an Oracle 10gR2 Flash Recovery Area using RMAN and OSB
||
|| Author: Jim Czuprynski
||
|| Usage Notes:
|| This script is provided to demonstrate various features of Oracle Secure
|| Backup, and it should be carefully proofread before executing it against 
|| any existing Oracle database to avoid any potential damage!
*/

/* 
|| Listing 2.1: Creating a complete backup of the database using RMAN, with
||              the Flash Recovery Area as the target destination
*/

[oracle@10gBUR ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Apr 10 20:04:51 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1143891885)

RMAN> backup as copy database plus archivelog delete input;

Starting backup at 10-APR-07
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=144 devtype=DISK
channel ORA_DISK_1: starting archive copy
input archive log thread=1 sequence=8 recid=4 stamp=619305854
output filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_8_31rf2jjb_.arc recid=11 stamp=619560323
channel ORA_DISK_1: archivelog copy complete, elapsed time: 00:00:08
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_07/o1_mf_1_8_31jnld7w_.arc recid=4 stamp=619305854
channel ORA_DISK_1: starting archive copy
input archive log thread=1 sequence=5 recid=1 stamp=619266966
output filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_5_31rf2rvm_.arc recid=12 stamp=619560329
channel ORA_DISK_1: archivelog copy complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_07/o1_mf_1_5_31hgm5xm_.arc recid=1 stamp=619266966
channel ORA_DISK_1: starting archive copy
input archive log thread=1 sequence=6 recid=2 stamp=619281090
output filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_6_31rf2v67_.arc recid=13 stamp=619560331
channel ORA_DISK_1: archivelog copy complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_07/o1_mf_1_6_31hwdkqj_.arc recid=2 stamp=619281090
channel ORA_DISK_1: starting archive copy
input archive log thread=1 sequence=14 recid=10 stamp=619560316
output filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_14_31rf2xfx_.arc recid=14 stamp=619560333
channel ORA_DISK_1: archivelog copy complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_14_31rf2d12_.arc recid=10 stamp=619560316
channel ORA_DISK_1: starting archive copy
input archive log thread=1 sequence=12 recid=8 stamp=619311238
output filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_12_31rf2zsy_.arc recid=15 stamp=619560336
channel ORA_DISK_1: archivelog copy complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_07/o1_mf_1_12_31jstowg_.arc recid=8 stamp=619311238
channel ORA_DISK_1: starting archive copy
input archive log thread=1 sequence=13 recid=9 stamp=619559553
output filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_13_31rf322d_.arc recid=16 stamp=619560338
channel ORA_DISK_1: archivelog copy complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_13_31rdbjv2_.arc recid=9 stamp=619559553
channel ORA_DISK_1: starting archive copy
input archive log thread=1 sequence=7 recid=3 stamp=619281125
output filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_7_31rf34g0_.arc recid=17 stamp=619560340
channel ORA_DISK_1: archivelog copy complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_07/o1_mf_1_7_31hwforg_.arc recid=3 stamp=619281125
channel ORA_DISK_1: starting archive copy
input archive log thread=1 sequence=11 recid=7 stamp=619306488
output filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_11_31rf36pw_.arc recid=18 stamp=619560342
channel ORA_DISK_1: archivelog copy complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_07/o1_mf_1_11_31jo68h2_.arc recid=7 stamp=619306488
channel ORA_DISK_1: starting archive copy
input archive log thread=1 sequence=9 recid=5 stamp=619305878
output filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_9_31rf38yf_.arc recid=19 stamp=619560344
channel ORA_DISK_1: archivelog copy complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_07/o1_mf_1_9_31jnm6ct_.arc recid=5 stamp=619305878
channel ORA_DISK_1: starting archive copy
input archive log thread=1 sequence=10 recid=6 stamp=619305894
output filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_10_31rf3c7m_.arc recid=20 stamp=619560347
channel ORA_DISK_1: archivelog copy complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_07/o1_mf_1_10_31jnmph5_.arc recid=6 stamp=619305894
Finished backup at 10-APR-07

Starting backup at 10-APR-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
output filename=/u01/app/oracle/flash_recovery_area/ORCL/datafile/o1_mf_system_31rf3f93_.dbf tag=TAG20070410T200548 recid=2 stamp=619560426
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:22
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
output filename=/u01/app/oracle/flash_recovery_area/ORCL/datafile/o1_mf_sysaux_31rf6272_.dbf tag=TAG20070410T200548 recid=3 stamp=619560447
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile fno=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
output filename=/u01/app/oracle/flash_recovery_area/ORCL/datafile/o1_mf_example_31rf6sjk_.dbf tag=TAG20070410T200548 recid=4 stamp=619560462
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
output filename=/u01/app/oracle/flash_recovery_area/ORCL/datafile/o1_mf_undotbs1_31rf717z_.dbf tag=TAG20070410T200548 recid=5 stamp=619560466
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
output filename=/u01/app/oracle/flash_recovery_area/ORCL/datafile/o1_mf_users_31rf7401_.dbf tag=TAG20070410T200548 recid=6 stamp=619560468
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
copying current control file
output filename=/u01/app/oracle/flash_recovery_area/ORCL/controlfile/o1_mf_TAG20070410T200548_31rf756p_.ctl tag=TAG20070410T200548 recid=7 stamp=619560469
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 10-APR-07
channel ORA_DISK_1: finished piece 1 at 10-APR-07
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2007_04_10/o1_mf_nnsnf_TAG20070410T200548_31rf77h1_.bkp tag=TAG20070410T200548 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 10-APR-07

Starting backup at 10-APR-07
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive copy
input archive log thread=1 sequence=15 recid=21 stamp=619560474
output filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_15_31rf7ckv_.arc recid=22 stamp=619560475
channel ORA_DISK_1: archivelog copy complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_15_31rf7b9s_.arc recid=21 stamp=619560474
Finished backup at 10-APR-07

/* 
|| Listing 2.2: Backing up the contents of the Flash Recovery Area to an OSB
||              tape device
*/

RMAN> backup recovery area;

Starting backup at 10-APR-07
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=134 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
released channel: ORA_DISK_1
skipping archive log file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_5_31rf2rvm_.arc; already backed up 1 time(s)
skipping archive log file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_6_31rf2v67_.arc; already backed up 1 time(s)
skipping archive log file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_7_31rf34g0_.arc; already backed up 1 time(s)
skipping archive log file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_8_31rf2jjb_.arc; already backed up 1 time(s)
skipping archive log file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_9_31rf38yf_.arc; already backed up 1 time(s)
skipping archive log file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_10_31rf3c7m_.arc; already backed up 1 time(s)
skipping archive log file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_11_31rf36pw_.arc; already backed up 1 time(s)
skipping archive log file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_12_31rf2zsy_.arc; already backed up 1 time(s)
channel ORA_SBT_TAPE_1: starting full datafile backupset
channel ORA_SBT_TAPE_1: including datafile copy of datafile 00001 in backupset
input filename=/u01/app/oracle/flash_recovery_area/ORCL/datafile/o1_mf_system_31rf3f93_.dbf
channel ORA_SBT_TAPE_1: including datafile copy of datafile 00003 in backupset
input filename=/u01/app/oracle/flash_recovery_area/ORCL/datafile/o1_mf_sysaux_31rf6272_.dbf
channel ORA_SBT_TAPE_1: including datafile copy of datafile 00005 in backupset
input filename=/u01/app/oracle/flash_recovery_area/ORCL/datafile/o1_mf_example_31rf6sjk_.dbf
channel ORA_SBT_TAPE_1: including datafile copy of datafile 00002 in backupset
input filename=/u01/app/oracle/flash_recovery_area/ORCL/datafile/o1_mf_undotbs1_31rf717z_.dbf
channel ORA_SBT_TAPE_1: including datafile copy of datafile 00004 in backupset
input filename=/u01/app/oracle/flash_recovery_area/ORCL/datafile/o1_mf_users_31rf7401_.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 10-APR-07
channel ORA_SBT_TAPE_1: finished piece 1 at 10-APR-07
piece handle=0qierfn5_1_1 tag=TAG20070410T201116 comment=API Version 2.0,MMS Version 10.1.0.3
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:02:46
channel ORA_SBT_TAPE_1: starting archive log backupset
channel ORA_SBT_TAPE_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=13 recid=16 stamp=619560338
input archive log thread=1 sequence=14 recid=14 stamp=619560333
input archive log thread=1 sequence=15 recid=22 stamp=619560475
channel ORA_SBT_TAPE_1: starting piece 1 at 10-APR-07
channel ORA_SBT_TAPE_1: finished piece 1 at 10-APR-07
piece handle=0rierfsc_1_1 tag=TAG20070410T201116 comment=API Version 2.0,MMS Version 10.1.0.3
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:16
input backupset count=24 stamp=619560470 creation_time=10-APR-07
channel ORA_SBT_TAPE_1: starting piece 1 at 10-APR-07
channel ORA_SBT_TAPE_1: backup piece /u01/app/oracle/flash_recovery_area/ORCL/backupset/2007_04_10/o1_mf_nnsnf_TAG20070410T200548_31rf77h1_.bkp
piece handle=0oierfgm_1_2 comment=API Version 2.0,MMS Version 10.1.0.3
channel ORA_SBT_TAPE_1: finished piece 1 at 10-APR-07
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:15
Finished backup at 10-APR-07

/* 
|| Listing 2.3: Listing the resulting RMAN backup sets and image copies
*/

[oracle@10gBUR ~]$ export NLS_DATE_FORMAT='mm-dd-yyyy hh24:mi:ss'
[oracle@10gBUR ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Apr 10 20:52:23 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1143891885)

RMAN> list copy;


List of Datafile Copies
Key     File S Completion Time     Ckp SCN    Ckp Time            Name
------- ---- - ------------------- ---------- ------------------- ----
2       1    A 04-10-2007 20:07:06 612120     04-10-2007 20:05:49 /u01/app/oracle/flash_recovery_area/ORCL/datafile/o1_mf_system_31rf3f93_.dbf
5       2    A 04-10-2007 20:07:46 612160     04-10-2007 20:07:44 /u01/app/oracle/flash_recovery_area/ORCL/datafile/o1_mf_undotbs1_31rf717z_.dbf
3       3    A 04-10-2007 20:07:27 612143     04-10-2007 20:07:12 /u01/app/oracle/flash_recovery_area/ORCL/datafile/o1_mf_sysaux_31rf6272_.dbf
6       4    A 04-10-2007 20:07:48 612162     04-10-2007 20:07:47 /u01/app/oracle/flash_recovery_area/ORCL/datafile/o1_mf_users_31rf7401_.dbf
4       5    A 04-10-2007 20:07:42 612157     04-10-2007 20:07:37 /u01/app/oracle/flash_recovery_area/ORCL/datafile/o1_mf_example_31rf6sjk_.dbf

List of Control File Copies
Key     S Completion Time     Ckp SCN    Ckp Time            Name
------- - ------------------- ---------- ------------------- ----
7       A 04-10-2007 20:07:49 612163     04-10-2007 20:07:48 /u01/app/oracle/flash_recovery_area/ORCL/controlfile/o1_mf_TAG20070410T200548_31rf756p_.ctl

List of Archived Log Copies
Key     Thrd Seq     S Low Time            Name
------- ---- ------- - ------------------- ----
12      1    5       A 03-04-2007 05:59:53 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_5_31rf2rvm_.arc
13      1    6       A 04-07-2007 10:36:05 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_6_31rf2v67_.arc
17      1    7       A 04-07-2007 14:31:29 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_7_31rf34g0_.arc
11      1    8       A 04-07-2007 14:32:05 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_8_31rf2jjb_.arc
19      1    9       A 04-07-2007 21:24:12 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_9_31rf38yf_.arc
20      1    10      A 04-07-2007 21:24:38 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_10_31rf3c7m_.arc
18      1    11      A 04-07-2007 21:24:54 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_11_31rf36pw_.arc
15      1    12      A 04-07-2007 21:34:48 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_12_31rf2zsy_.arc
16      1    13      A 04-07-2007 22:53:57 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_13_31rf322d_.arc
14      1    14      A 04-10-2007 19:52:32 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_14_31rf2xfx_.arc
22      1    15      A 04-10-2007 20:05:15 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_10/o1_mf_1_15_31rf7ckv_.arc

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2       Full    608.25M    SBT_TAPE    00:02:33     04-07-2007 22:53:37
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: FC_OSB_100_040707104945
        Handle: 05iejruo_1_1   Media:
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 586317     04-07-2007 22:51:04 /u01/app/oracle/oradata/orcl/system01.dbf
  2       Full 586317     04-07-2007 22:51:04 /u01/app/oracle/oradata/orcl/undotbs01.dbf
  3       Full 586317     04-07-2007 22:51:04 /u01/app/oracle/oradata/orcl/sysaux01.dbf
  4       Full 586317     04-07-2007 22:51:04 /u01/app/oracle/oradata/orcl/users01.dbf
  5       Full 586317     04-07-2007 22:51:04 /u01/app/oracle/oradata/orcl/example01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
3       Full    7.00M      SBT_TAPE    00:00:14     04-07-2007 22:53:53
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: FC_OSB_100_040707104945
        Handle: 06iejs3j_1_1   Media:
  Control File Included: Ckp SCN: 586386       Ckp time: 04-07-2007 22:53:39
  SPFILE Included: Modification time: 04-07-2007 13:49:41

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
4       74.50M     SBT_TAPE    00:00:18     04-07-2007 22:54:16
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: FC_OSB_100_040707104945
        Handle: 07iejs46_1_1   Media:

  List of Archived Logs in backup set 4
  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  ---- ------- ---------- ------------------- ---------- ---------
  1    5       538748     03-04-2007 05:59:53 563621     04-07-2007 10:36:05
  1    6       563621     04-07-2007 10:36:05 566432     04-07-2007 14:31:29
  1    7       566432     04-07-2007 14:31:29 567145     04-07-2007 14:32:05
  1    8       567145     04-07-2007 14:32:05 581574     04-07-2007 21:24:12
  1    9       581574     04-07-2007 21:24:12 581611     04-07-2007 21:24:38
  1    10      581611     04-07-2007 21:24:38 581644     04-07-2007 21:24:54
  1    11      581644     04-07-2007 21:24:54 582127     04-07-2007 21:34:48
  1    12      582127     04-07-2007 21:34:48 586439     04-07-2007 22:53:57

BS Key  Type LV Size
------- ---- -- ----------
5       Full    80.00K
  SPFILE Included: Modification time: 04-10-2007 19:53:01

  Backup Set Copy #1 of backup set 5
  Device Type Elapsed Time Completion Time     Compressed Tag
  ----------- ------------ ------------------- ---------- ---
  DISK        00:00:01     04-10-2007 20:07:51 NO         TAG20070410T200548

    List of Backup Pieces for backup set 5 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    5       1   AVAILABLE   /u01/app/oracle/flash_recovery_area/ORCL/backupset/2007_04_10/o1_mf_nnsnf_TAG20070410T200548_31rf77h1_.bkp

  Backup Set Copy #2 of backup set 5
  Device Type Elapsed Time Completion Time     Compressed Tag
  ----------- ------------ ------------------- ---------- ---
  SBT_TAPE    00:00:01     04-10-2007 20:14:36 NO         TAG20070410T200548

    List of Backup Pieces for backup set 5 Copy #2
    BP Key  Pc# Status      Media                   Piece Name
    ------- --- ----------- ----------------------- ----------
    8       1   AVAILABLE                           0oierfgm_1_2

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
6       Full    610.50M    SBT_TAPE    00:02:41     04-10-2007 20:13:58
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20070410T201116
        Handle: 0qierfn5_1_1   Media:
  List of Datafiles in backup set 6
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 612120     04-10-2007 20:05:49 /u01/app/oracle/oradata/orcl/system01.dbf
  2       Full 612160     04-10-2007 20:07:44 /u01/app/oracle/oradata/orcl/undotbs01.dbf
  3       Full 612143     04-10-2007 20:07:12 /u01/app/oracle/oradata/orcl/sysaux01.dbf
  4       Full 612162     04-10-2007 20:07:47 /u01/app/oracle/oradata/orcl/users01.dbf
  5       Full 612157     04-10-2007 20:07:37 /u01/app/oracle/oradata/orcl/example01.dbf

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
7       14.00M     SBT_TAPE    00:00:15     04-10-2007 20:14:19
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20070410T201116
        Handle: 0rierfsc_1_1   Media:

  List of Archived Logs in backup set 7
  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  ---- ------- ---------- ------------------- ---------- ---------
  1    13      586439     04-07-2007 22:53:57 609627     04-10-2007 19:52:32
  1    14      609627     04-10-2007 19:52:32 612100     04-10-2007 20:05:15
  1    15      612100     04-10-2007 20:05:15 612168     04-10-2007 20:07:54