Restoring With Compressed Backup on Oracle.

[Former Member]

Hi,

We are taking Oracle Database back up in to Tape on compress mode in ProductionServer by modifying the initLPV.sap file as we have 300 GB of data, now I want to restore this backup using tape on to Quality Server.. SAP is running with AIX 5.3 and Oracle 9.2

What BRRESTORE option do I need to choose while Restoring in to Quality server?

Thanku

[Former Member · Accepted solution]

Please find the steps below.

copy /oracle/PRD/sapbackup/ to test in (/oracle/<NEW-SID>/sapbackup)

rename backdev.log according to test server in /oracle/NEW-SID/sapbackup

rename archPRD.log according to test server in /oracle/NEW-SID/sapbackup/DEV/

parameter in init<NEWSID>.ora is same as describe in Note

Then try to run brtools.

Thanks

Rishi abrol

[Former Member · Accepted solution]

Hi,

Thanks for quick response.

I am looking for brrestore option.

Before set compress=yes in initLVP.sap I used to restore using below command.

brrestore -b <Deatiledlog file> -m full

but now I have set compress=yes in initLVP.sap so I want to know does same commad work or is there any option to uncompress the data and restore in brrestore commands

Thanks

[Former Member · Accepted solution]

Hi,

Any inputs for the same.

Thanku