Home » RDBMS Server » Backup & Recovery » media recovery (10g v1, windows xp)
media recovery [message #404059] Wed, 20 May 2009 04:13 Go to next message
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
Re: media recovery [message #404070 is a reply to message #404059] Wed, 20 May 2009 04:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You must have the archived logs available in order to be able to recover.

Regards
Michel
Re: media recovery [message #404072 is a reply to message #404059] Wed, 20 May 2009 04:45 Go to previous messageGo to next message
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
Re: media recovery [message #404075 is a reply to message #404072] Wed, 20 May 2009 04:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: media recovery [message #404226 is a reply to message #404059] Thu, 21 May 2009 00:50 Go to previous messageGo to next message
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
Re: media recovery [message #404259 is a reply to message #404226] Thu, 21 May 2009 02:32 Go to previous message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Configuring retention policy not for archive logs
Next Topic: creating backup script of 10g database in rhel4
Goto Forum:
  


Current Time: Mon Dec 05 02:36:21 CST 2016

Total time taken to generate the page: 0.39718 seconds