| Data File Lost [message #53022] |
Fri, 23 August 2002 22:32  |
Ani
Messages: 56
Registered: November 2000
|
Member |
|
|
Hi,
We have a database contains oracle 7.3.2 . One of the database file is accidently corrupted. WE came to know that this file belongs to one tablespace, which is not critical.
Our database is running in NOARCHIVE log mode. We can't open our database due to this file is missing. Is there anyway we can bring the database without this file.
I have a full database dump (export file ) prior to this failure.
Thanks in advance
Ani
|
|
|
|
| Re: Data File Lost [message #53028 is a reply to message #53022] |
Sun, 25 August 2002 11:47  |
xyz...
Messages: 1
Registered: August 2002
|
Junior Member |
|
|
Hi,
You can keep the database in mount status, and bring the corresponding tablespace off line, open the database now drop the corrupted datafile, and remember to take the back up of the control file. Now you can bring the tablespace back to online.
Hope that helps..
xyz...
|
|
|
|
| Re: Data File Lost [message #53034 is a reply to message #53022] |
Sun, 25 August 2002 23:12 |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Not right as xyz.. posted. Here is the proof and the way of doing it:
"Recovering a Database in NOARCHIVELOG Mode
If a database is in NOARCHIVELOG mode and a media failure damages some or all of the datafiles, the only option for recovering the database is usually to restore the most recent whole database backup. If you are using Export to supplement regular backups, then you can instead restore the database by importing an exported backup of the database.
The disadvantage of NOARCHIVELOG mode is that to recover your database from the time of the most recent full backup up to the time of the media failure, you have to re-enter manually all of the changes executed in that interval. If your database was in ARCHIVELOG mode, however, the redo log covering this interval would have been available as archived log files or online log files. Using archived redo logs would have enabled you to use complete or incomplete recovery to reconstruct your database, thereby minimizing the amount of lost work.
If you have a database damaged by media failure and operating in NOARCHIVELOG mode, and you want to restore from your most recent consistent whole database backup.
"
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
