Redirected restore Oracle database failed, RMAN error information “failover to previous backup” and “image not found in NetBackup catalog”

Problem

Review RMAN detailed information. RMAN tried to restore the data files from the latest backup piece, but failed and failover to previous backup piece one by one until the one which had expired in NetBackup Catalog.
Note:
Use command “/usr/openv/netbackup/bin/bplist –C original_oracle_server –t 4 –l –R /” to check the images in NetBackup Catalog.

==========================================
After mounting database, restore Oracle  database failed.
RMAN> run{
allocate channel ch00 type sbt_tape;
allocate channel ch01 type sbt_tape;
send 'nb_ora_serv=master_server,nb_ora_client=original_oracle_server';
restore database;
recover database;
release channel ch00;
release channel ch01;
}
2> 3> 4> 5> 6> 7> 8> 9>
allocated channel: ch00
channel ch00: sid=542 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 10.0 (2010010419)

allocated channel: ch01
channel ch01: sid=539 devtype=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 10.0 (2010010419)

sent command to channel: ch00
sent command to channel: ch01

Starting restore at 30-MAR-11

channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oracle/oradata/orcl/system01.dbf
restoring datafile 00006 to /oracle/oradata/orcl/DRGN_INDEX01.dbf
restoring datafile 00010 to /oracle/oradata/orcl/DRGN_DATA07.dbf
restoring datafile 00014 to /oracle/oradata/orcl/DRGN_DATA03.dbf
restoring datafile 00019 to /oracle/oradata/orcl/DRGN_INDEX02.dbf
channel ch00: reading from backup piece bk_358_1_746622159
.
.
failover to previous backup

channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oracle/oradata/orcl/system01.dbf
restoring datafile 00006 to /oracle/oradata/orcl/DRGN_INDEX01.dbf
restoring datafile 00010 to /oracle/oradata/orcl/DRGN_DATA07.dbf
restoring datafile 00014 to /oracle/oradata/orcl/DRGN_DATA03.dbf
restoring datafile 00019 to /oracle/oradata/orcl/DRGN_INDEX02.dbf
channel ch00: reading from backup piece bk_349_1_746618014
.
.
failover to previous backup

channel ch01: starting datafile backupset restore
channel ch01: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oracle/oradata/orcl/system01.dbf
restoring datafile 00006 to /oracle/oradata/orcl/DRGN_INDEX01.dbf
restoring datafile 00010 to /oracle/oradata/orcl/DRGN_DATA07.dbf
restoring datafile 00014 to /oracle/oradata/orcl/DRGN_DATA03.dbf
restoring datafile 00019 to /oracle/oradata/orcl/DRGN_INDEX02.dbf
channel ch01: reading from backup piece bk_291_1_746401343
ORA-19870: error reading backup piece bk_292_1_746401344
ORA-19507: failed to retrieve sequential file, handle="bk_292_1_746401344", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Backup file <bk_292_1_746401344> not found in NetBackup catalog
 

Cause

On the restore target server, Oracle account has Write Permission to the directory saving Oracle control files, but has no Write Permission to the directory saving Oracle data files.

Solution

Login root account, change the permission of the directory saving Oracle data files.