RE: Tablespace recover from RMAN cold backup.

A tablespace cannot be recovered directly from an intentional drop of a
tablespace. If the datafile AMT_1.dbf was earased or corrupted then the
tablespace can be recovered but once it is dropped from the database, the
database doesn't know anything about it. If the database is in archive log
mode you could recover the database to a point in time before the drop
assuming you know when that happened and you have a backup from before that
point in time and all the archive logs between the backup and the point in
time in which you want to recover.

RMAN-20202: tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name " AMT_1"

Kindly let me know what am I missing.

Thanks and Regards,
Nisha Mohan.A

CAUTION - Disclaimer ***************** This e-mail contains
PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the
addressee(s). If you are not the intended recipient, please notify the
sender by e-mail and delete the original message. Further, you are not to
copy, disclose, or distribute this e-mail or its contents to any other
person and any such actions are unlawful. This e-mail may contain viruses.
Infosys has taken every reasonable precaution to minimize this risk, but is
not liable for any damage you may sustain as a result of any virus in this
e-mail. You should carry out your own virus checks before opening the e-mail
or attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***