Recreate control and p file(oracle dbatabase)

Asked By lark alvarado 10 points N/A Posted on - 03/07/2012

Hi

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

Please anybody can tell me?its urgent.

• Status: Open
• Question Views: 989
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Michelle Bang 55 points N/A #101529

Recreate control and p file(oracle dbatabase)

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.

About Michelle Bang

Questions
2

Answers
515

Best Answers
73

• Vote Up 0 Vote Down

• Posted on - 04/17/2012
• Question Category: Oracle Database