Home » RDBMS Server » Server Administration » Status change of a data file without achive log file
Status change of a data file without achive log file [message #263338] Wed, 29 August 2007 14:34 Go to next message
manasbis
Messages: 8
Registered: August 2007
Junior Member
I'm unable to change the status of a data file from RECOVER to ONLINE. As I lost the relevant archive log, whicj is required for recovering the datafile. Any other option is there? Please HELP as I'm no able to upload data into the table without the data file. Though the data file contains ZERO data. Can I skip the file?
Re: Status change of a data file without achive log file [message #263340 is a reply to message #263338] Wed, 29 August 2007 14:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Put the datafile offline (if you can).
Export all data that are in the tablespace.
Drop and recreate the tablespace.
Import the data back.

Regards
Michel
Re: Status change of a data file without achive log file [message #263341 is a reply to message #263338] Wed, 29 August 2007 14:42 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
if you have valid backup you can restore it or if you know the data of datafile then simply drop tablespace and recreate another.

[Updated on: Wed, 29 August 2007 14:43]

Report message to a moderator

Re: Status change of a data file without achive log file [message #263379 is a reply to message #263338] Wed, 29 August 2007 22:21 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
Put the datafile offline (if you can).
Export all data that are in the tablespace.


If the datafile is offline then is it possible to export the data of that datafile?
Re: Status change of a data file without achive log file [message #263399 is a reply to message #263379] Wed, 29 August 2007 23:44 Go to previous messageGo to next message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
Since the datafile is offline...it only exports the definitions of the objects present in the tablespace. object data is not exported.
Re: Status change of a data file without achive log file [message #263426 is a reply to message #263338] Thu, 30 August 2007 00:48 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I think Michel you wanted to mean the tablespace contains more than one datafile. and make a export of other datfile rather than which is offline or can you clarify it?
Re: Status change of a data file without achive log file [message #263441 is a reply to message #263426] Thu, 30 August 2007 01:28 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Arju wrote on Thu, 30 August 2007 07:48
I think Michel you wanted to mean the tablespace contains more than one datafile. and make a export of other datfile rather than which is offline or can you clarify it?

Yes this is what I wanted to say.
As OP said there are data in the tablespace but not in this datafile I assume there are other data files.
If not, he has to explain clearer his problem.

Regards
Michel

Previous Topic: pfile and spfile
Next Topic: Migration
Goto Forum:
  


Current Time: Sun Dec 04 04:31:10 CST 2016

Total time taken to generate the page: 0.10039 seconds