List of Backup Sets

BS Key Type LV Size Device Type Elapsed Time Completion Time

1 Full 230.02M DISK 00:01:19 03-DEC-10
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20101203T163403
Piece Name: /home/oracle/backup_puro01lul3rr
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name

1 Full 162805 03-DEC-10 +SISTEMA/defesa/datafile/system_01.dbf
2 Full 162805 03-DEC-10 +SISTEMA/defesa/datafile/undo_01.dbf
3 Full 162805 03-DEC-10 +SISTEMA/defesa/datafile/sysaux_01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

2 Full 7.89M DISK 00:00:20 03-DEC-10
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20101203T163530
Piece Name: +FLASH_R_A/defesa/autobackup/2010_12_03/s_736791998.256.736792547
Control File Included: Ckp SCN: 162805 Ckp time: 03-DEC-10
SPFILE Included: Modification time: 03-DEC-10

BS Key Type LV Size Device Type Elapsed Time Completion Time

3 Full 230.21M DISK 00:00:51 03-DEC-10
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20101203T175516
Piece Name: /home/oracle/backup_alterado03lul8k5
List of Datafiles in backup set 3
File LV Type Ckp SCN Ckp Time Name

1 Full 165567 03-DEC-10 +SISTEMA/defesa/datafile/system_01.dbf
2 Full 165567 03-DEC-10 +SISTEMA/defesa/datafile/undo_01.dbf
3 Full 165567 03-DEC-10 +SISTEMA/defesa/datafile/sysaux_01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

4 Full 7.89M DISK 00:00:05 03-DEC-10
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20101203T175613
Piece Name: +FLASH_R_A/defesa/autobackup/2010_12_03/s_736796720.257.736797377
Control File Included: Ckp SCN: 165567 Ckp time: 03-DEC-10
SPFILE Included: Modification time: 03-DEC-10

RMAN> validate backupset 1,2,3,4
2> ;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=153 devtype=DISK
channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_1: reading from backup piece /home/oracle/backup_puro01lul3rr
channel ORA_DISK_1: restored backup piece 1
piece handle=/home/oracle/backup_puro01lul3rr tag=TAG20101203T163403
channel ORA_DISK_1: validation complete, elapsed time: 00:00:17
channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_1: reading from backup piece +FLASH_R_A/defesa/autobackup/2010_12_03/s_736791998.256.736792547
channel ORA_DISK_1: restored backup piece 1
piece handle=+FLASH_R_A/defesa/autobackup/2010_12_03/s_736791998.256.736792547 tag=TAG20101203T163530
channel ORA_DISK_1: validation complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_1: reading from backup piece /home/oracle/backup_alterado03lul8k5
channel ORA_DISK_1: restored backup piece 1
piece handle=/home/oracle/backup_alterado03lul8k5 tag=TAG20101203T175516
channel ORA_DISK_1: validation complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_1: reading from backup piece +FLASH_R_A/defesa/autobackup/2010_12_03/s_736796720.257.736797377
channel ORA_DISK_1: restored backup piece 1
piece handle=+FLASH_R_A/defesa/autobackup/2010_12_03/s_736796720.257.736797377 tag=TAG20101203T175613
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03

RMAN>

ASMCMD> ls -ltr
Type Redund Striped Time Sys Name
AUTOBACKUP MIRROR COARSE DEC 09 02:00:00 Y s_736791998.256.736792547
AUTOBACKUP MIRROR COARSE DEC 09 02:00:00 Y s_736796720.257.736797377
ASMCMD> pwd
+flash_r_a/defesa/autobackup/2010_12_03
ASMCMD>