OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » RMAN-20202:

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

RMAN-20202: [message #74646]

Thu, 27 January 2005 04:28

arun
Messages: 67
Registered: January 2000

Member

Hi,

I've dropped a Tablespace, but I've got rman backup of this tablespace. When I tried to recover the same, Its erroring out as below. Kindly help me...

RMAN> run
2> {
3> allocate channel c1 type disk;
4> recover tablespace GE_RMAN;
5> }

starting full resync of recovery catalog
full resync complete
allocated channel: c1
channel c1: sid=13 devtype=DISK

Starting recover at 27-JAN-05
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/27/2005 08:10:27
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202: tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "GE_RMAN"

Thanks a lot
Arun

Report message to a moderator

Re: RMAN-20202: [message #74647 is a reply to message #74646]

Thu, 27 January 2005 07:21

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

first Make sure, you are trying to restore the right tablespace.. i.e check whether the tablespace is backed up and information is available in catalog.
Is the catalog in the same database being restored?
Else
You need to use TSPITR.

Report message to a moderator

Re: RMAN-20202: [message #74648 is a reply to message #74647]

Thu, 27 January 2005 08:29

arun
Messages: 67
Registered: January 2000

Member

Dear sir,

Yes , I'e rechecked TS name..its perfect, but catalog is not in same database.

Any suggestions please.

Thanks
Arun

Report message to a moderator

Re: RMAN-20202: [message #74649 is a reply to message #74648]

Thu, 27 January 2005 08:32

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You need to use TSPITR.
restore to some point in time before you dropped the tablespace and after you backed up~

Report message to a moderator

Re: RMAN-20202: [message #74650 is a reply to message #74648]

Thu, 27 January 2005 08:38

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please Ignore the previous message..i messed it.
Use TSPITR concept to restore.

timepoint 0-> your own business
timepoint 1-> you took a backup
timepoint 2-> tablespace is dropped.
and now at
timepoint 4-> restore to timepoint 0

Report message to a moderator

Previous Topic:	recovery in archive mode; no archived logs
Next Topic:	Can i take database backup from client machine

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 22:29:47 CST 2025