05-27-2013 03:17 AM
Hello Team.
Phase one import and phase two import completed successfully.. after that we DBA team trying to perform a restore but restore showing error .
Starting restore at 25-MAY-2013:14:47:25
channel ch1: starting datafile backup set restore
channel ch1: restoring control file
channel ch1: reading from backup piece c-1293103981-20130520-09
channel ch1: ORA-19870: error while restoring backup piece c-1293103981-20130520-09
ORA-19507: failed to retrieve sequential file, handle="c-1293103981-20130520-09", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <c-1293103981-20130520-09> not found in NetBackup catalog
when i check , i found this file..
usnbub5500:root# ./bpflist -backupid hdbp01-brn_1369052664 -client hdbp01-brn -d 05/20/2013
FILES 8 4 0 1369052664 2 hdbp01-brn DB-P01-no_altsite_Tape hdbp01-brn_1369052664 - *NULL* 1 0 unknown unknown 0 0 P01
1 47448064 25 125 0 1 0 0 -1 /c-1293103981-20130520-08 33200 orap01 dba 47448064 1369049830 1369049830 1369049830 1 0 0 15 13 0 0 3 1369049830 1 4 Oracle Database Oracle Backup
Master server nbu version is 7.1
Solved! Go to Solution.
05-27-2013 04:02 AM
Restore needs to be performed by same user that did the backup: orap01.
Also confirm as per Yasuhisa's request if restore is done to same or alternate client.
05-27-2013 03:52 AM
Tailing number in backup handle is a bit different from that in NetBackup catalog.
Please confirm if c-1293103981-20130520-09 have been backed up by NetBackup. It is possible that DBA have taken this backup using disk channel.
BTW, are you restoring to original host or alternate host?
05-27-2013 04:02 AM
Hi Yasu.
How to check whether this c-1293103981-20130520-09 have been backed by netbackup?
restore to original host..
05-27-2013 04:02 AM
Restore needs to be performed by same user that did the backup: orap01.
Also confirm as per Yasuhisa's request if restore is done to same or alternate client.
05-27-2013 06:40 AM
Hello Marianne/Yasu.
can we do duplication through imported multiplexed (status) media.
05-27-2013 06:49 AM
Please explain the reason for your question?
This post is about restore of a database.
05-27-2013 07:05 AM
Hi.
I am trying to duplicate the data from media to DD and trying to do a restore.
05-27-2013 07:17 AM
This is your issue as per your opening post:
Phase one import and phase two import completed successfully.. after that we DBA team trying to perform a restore but restore showing error .
So, we have asked questions related to your opening post.
Help us to help you by sticking to your original post?
05-27-2013 08:17 AM
Hello Marianne.
Restore is performed by same user
Yes, restore is perfomed on different location..
05-27-2013 08:57 AM
The restore continues to fail restoring control file. I have included excerpt from 2 different logs, the current, a successful one of this database 1/10/2013. I am using the same script.
From CURRENT Log:
Starting restore at 27-MAY-2013:10:35:48
channel ch1: starting datafile backup set restore
channel ch1: restoring control file
channel ch1: reading from backup piece c-1293103981-20130520-09
channel ch1: ORA-19870: error while restoring backup piece c-1293103
981-20130520-09
ORA-19507: failed to retrieve sequential file, handle="c-1293103981-
20130520-09", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <c-1293103981-20130520-09> not found in NetBackup catalog
failover to previous backup
channel ch1: starting datafile backup set restore
channel ch1: restoring control file
channel ch1: reading from backup piece c-1293103981-20130520-08
channel ch1: ORA-19870: error while restoring backup piece c-1293103
981-20130520-08
Which you can compare to the one 1/10/2013:
Starting restore at 10-JAN-2013:08:20:21
channel ch1: starting datafile backup set restore
channel ch1: restoring control file
channel ch1: reading from backup piece c-1293103981-20130101-04
channel ch1: piece handle=c-1293103981-20130101-04 tag=TAG20130101T0
35536
channel ch1: restored backup piece 1
channel ch1: restore complete, elapsed time: 00:02:45
output file name=/oracle/Q02/origlogA/cntrl/cntrlQ02.dbf
output file name=/oracle/Q02/saparch/cntrl/cntrlQ02.dbf
output file name=/oracle/Q02/sapdata10/system_1/cntrl/cntrlQ02.dbf
Finished restore at 10-JAN-2013:08:23:14
05-27-2013 12:42 PM
You did not tell us how alternate client restore was initiated and how/if it was authorised on the master server.
Please go through steps in NBU for Oracle manual under the topic Redirecting a restore to a different client , then tell us if all of these steps were followed.
Logs needed for troubleshooting:
bprd on Master server
dbclient log on destination client.
05-27-2013 04:56 PM
Are you leak some pieces of netbackup image?
1 you can check the original backup output,you can find how many piece was backup.
2 use "bplist -C "orginal host name" -t 4 -l -R / | more" chek the image info.
3 if bplist out put equal the original piece,i think you can confident restore the database.
Hope it's help.
05-27-2013 08:38 PM
restore from previous backup handle(c-1293103981-20130520-08) is also failed. By this point, I assume you are trying to restore to alternate host that does not have sufficient right to read backups taken in original host.
As Marianne suggested, follow the steps like allowing alternate restore by creating file under altnames directory on the master server. Also ensure to specify NB_ORA_CLIENT value in RMAN commans like below.
RMAN> RUN {
1> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
2> SEND 'NB_ORA_CLIENT=original_client';
3> RESTORE DATABASE;
:
:
05-28-2013 08:27 AM
Thanks Marianne.