RMAN Validating Backup

[mohammad_yaseen]

Dear All,

Our DBA is facing the error below when run the validate command on RMAN on the same Database Server [Client]:

Command:

Run{

allocate channel t1 type 'SBT_TAPE' maxopenfiles 1;

allocate channel t2 type 'SBT_TAPE' maxopenfiles 1;

allocate channel t3 type 'SBT_TAPE' maxopenfiles 1;

allocate channel t4 type 'SBT_TAPE' maxopenfiles 1;

allocate channel t5 type 'SBT_TAPE' maxopenfiles 1;

allocate channel t6 type 'SBT_TAPE' maxopenfiles 1;

restore database validate;

}

ERROR:

channel t6: ORA-19870: error while restoring backup piece v6r4opd7_1_1

ORA-19507: failed to retrieve sequential file, handle="v6r4opd7_1_1", parms=""

ORA-27029: skgfrtrv: sbtrestore returned error

ORA-19511: Error received from media manager layer, error text:

   Backup file <v6r4opd7_1_1> not found in NetBackup catalog

[Michael_G_Ander]

Can you see the problematic file in the Netbackup Catalog, with bplist ?

Name resolution can cause problems like this and the same goes for control files/rman catalogs out of sync with netbackup

Been a while since I did any DBA work, but think the restore command is missing some kind indication of which backup the DBA wants to validate

The General database backup error troubleshooting and General connectivity troubleshooting (status 23,24,25,58, often 6 ) posts could probably help you.

[Marianne]

I agree with Michael - see if backups can be listed with bplist.

Let the dba also perform crosscheck from rman to ensure rman catalogs are in sync with NBU.

To see how the master server is receiving and interpreting the request, ensure bprd log folder exists on the master.
If folder needs to be created, remember to restart NBU to enable the log.