Sunday 16 June 2013

Generate Oracle Control File

In the process of setting up a PRD instance in the QAS server, it require to obtain the PRD Oracle control file from the PRD system.

Refer to the earlier post for restoring PRD Instances into QAS for DR Purposes

The steps to generate the control file:

1) Login as <SID>adm in the PRD system

2) Open a command prompt / Putty session: 

4) Type -> sqlplus '/as sysdba' 

5) SQL> alter database backup controlfile to trace;

6) Locate the trace file at /oracle/<SID>/saptrace/diag/rdbms/prd//PRD/trace/<SID>_ora_<PID>.trc

7) That it's, copy the generated "trc" file to the QAS temporary folder for the PRD instances setup (will be cover soon)

1 comment: