How to restore tablespace from backup
607981Nov 12 2007 — edited Nov 12 2007Dear all,
I need to restore my deleted tablespace from its backup. I backuped that tablespace with RMAN without catalog option. I connected the RMAN by the following way.
/home/oracle/db/bin/rman target / nocatalog
When I restoring the tablespace the following error occurs:
RMAN> run {
2> allocate channel ch1 type disk format '/disk6/backup/tek_backup/tek_bak1101';
3> restore tablespace tek_data;
4> }
Starting restore at 12-NOV-07
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/12/2007 17:13:48
RMAN-20202: tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "tek_data"
Please help