Rename backupset to simulate bad/missing.

$ mv /oradata/backup/SAN_2792912513_20140731_bgpeq4do_1_1 /oradata/backup/SAN_2792912513_20140731_bgpeq4do_1_1.bad

Run restore database validate preview summary.

$ rman @val.rman

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Jul 31 21:23:18 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN> set echo on

2> connect target;

3> show all;

4> list backup summary;

5> run {

6> allocate channel d1 type disk;

7> SET UNTIL TIME "TRUNC(sysdate)+18/24";

8> restore controlfile validate;

9> restore database validate preview summary;

10> report schema;

11> }

12> exit

echo set on

connected to target database: SAN (DBID=2792912513)

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name SAN are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF;

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oradata/backup/%d_%F.ctl';

CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/oradata/backup/%d_%I_%T_%U' MAXOPENFILES 1;

CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/oradata/backup1/%d_%I_%T_%U' MAXOPENFILES 1;

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_san.f'; # default

List of Backups

===============

Key     TY LV S Device Type Completion Time      #Pieces #Copies Compressed Tag

------- -- -- - ----------- -------------------- ------- ------- ---------- ---

268     B  A  A DISK        2014-JUL-31 11:47:48 1       1       YES        ARCHIVELOG

271     B  A  A DISK        2014-JUL-31 17:01:16 1       1       YES        ARCHIVELOG

272     B  0  A DISK        2014-JUL-31 17:02:05 1       1       YES        LEVEL0

273     B  0  A DISK        2014-JUL-31 17:02:50 1       1       YES        LEVEL0

274     B  0  A DISK        2014-JUL-31 17:03:44 1       1       YES        LEVEL0

275     B  0  A DISK        2014-JUL-31 17:03:47 1       1       YES        LEVEL0

276     B  0  A DISK        2014-JUL-31 17:03:57 1       1       YES        LEVEL0

277     B  0  A DISK        2014-JUL-31 17:04:39 1       1       YES        LEVEL0

278     B  A  A DISK        2014-JUL-31 17:04:44 1       1       YES        ARCHIVELOG

279     B  F  A DISK        2014-JUL-31 17:04:49 1       1       NO         TAG20140731T170446

280     B  A  A DISK        2014-JUL-31 17:52:59 1       1       YES        ARCHIVELOG

281     B  A  A DISK        2014-JUL-31 17:53:00 1       1       YES        ARCHIVELOG

282     B  A  A DISK        2014-JUL-31 17:53:01 1       1       YES        ARCHIVELOG

283     B  F  A DISK        2014-JUL-31 17:53:05 1       1       NO         TAG20140731T175302

284     B  A  A DISK        2014-JUL-31 20:36:08 1       1       YES        ARCHIVELOG

285     B  A  A DISK        2014-JUL-31 20:36:09 1       1       YES        ARCHIVELOG

286     B  A  A DISK        2014-JUL-31 20:36:10 1       1       YES        ARCHIVELOG

287     B  F  A DISK        2014-JUL-31 20:36:14 1       1       NO         TAG20140731T203611

allocated channel: d1

channel d1: SID=102 device type=DISK

executing command: SET until clause

Starting restore at 2014-JUL-31 21:23:20

channel d1: starting validation of datafile backup set

channel d1: reading from backup piece /oradata/backup/SAN_c-2792912513-20140731-03.ctl

channel d1: piece handle=/oradata/backup/SAN_c-2792912513-20140731-03.ctl tag=TAG20140731T175302

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:00:01

Finished restore at 2014-JUL-31 21:23:21

Starting restore at 2014-JUL-31 21:23:22

List of Backups

===============

Key     TY LV S Device Type Completion Time      #Pieces #Copies Compressed Tag

------- -- -- - ----------- -------------------- ------- ------- ---------- ---

273     B  0  A DISK        2014-JUL-31 17:02:46 1       1       YES        LEVEL0

274     B  0  A DISK        2014-JUL-31 17:03:41 1       1       YES        LEVEL0

272     B  0  A DISK        2014-JUL-31 17:02:05 1       1       YES        LEVEL0

275     B  0  A DISK        2014-JUL-31 17:03:47 1       1       YES        LEVEL0

276     B  0  A DISK        2014-JUL-31 17:03:57 1       1       YES        LEVEL0

277     B  0  A DISK        2014-JUL-31 17:04:37 1       1       YES        LEVEL0

List of Backups

===============

Key     TY LV S Device Type Completion Time      #Pieces #Copies Compressed Tag

------- -- -- - ----------- -------------------- ------- ------- ---------- ---

