SAP cross restore not working

[nounejmak]

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

[Nicolai]

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.

[nounejmak]

i have solved problem - https://www-secure.symantec.com/connect/forums/restore-sap-backups-using-rman

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

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 · Accepted solution]

https://www-secure.symantec.com/connect/forums/restore-sap-backups-using-rman

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

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)";