Video Screencast Help

Restore Issue

Created: 27 May 2013 • Updated: 28 May 2013 | 13 comments
This issue has been solved. See solution.

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

Operating Systems:

Comments 13 CommentsJump to latest comment

Yasuhisa Ishikawa's picture

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?

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

wannawin's picture

Hi Yasu.

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

restore to original host..

Marianne's picture

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.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

SOLUTION
wannawin's picture

Hello Marianne/Yasu.

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

Marianne's picture

Please explain the reason for your question?

This post is about restore of a database.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

wannawin's picture

Hi.

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

Marianne's picture

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?

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

wannawin's picture

Hello Marianne.

Restore is performed by same user

Yes, restore is perfomed on different location..

wannawin's picture

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's picture

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. 

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

huanglao2002's picture

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 Ishikawa's picture

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

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan