controlfile to trace

[hamhey]

Dear all,
Backing up the controlfile as following works well:
alter database backup controlfile to 'control01.bkp'

Backing up the controlfile to text file trace doesn't work:
alter database backup controlfile to trace;

There is no trace file after issuing the the above command.

Do you have any idea what can be wrong.

Regards
Hamid

[alapps]

Where are you looking for the trace file?

The trace file will be in the udump destination...

[hamhey]

Thanks,
I searched in all subdirectories under the $ORACLE_HOME , and couldn't find any trace file by using unix command:
find $ORACLE/HOME -name trace

Thanks
Hamid

[sgodbole]

The trace file is located in the location specified by the USER_DUMP_DEST initialization parameter. The file name is something like this:

ora_xxxxxx.trc

When you searched for trace file you looked for file named trace and that is not correct. Go to user_dump_dest directory and use following command to get trace file name in which you will find create controlfile command:

grep "CREATE CONTROLFILE" *.trc

Hope this helps.

[hamhey]

Thanks,
The udump contains the file.
Last but leat:
Do ypu know how to recreate the controlfile from the trace file.

//Hamid

[sgodbole]

You then edit the trace file to create a script that creates a new control file based on the control file that was current when you generated the trace file.

[k.chithra]

Editing means ..remove all the unwanted lines and store only the statements starting with " CREATE CONTROLFILE ...DATAFILE ...;'
and save it in a name say recreate_ctl.sql

Start the database in nomount stage
ie after just instance is started
run recreate_ctl.sql

Controlfile gets recreated.
Open the Database.

Instead of doing step by step U can save from "startup nomount ...
alter database open " and execute it at a stretch.

But I prefer to go stage by stage..

Be careful in doing so (like not missing any datafile ...etc) as U are recreating controlfile itself

cheers

[adewri]

http://www.dbasupport.com/forums/sho...threadid=34259

HTH