restore in other instance

[Former Member]

Hi all.

I want testing my backups. Testing will be in restore backups into other copy of SAP instance.

for example: 1. I have instance with name SID1. and backup on tape

2. Create new_zone in Solaris

3. Copy oracle and sap bin (SID1) into new_zone

4. Edit the users, ORACLE and SAP profiles for SID2

5. test start for SID2

6. it may be necessary connect tape library in new_zone

SID1 & SID2 located on the same physical server

q: how can I restore backup on tape for SID1 to enviroment SID2?

i try use brrestore: brrestore -b bddcbjcq.afd -m all=/new_zone/root/SID2/.....

but recovered only datafiles without directories structure and other files.

Thank you for your help

Edited by: Andrey Burakov on Mar 31, 2011 1:19 PM

[markus_doehr2]

> 2. Create new_zone in Solaris

> 3. Copy oracle and sap bin (SID1) into new_zone

Copying Oracle binaries is not supported to do a system copy (oraInventory will be damaged etc.)

I suggest you follow the normal system copy guides to do such a copy.

Markus

[Former Member]

thanks for advice Markus but how can I restore backup on tape for SID1 to enviroment SID2? with brtools

[markus_doehr2]

As I already suggested, read the System copy guides:

Basically it's like

- start sapinst on the target system

- select system copy using backup/restore

- give all DVDs and parameters

- sapinst installs a system as it would be new

- sapinst stops and tells you to restore the backup using brtools

- sapinst continues

Markus

[Former Member]

As you seem to be testing your restore functionality, here is my input for backups taken with brbackup:

- you can always restore a redo log file (on the same system) without any problems

orasid> brrestore -a <archive_num>
orasid> cd oraarch; rm <archivfile>

- you can always restore a datafile or tablespace to a new path without interrupting the running database

orasid> cd sapdata1; mkdir restore
orasid> brrestore -m SYSTEM=/oracle/SID/sapdata1/restore
orasid> rm -r restore

Depending on your backup configuration you have to supply a few additional options.

Cheers Michael

Edit: i think brrestore will not create the directories when using -m all=/new_zone/root/SID2/..... syntax, but it fhe files were restored you are basically ok.