Restore Issue

[wannawin]

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

[Yasuhisa_Ishika]

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?

[wannawin]

Hi Yasu.

How to check whether this c-1293103981-20130520-09 have been backed by netbackup?

restore to original host..

[Marianne · Accepted solution]

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.

[wannawin]

Hello Marianne/Yasu.

can we do duplication through imported multiplexed (status) media.

[Marianne]

Please explain the reason for your question?

This post is about restore of a database.

[wannawin]

Hi.

I am trying to duplicate the data from media to DD and trying to do a restore.

[Marianne]

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?

[wannawin]

Hello Marianne.

Restore is performed by same user

Yes, restore is perfomed on different location..

[wannawin]

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

[Marianne]

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. 

[huanglao2002]

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.

[Yasuhisa_Ishika]

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;
:
:
 

[wannawin]

Thanks Marianne.