Skip to Content
0
Former Member
Oct 09, 2014 at 12:08 PM

System Refresh from PRD to QA

156 Views

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