280     B  A  A DISK        2014-JUL-31 17:52:59 1       1       YES        ARCHIVELOG

Notice archived logs from disk versus backup are used.

List of Archived Log Copies for database with db_unique_name SAN

=====================================================================

Key     Thrd Seq     S Low Time

------- ---- ------- - --------------------

389     1    378     A 2014-JUL-31 17:04:42

        Name: /oradata/SAN/archivelog/arc_845895297_1_378.dbf

390     1    379     A 2014-JUL-31 17:05:43

        Name: /oradata/SAN/archivelog/arc_845895297_1_379.dbf

391     1    380     A 2014-JUL-31 17:05:46

        Name: /oradata/SAN/archivelog/arc_845895297_1_380.dbf

392     1    381     A 2014-JUL-31 17:05:50

        Name: /oradata/SAN/archivelog/arc_845895297_1_381.dbf

393     1    382     A 2014-JUL-31 17:05:51

        Name: /oradata/SAN/archivelog/arc_845895297_1_382.dbf

394     1    383     A 2014-JUL-31 17:05:55

        Name: /oradata/SAN/archivelog/arc_845895297_1_383.dbf

395     1    384     A 2014-JUL-31 17:51:52

        Name: /oradata/SAN/archivelog/arc_845895297_1_384.dbf

396     1    385     A 2014-JUL-31 17:51:54

        Name: /oradata/SAN/archivelog/arc_845895297_1_385.dbf

397     1    386     A 2014-JUL-31 17:52:56

        Name: /oradata/SAN/archivelog/arc_845895297_1_386.dbf

Media recovery start SCN is 1996728

Recovery must be done beyond SCN 1996786 to clear datafile fuzziness

channel d1: starting validation of datafile backup set

channel d1: reading from backup piece /oradata/backup1/SAN_2792912513_20140731_b3pepnqv_1_1

channel d1: piece handle=/oradata/backup1/SAN_2792912513_20140731_b3pepnqv_1_1 tag=LEVEL0

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:00:01

channel d1: starting validation of datafile backup set

channel d1: reading from backup piece /oradata/backup1/SAN_2792912513_20140731_b5pepnsn_1_1

channel d1: piece handle=/oradata/backup1/SAN_2792912513_20140731_b5pepnsn_1_1 tag=LEVEL0

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:00:07

channel d1: starting validation of datafile backup set

channel d1: reading from backup piece /oradata/backup1/SAN_2792912513_20140731_b6pepnu5_1_1

channel d1: piece handle=/oradata/backup1/SAN_2792912513_20140731_b6pepnu5_1_1 tag=LEVEL0

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:00:07

channel d1: starting validation of datafile backup set

channel d1: reading from backup piece /oradata/backup1/SAN_2792912513_20140731_b7pepnvi_1_1

channel d1: piece handle=/oradata/backup1/SAN_2792912513_20140731_b7pepnvi_1_1 tag=LEVEL0

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:00:01

channel d1: starting validation of datafile backup set

channel d1: reading from backup piece /oradata/backup1/SAN_2792912513_20140731_b8pepnvs_1_1

channel d1: piece handle=/oradata/backup1/SAN_2792912513_20140731_b8pepnvs_1_1 tag=LEVEL0

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:00:01

channel d1: starting validation of datafile backup set

channel d1: reading from backup piece /oradata/backup/SAN_2792912513_20140731_b4pepnr0_1_1

channel d1: piece handle=/oradata/backup/SAN_2792912513_20140731_b4pepnr0_1_1 tag=LEVEL0

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:01:05

channel d1: scanning archived log /oradata/SAN/archivelog/arc_845895297_1_378.dbf

channel d1: scanning archived log /oradata/SAN/archivelog/arc_845895297_1_379.dbf

channel d1: scanning archived log /oradata/SAN/archivelog/arc_845895297_1_380.dbf

channel d1: scanning archived log /oradata/SAN/archivelog/arc_845895297_1_381.dbf

channel d1: scanning archived log /oradata/SAN/archivelog/arc_845895297_1_382.dbf

channel d1: scanning archived log /oradata/SAN/archivelog/arc_845895297_1_383.dbf

channel d1: scanning archived log /oradata/SAN/archivelog/arc_845895297_1_384.dbf

channel d1: scanning archived log /oradata/SAN/archivelog/arc_845895297_1_385.dbf

channel d1: scanning archived log /oradata/SAN/archivelog/arc_845895297_1_386.dbf

channel d1: starting validation of archived log backup set

channel d1: reading from backup piece /oradata/backup/SAN_2792912513_20140731_bcpepqrr_1_1

