12-05-2014 11:01 AM
Hi All,
We got the below error when restore control file from netbackup.
run
{
allocate channel ch1 type 'sbt_tape' parms='ENV=(NB_ORA_SERV=utux155,NB_ORA_CLIENT=utux5)';
set until time "to_date( '18-11-2014 04:51', 'DD-MM-YYYY HH24:MI')";
restore controlfile from autobackup;
release channel ch1;
}
channel ch1: restoring control file
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/05/2014 11:13:37
ORA-19870: error while restoring backup piece ctl_OBBMM_2014-10-04_03-40-19_s54869_p1_t8601055526
ORA-19507: failed to retrieve sequential file, handle="ctl_OBBMM_2014-10-04_03-40-19_s54869_p1_t8601055526", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to open backup file for restore.
Thanks,
Solved! Go to Solution.
12-07-2014 04:01 AM
You need to take a look at the tech note below a re-run the restore
http://www.symantec.com/docs/HOWTO89559
http://www.symantec.com/docs/TECH32031
Do not attach debug text to a post, attach debug logs a files insted.
12-07-2014 04:01 AM
You need to take a look at the tech note below a re-run the restore
http://www.symantec.com/docs/HOWTO89559
http://www.symantec.com/docs/TECH32031
Do not attach debug text to a post, attach debug logs a files insted.
12-07-2014 10:54 PM
If this is a restore to a different Oracle client, haver you gone through the steps in 'Redirecting a restore to a different client' section of NBU for Oracle Admin Guide as suggested in Oracle Netbackup parameter ?
Can you verify that redirected restore is authorised on the master server?
Can you use bplist on destination client to list backups for the source client?
Do you have all the log folders that are listed in Troubleshooting chapter of NBU for Oracle Admin Guide?
First logs to look at is bprd on the master and dbclient on the destination client.