| control files messed up [message #62246] |
Wed, 07 July 2004 07:57  |
naga
Messages: 5
Registered: January 2002
|
Junior Member |
|
|
We had a hard disk corruption, which was fixed using 'fsck -y'. This somehow corrupted the control files. When I tried to start the database, I got 'ORA-00214' error, which essentially said, inconsistent control files in 2 different locations of the /ora01 and /var/ . So I copied the /var/ control file to /ora01 to suppress the error message. But I am getting the following error now.
ORA-01110: data file 1: '/ora01/app/oracle/product/8.0.5/oradata/WG8/system01.dbf'
I am thinking, this is because of the old control file I am using. How do I fix the problem? I need some help with ALTER DATABASE RECOVER command. Please help.
Thanks
|
|
|
|
| Re: control files messed up [message #62251 is a reply to message #62246] |
Wed, 07 July 2004 22:51  |
Satheesh Babu.S
Messages: 35
Registered: July 2004
|
Member |
|
|
if you have problem only with the controlfile, why can't you create the control file newly.
You can generate the controlfile script using,
alter database backup controlfile to trace;
modify this trace file to your db requirement and start the db in nomount run the script and open the db
Thanks and Regards,
Satheesh Babu.S
bangalore.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