channel d1: piece handle=/oradata/backup/SAN_2792912513_20140731_bcpepqrr_1_1 tag=ARCHIVELOG

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:00:01

Finished restore at 2014-JUL-31 21:24:55

Report of database schema for database with db_unique_name SAN

List of Permanent Datafiles

===========================

File Size(MB) Tablespace           RB segs Datafile Name

---- -------- -------------------- ------- ------------------------

1    512      SYSTEM               ***     /oradata/SAN/datafile/o1_mf_system_9oqwr5tm_.dbf

2    512      SYSAUX               ***     /oradata/SAN/datafile/o1_mf_sysaux_9oqwrv2b_.dbf

3    2816     UNDOTBS1             ***     /oradata/SAN/datafile/o1_mf_undotbs1_9oqwsjk6_.dbf

5    256      GGS_DATA             ***     /oradata/SAN/datafile/o1_mf_ggs_data_9or2h3tw_.dbf

6    16       TESTING              ***     /oradata/SAN/datafile/o1_mf_testing_9rgp1q31_.dbf

8    1930     USER_DATA            ***     /oradata/SAN/datafile/o1_mf_user_dat_9wvp8s78_.dbf

List of Temporary Files

=======================

File Size(MB) Tablespace           Maxsize(MB) Tempfile Name

---- -------- -------------------- ----------- --------------------

1    1024     TEMP                 8193        /oradata/SAN/datafile/o1_mf_temp_9oqwt7z5_.tmp

2    8        TEMP                 8           /oradata/SAN/datafile/o1_mf_temp_9rwp74xb_.tmp

released channel: d1

Recovery Manager complete.

Validate did not fail !!!

Determine if there exists a backup for archivelog sequence 386

$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Jul 31 21:25:18 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SAN (DBID=2792912513)

RMAN> list backup of archivelog sequence 386;

using target database control file instead of recovery catalog

List of Backup Sets

===================

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ --------------------

285     1.90M      DISK        00:00:01     2014-JUL-31 20:36:09

        BP Key: 285   Status: AVAILABLE  Compressed: YES  Tag: ARCHIVELOG

        Piece Name: /oradata/backup/SAN_2792912513_20140731_bgpeq4do_1_1

  List of Archived Logs in backup set 285

  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time

  ---- ------- ---------- -------------------- ---------- ---------

  1    386     1997997    2014-JUL-31 17:52:56 2002259    2014-JUL-31 20:35:49

Delete all achivelog already backed up.

RMAN> delete noprompt archivelog all backed up 1 times to disk;

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=103 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=19 device type=DISK

List of Archived Log Copies for database with db_unique_name SAN

=====================================================================

Key     Thrd Seq     S Low Time

------- ---- ------- - --------------------

389     1    378     A 2014-JUL-31 17:04:42

        Name: /oradata/SAN/archivelog/arc_845895297_1_378.dbf

390     1    379     A 2014-JUL-31 17:05:43

        Name: /oradata/SAN/archivelog/arc_845895297_1_379.dbf

391     1    380     A 2014-JUL-31 17:05:46

        Name: /oradata/SAN/archivelog/arc_845895297_1_380.dbf

392     1    381     A 2014-JUL-31 17:05:50

        Name: /oradata/SAN/archivelog/arc_845895297_1_381.dbf

393     1    382     A 2014-JUL-31 17:05:51

        Name: /oradata/SAN/archivelog/arc_845895297_1_382.dbf

394     1    383     A 2014-JUL-31 17:05:55

        Name: /oradata/SAN/archivelog/arc_845895297_1_383.dbf

395     1    384     A 2014-JUL-31 17:51:52

        Name: /oradata/SAN/archivelog/arc_845895297_1_384.dbf

396     1    385     A 2014-JUL-31 17:51:54

        Name: /oradata/SAN/archivelog/arc_845895297_1_385.dbf

397     1    386     A 2014-JUL-31 17:52:56

        Name: /oradata/SAN/archivelog/arc_845895297_1_386.dbf

398     1    387     A 2014-JUL-31 20:35:49

        Name: /oradata/SAN/archivelog/arc_845895297_1_387.dbf

deleted archived log

archived log file name=/oradata/SAN/archivelog/arc_845895297_1_378.dbf RECID=389 STAMP=854384744

deleted archived log

archived log file name=/oradata/SAN/archivelog/arc_845895297_1_379.dbf RECID=390 STAMP=854384747

deleted archived log

archived log file name=/oradata/SAN/archivelog/arc_845895297_1_380.dbf RECID=391 STAMP=854384750

