OraFAQ Forum: Backup & Recovery » Error while recovering a Datafile

Home » RDBMS Server » Backup & Recovery » Error while recovering a Datafile

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error while recovering a Datafile [message #352720]

Thu, 09 October 2008 02:58

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

Report message to a moderator

Re: Error while recovering a Datafile [message #352721 is a reply to message #352720]

Thu, 09 October 2008 03:25

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Restore the missing archived log(s).

Regards
Michel

Report message to a moderator

Re: Error while recovering a Datafile [message #352727 is a reply to message #352720]

Thu, 09 October 2008 03:56

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?

Report message to a moderator

Re: Error while recovering a Datafile [message #352734 is a reply to message #352727]

Thu, 09 October 2008 04:29

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Error while recovering a Datafile [message #352738 is a reply to message #352727]

Thu, 09 October 2008 04:56

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?

Report message to a moderator

Re: Error while recovering a Datafile [message #352739 is a reply to message #352738]

Thu, 09 October 2008 04:59

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

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.

Report message to a moderator

Re: Error while recovering a Datafile [message #352742 is a reply to message #352739]

Thu, 09 October 2008 05:03

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Error while recovering a Datafile [message #352743 is a reply to message #352739]

Thu, 09 October 2008 05:04

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.

Report message to a moderator

Re: Error while recovering a Datafile [message #352745 is a reply to message #352720]

Thu, 09 October 2008 05:19

Mimas
Messages: 40
Registered: September 2008
Location: Athens

Member

Thank you

Report message to a moderator

Previous Topic:	Legato Storage Manager error
Next Topic:	Problem with RMAN script.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 13:08:40 CST 2024