Home » RDBMS Server » Backup & Recovery » how to recreate confil without any bkp (ora9i 9.2.0.1.0 win)
how to recreate confil without any bkp [message #322797] Mon, 26 May 2008 04:50 Go to next message
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]
Re: how to recreate confil without any bkp [message #322806 is a reply to message #322797] Mon, 26 May 2008 05:16 Go to previous messageGo to next message
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;
Re: how to recreate confil without any bkp [message #322812 is a reply to message #322797] Mon, 26 May 2008 05:24 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
CREATE CONTROLFILE

Regards
Michel
Previous Topic: Changing backup location in RMAN backups
Next Topic: Datafile recovery
Goto Forum:
  


Current Time: Thu Dec 08 06:37:03 CST 2016

Total time taken to generate the page: 0.11653 seconds