deleted archived log

archived log file name=/oradata/SAN/archivelog/arc_845895297_1_381.dbf RECID=392 STAMP=854384752

deleted archived log

archived log file name=/oradata/SAN/archivelog/arc_845895297_1_382.dbf RECID=393 STAMP=854384756

deleted archived log

archived log file name=/oradata/SAN/archivelog/arc_845895297_1_383.dbf RECID=394 STAMP=854387512

deleted archived log

archived log file name=/oradata/SAN/archivelog/arc_845895297_1_384.dbf RECID=395 STAMP=854387515

deleted archived log

archived log file name=/oradata/SAN/archivelog/arc_845895297_1_385.dbf RECID=396 STAMP=854387578

deleted archived log

archived log file name=/oradata/SAN/archivelog/arc_845895297_1_386.dbf RECID=397 STAMP=854397350

deleted archived log

archived log file name=/oradata/SAN/archivelog/arc_845895297_1_387.dbf RECID=398 STAMP=854397366

Deleted 10 objects

RMAN> exit

Run restore database validate preview summary.

$ rman @val.rman

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Jul 31 21:26:55 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN> set echo on

2> connect target;

3> show all;

4> list backup summary;

5> run {

6> allocate channel d1 type disk;

7> SET UNTIL TIME "TRUNC(sysdate)+18/24";

8> restore controlfile validate;

9> restore database validate preview summary;

10> report schema;

11> }

12> exit

echo set on

connected to target database: SAN (DBID=2792912513)

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name SAN are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF;

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oradata/backup/%d_%F.ctl';

CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/oradata/backup/%d_%I_%T_%U' MAXOPENFILES 1;

CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/oradata/backup1/%d_%I_%T_%U' MAXOPENFILES 1;

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_san.f'; # default

List of Backups

===============

Key     TY LV S Device Type Completion Time      #Pieces #Copies Compressed Tag

------- -- -- - ----------- -------------------- ------- ------- ---------- ---

268     B  A  A DISK        2014-JUL-31 11:47:48 1       1       YES        ARCHIVELOG

271     B  A  A DISK        2014-JUL-31 17:01:16 1       1       YES        ARCHIVELOG

272     B  0  A DISK        2014-JUL-31 17:02:05 1       1       YES        LEVEL0

273     B  0  A DISK        2014-JUL-31 17:02:50 1       1       YES        LEVEL0

274     B  0  A DISK        2014-JUL-31 17:03:44 1       1       YES        LEVEL0

275     B  0  A DISK        2014-JUL-31 17:03:47 1       1       YES        LEVEL0

276     B  0  A DISK        2014-JUL-31 17:03:57 1       1       YES        LEVEL0

277     B  0  A DISK        2014-JUL-31 17:04:39 1       1       YES        LEVEL0

278     B  A  A DISK        2014-JUL-31 17:04:44 1       1       YES        ARCHIVELOG

279     B  F  A DISK        2014-JUL-31 17:04:49 1       1       NO         TAG20140731T170446

280     B  A  A DISK        2014-JUL-31 17:52:59 1       1       YES        ARCHIVELOG

281     B  A  A DISK        2014-JUL-31 17:53:00 1       1       YES        ARCHIVELOG

282     B  A  A DISK        2014-JUL-31 17:53:01 1       1       YES        ARCHIVELOG

283     B  F  A DISK        2014-JUL-31 17:53:05 1       1       NO         TAG20140731T175302

284     B  A  A DISK        2014-JUL-31 20:36:08 1       1       YES        ARCHIVELOG

285     B  A  A DISK        2014-JUL-31 20:36:09 1       1       YES        ARCHIVELOG

286     B  A  A DISK        2014-JUL-31 20:36:10 1       1       YES        ARCHIVELOG

287     B  F  A DISK        2014-JUL-31 20:36:14 1       1       NO         TAG20140731T203611

allocated channel: d1

channel d1: SID=102 device type=DISK

executing command: SET until clause

Starting restore at 2014-JUL-31 21:26:58

channel d1: starting validation of datafile backup set

channel d1: reading from backup piece /oradata/backup/SAN_c-2792912513-20140731-03.ctl

channel d1: piece handle=/oradata/backup/SAN_c-2792912513-20140731-03.ctl tag=TAG20140731T175302

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:00:01

Finished restore at 2014-JUL-31 21:26:59

Starting restore at 2014-JUL-31 21:26:59

List of Backups

===============

Key     TY LV S Device Type Completion Time      #Pieces #Copies Compressed Tag

