RE: Recovery of offline datafile
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "mdnajeeb_1634@xxxxxxxxxxx" <mdnajeeb_1634@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 4 Nov 2008 10:33:44 -0500
Well, first, try a ‘recover datafile ‘/path/to/offline/datafile’
It’s possible, depending on how long the file has been offline, that you’ll
recover it from just the on-line redo. (Perhaps not likely, but it’s worth a
try.)
If recovery is not possible, the next best option is to drop the tablespace
containing the file. If there’s data in that tablespace that you want to
retain, you could create a new tablespace, and then move any tables out of the
problem tablespace into a new tablespace, and rebuild indexes into the new
tablespace, then drop the problem tablespace.
Those are the most simple and straightforward solutions.
Will either one work for you?
-Mark
--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxx<mailto:mark.bobak@xxxxxxxxxxxxxxx>
www.proquest.com<http://www.proquest.com>
www.csa.com<http://www.csa.com>
ProQuest...Start here.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of md najeeb
Sent: Tuesday, November 04, 2008 8:35 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Recovery of offline datafile
HI,
Iam Mohammed Najeeb working in saudia arabia for al-haif company I have oracle
10g installed and the issue i want to discuss is accidentally one of my
datafile belonging to
opera_data tablespace has made offline.and when i try to make it online, i
received error message that the file needs media recovery and i lost my archive
log files.and that
datafile is not much important for me.just i want to get out of error and want
to drop the datafile or recover the datfile.
but the other datafiles are important and my database is open.so plz
suggest me what i should do to recover or to drop the datafile with no archives
available.
Thanks & Regards
Mohmmed Najeeb
________________________________
Bollywood news, movie reviews, film trailers and more! Click
here.<http://in.rd.yahoo.com/tagline_movies_1/*http:/in.movies.yahoo.com/?wm=n/>
________________________________
Add more friends to your messenger and enjoy! Invite them
now.<http://in.rd.yahoo.com/tagline_messenger_6/*http:/messenger.yahoo.com/invite/>
Other related posts:
