Sunday, April 01, 2007

RMAN-06019: rman does not recognizes plugged in tablespaces

Background: Migrating HP-UX oracle 9i to 10g On Linux RH4 using transportable tablespace to ASM
The last step in this kind of procedure is to transfer the database file from filesystem to ASM using RMAN:

RMAN> backup as copy tablespace TRANS_TEST format '+DATA/psdwh/datafile';

Starting backup at 22-FEB-07
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=136 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/22/2007 14:06:40
RMAN-20202: tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "TRANS_TEST"

It looks like we are hit bug#2656503 (not published on Metalink) which states that rman does not recognizes plugged in tablespaces
until they are put in 'read write' mode.


SQL> alter tablespace TRANS_TEST online;
SQL> alter tabelspace TRANS_TEST read write;
SQL> alter tabelspace TRANS_TEST read only;
SQL> alter tablespace TRANS_TEST offline;

Repeat the rman 'backup as copy'.

1 comment:

Praveen said...

Great Catch man... When we get this error..a strange but obvious thing to notice is that dba_data_files view shows the tablespace_name whereas report schema rman command doesn't list the tablespace...