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;
CREATE CONTROLFILE REUSE SET DATABASE ‘SOR’ RESETLOGS ARCHIVELOG;
After this we give the command alter database open resetlogs.
Is my understanding correct?