dbaseek
asked on
TRIED TO BACKUP TABLESPACE USING RMAN SHOWS ERROR
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
-------------------------- ----
SYSTEM
UNDOTBS1
SYSAUX
TEMP
RMAN> backup filesperset=2 tablespace SYSTEM,UNDOTBS1,SYSAUX,TEM P,objects;
Starting backup at 18-NOV-06
using channel ORA_DISK_1
RMAN-00571: ========================== ========== ========== ========== ===
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ========================== ========== ========== ========== ===
RMAN-03002: failure of backup command at 11/18/2006 00:56:59
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202: tablespace
not found in the recovery catalog
RMAN-06019: could not translate tablespace name "TEMP"
WHAT IS THE REASON FOR THIS ERROR??
TABLESPACE_NAME
--------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
RMAN> backup filesperset=2 tablespace SYSTEM,UNDOTBS1,SYSAUX,TEM
Starting backup at 18-NOV-06
using channel ORA_DISK_1
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
RMAN-03002: failure of backup command at 11/18/2006 00:56:59
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202: tablespace
not found in the recovery catalog
RMAN-06019: could not translate tablespace name "TEMP"
WHAT IS THE REASON FOR THIS ERROR??
You don't need to backup the TEMP tablespace, so remove that from the list of tablespaces to back up.
ASKER
how can i remove?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THANKS MAN
ASKER
RMAN> BACKUP FILESPERSET=2 TABLESPACE SYSTEM,UNDOTBS1,SYSAUX,TEM
Starting backup at 18-NOV-06
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
RMAN-03002: failure of backup command at 11/18/2006 01:05:14
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20020: database in
carnation not set
WHAT IS THE PROBLEM???CAN U HELP ME TO FIX THIS???