Change the location of datafiles :system refresh (brtools)

[Former Member]

Hi experts,

I am going to refresh our quality server & taken the full online backup of production server using brtools.

i have doubt regarding the restore the backup file contains the entry of data file

/oracle/PRD/sapdata1

/oracle/PRD/sapdata2

oracle/PRD/sapdata3

/oracle/PRD/sapdata4

so how can i restore the data in ?

/oracle/QTY/sapdata1

/oracle/QTY/sapdata2

oracle/QTY/sapdata3

/oracle/QTY/sapdata4

means how to change the location of datafiles PRD to QTY.

quality system sid is->DEV

Production sid is ->PRD

oracle 10 G

[former_member188883]

Hi Vivek,

I assume you already have below file systems in QAS system

/oracle/QTY/sapdata1

/oracle/QTY/sapdata2

oracle/QTY/sapdata3

/oracle/QTY/sapdata4

In such a case you need not perform any changes. Restore using brtools which map the files from /oracle/PRD/sapdata1 -> /oracle/QAS/sapdata1  respectively.

You may need to copy the backup.<SID> file as well as offline backup file to QAS or DEV where you want to restore and then execute the command

brrestore -m full -b <file name of offline backup>

Hope this helps.

Regards,

Deepak Kori

[Sriram2009]

Hi Basis Team

Could you refer the SCN link

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/707dbe81-ef39-2b10-a0ac-ec50f3b48...

BR

SS

[Reagan]

You need to use the .sap and .utl files along with the backup (online or offline) log files used by for the PRD backup to restore the PRD backup to the QTY server.

Also create a symbolic link PRD -> QTY under /oracle/QTY

Regards

RB