OraFAQ Forum: Backup & Recovery » how to recreate confil without any bkp

Home » RDBMS Server » Backup & Recovery » how to recreate confil without any bkp (ora9i 9.2.0.1.0 win)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to recreate confil without any bkp [message #322797]

Mon, 26 May 2008 04:50

samir_amindba
Messages: 1
Registered: May 2008
Location: india

Junior Member

hi
can anybody tell me please how to recreate controlfile without any backup my controlfile is corrupted now i want to recreate controlfile if is it possible please give me the solution
thanks in advance
Regards
samir amin[/B]

Report message to a moderator

Re: how to recreate confil without any bkp [message #322806 is a reply to message #322797]

Mon, 26 May 2008 05:16

varu123
Messages: 754
Registered: October 2007

Senior Member

startup mount
alter database backup controlfile to trace;
shutdown immediate
startup nomount
create controfile statement[as generated in the trace file]
alter database open;

Report message to a moderator

Re: how to recreate confil without any bkp [message #322812 is a reply to message #322797]

Mon, 26 May 2008 05:24

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

CREATE CONTROLFILE

Regards
Michel

Report message to a moderator

Previous Topic:	Changing backup location in RMAN backups
Next Topic:	Datafile recovery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 00:34:54 CST 2025