Ayuda de vídeo de Screencast

SAP cross restore not working

Created: 12 Nov 2012 • Updated: 25 Enero 2013 | 3 comments
el cuadro de los nounejmak
Se ha solucionado este problema. Vea la solución.

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

Discusión Filed Under:

Comentarios ComentariosIr al último comentario

el cuadro de los 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.

Assumption is the mother of all mess ups.

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

el cuadro de los nounejmak

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

el cuadro de los nounejmak

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

SOLUCIÓN