Home » RDBMS Server » Backup & Recovery » Error while recovering a Datafile
Error while recovering a Datafile [message #352720] Thu, 09 October 2008 02:58 Go to next message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
Hello all,

I have a DB in archivelog and when I am trying to recover a specific Datafile it says that a specific Archivelog is missing.


I try to change it to Online:
ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/stuff01.dbf' ONLINE;
and I get the following error:
ORA-01113: file 21 needs media recovery

Then I give
SQL>recover datafile 'C:\DB11\ORADATA\DB11\Example01.dbf';

and then I get the missing 6335 archive log error.

Any idea what can I do next?

thanks in advance
Mimas
Re: Error while recovering a Datafile [message #352721 is a reply to message #352720] Thu, 09 October 2008 03:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Restore the missing archived log(s).

Regards
Michel
Re: Error while recovering a Datafile [message #352727 is a reply to message #352720] Thu, 09 October 2008 03:56 Go to previous messageGo to next message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
Thanks for the answer but how can I do that since the archivelog was deleted.

I am taking twice a day an archivelog backup, copy the previous one and then delete them for disk space.
The archivelog that is is being asked for recovery of the Datafile was deleted so what can I do?
Re: Error while recovering a Datafile [message #352734 is a reply to message #352727] Thu, 09 October 2008 04:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You lose your file.
Now you have to take it offline, export what you can from other files in the tablespace, drop the tablespace and reconstruct your data.

Regards
Michel
Re: Error while recovering a Datafile [message #352738 is a reply to message #352727] Thu, 09 October 2008 04:56 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Mimas wrote on Thu, 09 October 2008 04:56

I am taking twice a day an archivelog backup, copy the previous one and then delete them for disk space.
The archivelog that is is being asked for recovery of the Datafile was deleted so what can I do?

Is this to say that you do actually have a backup of the specific archivelog? Was the archivelog deleted from it's original location AND the backup location?
Re: Error while recovering a Datafile [message #352739 is a reply to message #352738] Thu, 09 October 2008 04:59 Go to previous messageGo to next message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
ebrian wrote on Thu, 09 October 2008 12:56
Mimas wrote on Thu, 09 October 2008 04:56

I am taking twice a day an archivelog backup, copy the previous one and then delete them for disk space.
The archivelog that is is being asked for recovery of the Datafile was deleted so what can I do?

Is this to say that you do actually have a backup of the specific archivelog? Was the archivelog deleted from it's original location AND the backup location?


Yes the archivelog was deleted from the path where the copy was.
Re: Error while recovering a Datafile [message #352742 is a reply to message #352739] Thu, 09 October 2008 05:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you have no more copy of archived log somewhere, you can't recover.
If you have one somewhere restore it.

Regards
Michel
Re: Error while recovering a Datafile [message #352743 is a reply to message #352739] Thu, 09 October 2008 05:04 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Not much you can do without the required archive log. This just being the example tablespace, do you really need anything in this tablespace? If not, just drop and recreate the tablespace and objects.
Re: Error while recovering a Datafile [message #352745 is a reply to message #352720] Thu, 09 October 2008 05:19 Go to previous message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
Thank you
Previous Topic: Legato Storage Manager error
Next Topic: Problem with RMAN script.
Goto Forum:
  


Current Time: Sun Dec 11 02:07:19 CST 2016

Total time taken to generate the page: 0.09708 seconds