11-12-2012 12:46 AM
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:\
Solved! Go to Solution.
11-13-2012 05:05 AM
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)";
11-12-2012 07:13 AM
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.
11-13-2012 05:04 AM
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)";
11-13-2012 05:05 AM
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)";