OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » media recovery (10g v1, windows xp)

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

media recovery [message #404059]

Wed, 20 May 2009 04:13

tamannasweetest
Messages: 7
Registered: April 2009
Location: dehu road

Junior Member

hi all,
i am using oracle 10g v1 on xp

my database name is newtry and is in noarchive mode
i have yesterday nights backup.
i deleted my tablespace named sonu
now i want to restore it.

=> shutdown immediate
=> startup mount
=> restore database

RMAN> recover database;

Starting recover at 20-MAY-09
using channel ORA_DISK_1
using channel ORA_DISK_2

starting media recovery

unable to find archive log
archive log thread=1 sequence=62
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/20/2009 14:26:58
RMAN-06054: media recovery requesting unknown log: thread 1 seq 62 lowscn 778137

=> i am getting this error

=> and can i restore my database to last backup with these commands, or any additional steps are required.

thanks

Report message to a moderator

Re: media recovery [message #404070 is a reply to message #404059]

Wed, 20 May 2009 04:41

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

Senior Member
Account Moderator

You must have the archived logs available in order to be able to recover.

Regards
Michel

Report message to a moderator

Re: media recovery [message #404072 is a reply to message #404059]

Wed, 20 May 2009 04:45

tamannasweetest
Messages: 7
Registered: April 2009
Location: dehu road

Junior Member

no i dont have that.

but can u still tell me the steps to recover the database to yesterday night

Report message to a moderator

Re: media recovery [message #404075 is a reply to message #404072]

Wed, 20 May 2009 04:50

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

Senior Member
Account Moderator

You can't.
If you have taken a cold bakcup you just can restore the database at this step.
If not, you simply can't.

Regards
Michel

Report message to a moderator

Re: media recovery [message #404226 is a reply to message #404059]

Thu, 21 May 2009 00:50

tamannasweetest
Messages: 7
Registered: April 2009
Location: dehu road

Junior Member

hi all.

working on oracle 10g v1 , windows

i have taken full backup of my database but it is not showing in the backup

=> list backup of tablespace sonu;

could not translate tablespace sonu

can any one help me

because i have to recover my database till last night

Report message to a moderator

Re: media recovery [message #404259 is a reply to message #404226]

Thu, 21 May 2009 02:32

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

Senior Member
Account Moderator

Quote:

=> list backup of tablespace sonu;
could not translate tablespace sonu

And the previous message was, I bet:

Quote:

tablespace not found in the recovery catalog

Please post the whole stack.

Then you have no backup of your tablespace, then you can't restore it.

Regards
Michel

Report message to a moderator

Previous Topic:	Configuring retention policy not for archive logs
Next Topic:	creating backup script of 10g database in rhel4

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

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