Home » RDBMS Server » Server Administration » Datafile Recovery (Oracle 10g)
Datafile Recovery [message #340955] Fri, 15 August 2008 03:09 Go to next message
parkarfaisal
Messages: 13
Registered: August 2008
Location: Kuwait
Junior Member
In my current environment i created a new datafile for USERS tablespace since the previous datafile location was going out of space. By mistake i created the datafile in the same location.I created another datafile in another location and made the second datafile offline. But now the status comes as recover.

Can anyone suggest what shall i do in this case and how can i remove the datafile as it is unused.
Re: Datafile Recovery [message #340965 is a reply to message #340955] Fri, 15 August 2008 06:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_3002.htm#i2133310

Regards
Michel
Re: Datafile Recovery [message #340993 is a reply to message #340965] Fri, 15 August 2008 08:08 Go to previous messageGo to next message
parkarfaisal
Messages: 13
Registered: August 2008
Location: Kuwait
Junior Member
i have made the datafile offline and the status displays as recover.

Can i stilll drop the datafile? After dropping the datafile will it affect my database?
Re: Datafile Recovery [message #340999 is a reply to message #340993] Fri, 15 August 2008 08:21 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Assuming you meet the restrictions specified in Restrictions for Dropping Datafiles, you can drop the datafile.
Re: Datafile Recovery [message #341080 is a reply to message #340999] Sat, 16 August 2008 01:30 Go to previous message
parkarfaisal
Messages: 13
Registered: August 2008
Location: Kuwait
Junior Member
Thank you very much for the reply
Previous Topic: ERROR ORA-01114
Next Topic: Flash Recovery Area
Goto Forum:
  


Current Time: Fri Dec 09 17:37:52 CST 2016

Total time taken to generate the page: 0.26403 seconds