Forum Discussion

mohammad_yaseen's avatar
mohammad_yaseen
Level 4
9 years ago

RMAN Validating Backup

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

7.7
Backing Up
Backup and Recovery
Configuring
Error messages
Evaluating
NetBackup
Restore
Solaris
Troubleshooting
  • Michael_G_Ander's avatar
    Michael_G_Ander
    Level 6
    9 years ago

    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's avatar
    Marianne
    Level 6
    9 years ago

    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.