System Refresh from PRD to QA

[Former Member]

Dear Experts,

     I have a confusion regarding the system refresh from Prod to QA. I have backup of our production system dated 5th Oct that is to be restored to QA.

Now if we restore the offline backup onto QA system then how we should generate the control file?

My understanding, start the database (target system, QA) to no mount stage and then give the command alter database backup controlfile to trace.

Then we edit the trace file

Remove all lines before "STARTUP MOUNT" line. Delete all commented "#" lines. Also remove all lines after CHARACTER SET UTF8;" line.

Change all Source SOR SID to TAR SID

Change the line

CREATE CONTROLFILE REUSE DATABASE ‘TAR’ NORESETLOGS ARCHIVELOG;

As follow

CREATE CONTROLFILE REUSE SET DATABASE ‘SOR’ RESETLOGS ARCHIVELOG;

After this we give the command alter database open resetlogs.

Is my understanding correct?

Regards

Sushant

[former_member188883 · Accepted solution]

Hi Sushant,

1) Create trace file from Production and not QAS.

2) the modification in trace file command should be as follows

CREATE CONTROLFILE  SET DATABASE ‘SOR’ RESETLOGS ARCHIVELOG;

3) Create controlile in QAS and then recover the database by applying redo logs

4) Open the database with resetlogs

Hope this helps.

Regards,

Deepak Kori

[ankit_gupta32]

Hi Sushant,

Above points are correct. Just 1 more point to add :

You need to ensure there is no new datafile added to PROD database in between of offline backup and command execution 'alter database backup controlfile to trace'. Otherwise, there will inconsistency in the no. of datafiles in control file and actual offline backup.

You need to adapt your controlfile accordingly.

Regards,

Ankit G

[Reagan]

Take time to read this SAP note 1889854 - Recreation of the Control file

Once the control files are re-created then you will open the database with the resetlogs option.

RB