Home » RDBMS Server » Server Administration » control file and data file recovery (10gR2 EE win 2003)
control file and data file recovery [message #306198] Thu, 13 March 2008 04:52 Go to next message
maoro
Messages: 310
Registered: May 2005
Senior Member
hello
i have an oracle database 10GR2 EE on windows server 2003 sp2
the database is in archive log mode
today i lost all control files+ the system datafile
i have a cold backup od datafiles only + a script to recreate the controlfiles
i restored the system datafile from cold backup
but when i run the script to recreate the controlfiles i got this error:

ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01189: file is from a different RESETLOGS than previous files

any help is appreciated
thanks

Re: control file and data file recovery [message #306241 is a reply to message #306198] Thu, 13 March 2008 07:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You need to restore all the files including control files.
Re: control file and data file recovery [message #306255 is a reply to message #306241] Thu, 13 March 2008 08:21 Go to previous messageGo to next message
maoro
Messages: 310
Registered: May 2005
Senior Member
but then ill loose data
right?
Re: control file and data file recovery [message #306357 is a reply to message #306198] Thu, 13 March 2008 19:08 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>but then ill loose data
>right?

Not if you do the recovery properly.
After the restoration is completed, apply all the archived redo logfiles between the cold backup & the failure and open the DB.
Previous Topic: how to delete the duplicated triggers.
Next Topic: New databsae in exsisting db server
Goto Forum:
  


Current Time: Wed Dec 07 12:42:25 CST 2016

Total time taken to generate the page: 0.11308 seconds