Recreate control and p file(oracle dbatabase)

Asked By 10 points N/A Posted on -
qa-featured

Hi

How to recreate control file and profile using  alert log files.

Please anybody can tell me?its urgent.

SHARE
Answered By 0 points N/A #101529

Recreate control and p file(oracle dbatabase)

qa-featured

If you are using the same DB for all the functions then it is easy for you to do this task. Follow the steps below.

First make a trigger that would initiate the process of creating the control file.

Define the parameters for the trigger.

Use the alert log file as input parameter to the trigger and use its values inside the code to generate the control file.

Your trigger will look similar to this.

CREATE CONTROLFILE [REUSE]

DATABASE <database_name>
<RESETLOGS | NORESETLOGS>; STARTUP NOMOUNT; CREATE PSOUG.org CONTROLFILE REUSE

SET DATABASE orabase

RESETLOGS;

Oracle ALTER statement DATABASE  Oracle PL/SLQ, OPEN RESETLOGS; 

Make sure that you use your own variables because some variables are different from system to system so it might get you in trouble and your system might crash, so its better to use your own keywords and identifiers.

Login/Register to Answer

Related Questions