------- -- -- - ----------- -------------------- ------- ------- ---------- ---

273     B  0  A DISK        2014-JUL-31 17:02:46 1       1       YES        LEVEL0

274     B  0  A DISK        2014-JUL-31 17:03:41 1       1       YES        LEVEL0

272     B  0  A DISK        2014-JUL-31 17:02:05 1       1       YES        LEVEL0

275     B  0  A DISK        2014-JUL-31 17:03:47 1       1       YES        LEVEL0

276     B  0  A DISK        2014-JUL-31 17:03:57 1       1       YES        LEVEL0

277     B  0  A DISK        2014-JUL-31 17:04:37 1       1       YES        LEVEL0

List of Backups

===============

Key     TY LV S Device Type Completion Time      #Pieces #Copies Compressed Tag

------- -- -- - ----------- -------------------- ------- ------- ---------- ---

280     B  A  A DISK        2014-JUL-31 17:52:59 1       1       YES        ARCHIVELOG

284     B  A  A DISK        2014-JUL-31 20:36:08 1       1       YES        ARCHIVELOG

285     B  A  A DISK        2014-JUL-31 20:36:09 1       1       YES        ARCHIVELOG

Media recovery start SCN is 1996728

Recovery must be done beyond SCN 1996786 to clear datafile fuzziness

channel d1: starting validation of datafile backup set

channel d1: reading from backup piece /oradata/backup1/SAN_2792912513_20140731_b3pepnqv_1_1

channel d1: piece handle=/oradata/backup1/SAN_2792912513_20140731_b3pepnqv_1_1 tag=LEVEL0

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:00:01

channel d1: starting validation of datafile backup set

channel d1: reading from backup piece /oradata/backup1/SAN_2792912513_20140731_b5pepnsn_1_1

channel d1: piece handle=/oradata/backup1/SAN_2792912513_20140731_b5pepnsn_1_1 tag=LEVEL0

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:00:07

channel d1: starting validation of datafile backup set

channel d1: reading from backup piece /oradata/backup1/SAN_2792912513_20140731_b6pepnu5_1_1

channel d1: piece handle=/oradata/backup1/SAN_2792912513_20140731_b6pepnu5_1_1 tag=LEVEL0

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:00:07

channel d1: starting validation of datafile backup set

channel d1: reading from backup piece /oradata/backup1/SAN_2792912513_20140731_b7pepnvi_1_1

channel d1: piece handle=/oradata/backup1/SAN_2792912513_20140731_b7pepnvi_1_1 tag=LEVEL0

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:00:01

channel d1: starting validation of datafile backup set

channel d1: reading from backup piece /oradata/backup1/SAN_2792912513_20140731_b8pepnvs_1_1

channel d1: piece handle=/oradata/backup1/SAN_2792912513_20140731_b8pepnvs_1_1 tag=LEVEL0

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:00:01

channel d1: starting validation of datafile backup set

channel d1: reading from backup piece /oradata/backup/SAN_2792912513_20140731_b4pepnr0_1_1

channel d1: piece handle=/oradata/backup/SAN_2792912513_20140731_b4pepnr0_1_1 tag=LEVEL0

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:01:05

channel d1: starting validation of archived log backup set

channel d1: reading from backup piece /oradata/backup/SAN_2792912513_20140731_bcpepqrr_1_1

channel d1: piece handle=/oradata/backup/SAN_2792912513_20140731_bcpepqrr_1_1 tag=ARCHIVELOG

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:00:00

channel d1: starting validation of archived log backup set

channel d1: reading from backup piece /oradata/backup1/SAN_2792912513_20140731_bfpeq4dn_1_1

channel d1: piece handle=/oradata/backup1/SAN_2792912513_20140731_bfpeq4dn_1_1 tag=ARCHIVELOG

channel d1: restored backup piece 1

channel d1: validation complete, elapsed time: 00:00:00

channel d1: starting validation of archived log backup set

channel d1: reading from backup piece /oradata/backup/SAN_2792912513_20140731_bgpeq4do_1_1

channel d1: ORA-19870: error while restoring backup piece /oradata/backup/SAN_2792912513_20140731_bgpeq4do_1_1

ORA-19505: failed to identify file "/oradata/backup/SAN_2792912513_20140731_bgpeq4do_1_1"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

failover to previous backup

released channel: d1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 07/31/2014 21:28:23

RMAN-06026: some targets not found - aborting restore

RMAN-06025: no backup of archived log for thread 1 with sequence 386 and starting SCN of 1997997 found to restore

Recovery Manager complete.

Error resulted from missing archived log and backup for archived log.