Hi to all,
i'm trying to perform test of backup/recovery of a tablespace in 11.2 with recovery catalog.
After the full backup, i check the backup:
RMAN> list backup of datafile 12;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2705082 Full 1004.25M SBT_TAPE 00:01:30 17-OCT-12
BP Key: 2705086 Status: AVAILABLE Compressed: NO Tag: MYDB FULLONBACKUP
Handle: BACKUP_FULL_t796913156_s52_p1 Media: 14942
List of Datafiles in backup set 2705082
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
12 Full 716785 17-OCT-12 +DATA01/mydb/datafile/usersnew.771.796911757
After dropped the tablespace (including contents and datafiles), i try to restore the tablespace.
RMAN> run {
allocate channel ch1 type 'SBT_TAPE' PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo)';
recover tablespace USERS;
restore tablespace USERS;
release channel ch1;
}
starting full resync of recovery catalog
full resync complete
allocated channel: ch1
channel ch1: SID=218 instance=MYDB device type=SBT_TAPE
channel ch1: Data Protection for Oracle: version 5.5.2.0
Starting recover at 17-OCT-12
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/17/2012 12:50:44
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202: Tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "USERS"
Why?
Edited by: 842366 on 17-ott-2012 4.04