Using brtools to recover to different server

[vince_laurent]

I have the need to recover one system, SND, to another, PSS.  Both are running Oracle 11.2.0.4 on HP-UX 11.31.  I have access to HP Data Protector for the recovery but I was informed that I should use brtools to recover one SID to another.

I have tried using the DP GUI and recovery to a new SID doesn't seem possible.  Files from, say /oracle/PSS/sapdata1/file_1/file1.dbf end up in /oracle/SND/sapdata1/oracle/PSS/sapdata1/file_1/file1.dbf.  In other words, using the GUI there is no way to remove the path.

Using The Google i can find bits and pieces of examples but nothing concrete.  The closet I have found is:

"I am in the process of validating the functionality right now. So far it seems to work:

set OB2APPNAME=SID

set OB2HOSTNAME=source_host.domain.name

set OB2BARHOSTNAME=source_host.domain.name

brrestore -m PSAPSIDUSR=H:\ORACLE\SID\SAPBACKUP -b bebktbgr.anf -d util_file"

Anyone have a doc/example they can share?

Thanks

Vince

[srinivasan_vinayagam]

Hi Vince,

Are you restoring or recovery?

Which backup you having online of offline?

Files required are : .utl, .sap (located at /oracle/SID/112_64/dbs), backup logs including the backupSID.log (located at /oracle/SID/sapbackup),.

Once they are copid to the target system you can start the restore with the brrestore tool.

If you are using an online backup the you need to restore the archived logs as well to recover the database.

Regards,

V Srinivasan

[vince_laurent]

Restore to a new server from an OFFLINE backup.

There are no *utl files in the dbs dir nor in any directory below /oracle:

sapsnd:orasnd 9> pwd

/oracle/SND/11204/dbs

sapsnd:orasnd 10> ls -lrt

-rw-r--r-- 1 orasnd dba 12849 Apr 15 2009 initSND.sap

-rw-r--r-- 1 orasnd dba 2851 May 15 2009 init.ora

-rw-r----- 1 orasnd dba 24 Nov 7 12:02 lkSND_SAPSND

-rw-r----- 1 orasnd dba 5120 Nov 17 09:53 spfileSND.ora

-rw-r----- 1 orasnd dba 3072 Nov 20 08:39 orapwSND

-rw-rw---- 1 orasnd dba 1544 Dec 9 08:16 hc_SND.dat

-rw-r----- 1 orasnd dba 2397 Dec 11 06:16 initSND.ora

I have looked over the docs that you mention and they sort of help...

[former_member204080]

Hi Vince,

If you are using HPDP as your backup solution ,please check below

1.How is the backup of SND system taken currently,if HPDP backup solution is used then there will be initSND.utl file .If file is not there then the backup must be schduled directly from HPDP client and not from SAP level.

2.Are both source and target systems connected to same HPDP cell manager

3.If yes you can just copy the SND util file and place in PSS system along with backup log(.anf/aff) and Back<SID>/log

If both servers are in different cell manager then HPDP team(your backup team) must do some changes to move the backup to PSS cellmanager and then you can start restore

Regards,

Murali

[vince_laurent]

1. HP Data Protectotor is being used by both clients BUT the backups are being kicked off by a cron job that calls a script that runs the following line with the backup parameters (ie SND_BRB_ON) so there is no utl file

/opt/omni/bin/omnib -datalist $backupname -mode Full -load high

2. Yes, both are connected.

3. See #1. Here is the line from SND's OFFLINE back (from the backup.log):

bepkopyt anf 2014-12-16 00.12.31 2014-12-16 02.55.35 0 ............... 124 124 0 8318 45493312957 8326 45493961981 ALL online util_file_online ------ 7.20 (35) SND

Here are a few lines from the bepkopyt file:

oracle_sid SND

oracle_home /oracle/SND/112_64

oracle_profile /oracle/SND/112_64/dbs/initSND.ora

sapdata_home /oracle/SND

sap_profile /oracle/SND/112_64/dbs/initSND.sap

backup_mode ALL

backup_type online

backup_dev_type util_file_online

system_info orasnd/orasnd sapsnd HP-UX B.11.31 U ia64

oracle_info SND 11.2.0.4.0 8192 8317 45493091178 sapsnd WE8DEC UTF8 3483439036 &SND_SAPSND

sap_info 731 SAPR3 DEV T0343528906 R3_ORA 0020073230

make_info hpia64 OCI_102 Nov 20 2013 720_REL

command_line /usr/sap/SND/SYS/exe/run/brbackup -t online -d util_file_online -c -m all -u

br_env ORACLE_SID=SND,

ORACLE_HOME=/oracle/SND/112_64,

NLS_LANG=.WE8DEC,

SAPDATA_HOME=/oracle/SND

Backint is started with the following parameters:

/usr/sap/SND/SYS/exe/run/backint -u SND -f backup -i /oracle/SND/sapbackup/.bepkopyt.lst -t file_online -c.

Though the command line sats util_file_online there is no utl file on either server or the Cell Manager.