Home » RDBMS Server » Backup & Recovery » RMAN-20202:
RMAN-20202: [message #74646] Thu, 27 January 2005 04:28 Go to next message
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
Re: RMAN-20202: [message #74647 is a reply to message #74646] Thu, 27 January 2005 07:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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.
Re: RMAN-20202: [message #74648 is a reply to message #74647] Thu, 27 January 2005 08:29 Go to previous messageGo to next message
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
Re: RMAN-20202: [message #74649 is a reply to message #74648] Thu, 27 January 2005 08:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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~
Re: RMAN-20202: [message #74650 is a reply to message #74648] Thu, 27 January 2005 08:38 Go to previous message
Mahesh Rajendran
Messages: 10707
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
Previous Topic: recovery in archive mode; no archived logs
Next Topic: Can i take database backup from client machine
Goto Forum:
  


Current Time: Thu Mar 28 06:01:29 CDT 2024