| control file and data file recovery [message #306198] |
Thu, 13 March 2008 04:52  |
maoro
Messages: 312
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 #306357 is a reply to message #306198] |
Thu, 13 March 2008 19:08  |
 |
BlackSwan
Messages: 26766
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
