brrestore to different location

[Former Member]

hello community,

I have a SAP ERP running with AIX and Oracle 9. Normally I make backup using transaction db13, and when I need to restore I use brrestore tool like this: brrestore -b<archive.ant> -m full, so this command restore all database files to the original location

/oracle/PRD/......

Now I need to restore all files to another location, example: /oracle/PRD_1/....,

How can I do this? is there any variable in a file, where I can set the new restore directory??

Thanks friends !!

[Former Member · Accepted solution]

Hi Javier,

From my experience, brrestore is quite intelligent to know the the filesystem to restore to.

brrestore –c –b <backup log file> -p init<SID>.sap -m full

Just make sure you have the enviroment variables set before running the restore

ORACLE_SID, SAPDATA_HOME etc.

brrestore will prompt you, if you have changed location of the filesystem (SID changed).

Hope this helps.

Cheers,

Nisch

[Former Member]

Hi Javier

I always test my restores while the system is running. I choose a small tablespace and give brrestore an alternate location:

brrestore -u / -r /oracle/SID/102_64/dbs/initSID.utl -m TSPNAME=/var/adm/crash

You might give this a try (please do test before doing on the prod system):

brrestore -u / -r /oracle/SID/102_64/dbs/initSID.utl -m all=/oracle/PRD_1/sapdata1

Regards

Michael