| oracle database file corruption! [message #65554] |
Tue, 26 October 2004 02:26  |
Soham
Messages: 29
Registered: June 2004
Location: Mumbai
|
Junior Member |
|
|
I am getting following error while starting up the database,
<database_file_name.ora> is corruptted. this file cannot be varified.
What is database file corruption? what might be the possible causes? how can we recover the database files(i have the cold back up)?
thanx,
regards,
soham
|
|
|
|
| Re: oracle database file corruption! [message #65565 is a reply to message #65554] |
Sat, 30 October 2004 09:21  |
Edward Stoever
Messages: 58
Registered: August 2002
|
Member |
|
|
If you have a database with 10 files, but only one is corrupted, replace that ONE file with the backup copy, and recover. You don't need to recover all of the files. This will save a lot of time because the redo only needs to be applied to that one file. Of course, your database must have been in archive log mode.
Edward Stoever -- www.database-expert.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
