Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

SAP cross restore not working

Created: 12 Nov 2012 • Updated: 25 Jan 2013 | 3 comments
nounejmak's picture
This issue has been solved. See solution.

we use sap backup via brtools

we want to do cross recovery from server SRPDBS301068bk to another

I suspect the wrong client is used when searching the netbackup database. So parms 'ENV=(NB_ORA_CLIENT=SRPDBS301068bk,NB_ORA_SID=PG1)'; isn’t working

run { allocate channel sbt_1 device type 'SBT_TAPE' parms 'ENV=(NB_ORA_CLIENT=SRPDBS301068bk,NB_ORA_SID=PG1)';

set newname for datafile 'L:\ORACLE\PG1\SAPDATA2\SR3_2\SR3.DATA2' to 'L:\ORACLE\UG1\SAPDATA2\SR3_2\SR3.DATA2';

set newname for datafile 'L:\ORACLE\PG1\SAPDATA2\SR3_1\SR3.DATA1' to 'L:\ORACLE\UG1\SAPDATA2\SR3_1\SR3.DATA1';

set newname for datafile 'K:\ORACLE\PG1\SAPDATA1\SR3702_1\SR3702.DATA1' to 'K:\ORACLE\UG1\SAPDATA1\SR3702_1\SR3702.DATA1';

set newname for datafile 'K:\ORACLE\PG1\SAPDATA1\SR3702_2\SR3702.DATA2' to 'K:\ORACLE\UG1\SAPDATA1\SR3702_2\SR3702.DATA2';

set newname for datafile 'L:\ORACLE\PG1\SAPDATA2\SR3USR_1\SR3USR.DATA1' to 'L:\ORACLE\UG1\SAPDATA2\SR3USR_1\SR3USR.DATA1';

set newname for datafile 'K:\ORACLE\PG1\SAPDATA1\UNDO_1\UNDO.DATA1' to 'K:\ORACLE\UG1\SAPDATA1\UNDO_1\UNDO.DATA1';

set newname for datafile 'K:\ORACLE\PG1\SAPDATA1\SYSAUX_1\SYSAUX.DATA1' to 'K:\ORACLE\UG1\SAPDATA1\SYSAUX_1\SYSAUX.DATA1';

set newname for datafile 'K:\ORACLE\PG1\SAPDATA1\SYSTEM_1\SYSTEM.DATA1' to 'K:\ORACLE\UG1\SAPDATA1\SYSTEM_1\SYSTEM.DATA1';

restore datafile 4,5,6,7,3,1,2,8 from tag bejvcmnr force;

release channel sbt_1; }

BR0280I BRRESTORE time stamp: 2012-11-09 12.06.54

BR0351I Restoring L:\ORACLE\UG1\SAPDATA2\SR3USR_1\SR3USR.DATA1 ...

channel sbt_1: restoring datafile 00008 to L:\ORACLE\UG1\SAPDATA2\SR3USR_1\SR3US

R.DATA1

channel sbt_1: reading from backup piece PG1_bejvcmnr.202_1

channel sbt_1: ORA-19870: error while restoring backup piece PG1_bejvcmnr.202_1

ORA-19507: failed to retrieve sequential file, handle="PG1_bejvcmnr.202_1", parm

s=""

ORA-27029: skgfrtrv: sbtrestore returned error

ORA-19511: Error received from media manager layer, error text:

   Backup file <PG1_bejvcmnr.202_1> not found in NetBackup catalog

C:\Users\pg1adm>bplist -C srpdbs301068bk -k dbf_win_sap_01_1m_DSSU2A_2200 -t 17 -s 11/06/2012 -e 11/06/2012 -R /|more

G:\oracle\PG1\11203\database\INITpg1.ORA

G:\oracle\PG1\11203\database\SPFILEPG1.ORA

G:\oracle\PG1\11203\database\initPG1.sap

G:\oracle\PG1\11203\database\initPG1.utl

I:\oracle\PG1\sapreorg\spacePG1.log

I:\oracle\PG1\sapreorg\strucPG1.log

I:\oracle\PG1\sapbackup\bejvcmnr.fnr

I:\oracle\PG1\sapbackup\backPG1.log

I:\oracle\PG1\sapbackup\CNTRLPG1.DBF

c-3462064675-20121106-00:\

PG1_bejvcmnr.202_1:\

PG1_bejvcmnr.201_1:\

PG1_bejvcmnr.200_1:\

PG1_bejvcmnr.199_1:\

PG1_bejvcmnr.198_1:\

PG1_bejvcmnr.197_1:\

PG1_bejvcmnr.196_1:\

PG1_bejvcmnr.195_1:\

Discussion Filed Under:

Comments 3 CommentsJump to latest comment

Nicolai's picture

This command is that from the source or destination client ?

bplist -C srpdbs301068bk -k dbf_win_sap_01_1m_DSSU2A_2200 -t 17 -s 11/06/2012 -e 11/06/2012 -R /|more

Command should be working from both source and destination.Have you give the destination altnames restore permissions ?

http://www.symantec.com/docs/TECH77362

This T/N is for Oracle but alternate permission section is universal.

Assumption is the mother of all mess ups.

If this post answered your'e qustion -  Please mark as a soloution.

nounejmak's picture

i have solved problem - https://www-secure.symantec.com/connect/forums/res...

--------------------------------------------------------------------

The trick was which variable to pass to NBU:

run {

allocate channel ch1 type 'sbt_tape' parms="ENV=(NB_ORA_SAP=dummy, NB_ORA_CLIENT=srpdbs301068bk)";

nounejmak's picture

https://www-secure.symantec.com/connect/forums/res...

-----------------------------------------------------------------

The trick was which variable to pass to NBU:

run {

allocate channel ch1 type 'sbt_tape' parms="ENV=(NB_ORA_SAP=dummy, NB_ORA_CLIENT=srpdbs301068bk)";

SOLUTION