Home » RDBMS Server » Backup & Recovery » Cannot drop undotbs2 when restoring 10.2.0.4 rac db to 11.2.0.4 single instance db (11.2.0.4 SE, Redhat 7.3)
Cannot drop undotbs2 when restoring 10.2.0.4 rac db to 11.2.0.4 single instance db [message #667135] Sat, 09 December 2017 22:19 Go to previous message
juniordbanewbie
Messages: 244
Registered: April 2014
Senior Member
Dear all,

based on HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another Node
(Doc ID 415579.1)

Quote:


11) Now you can remove the undo tablespaces of other instances and create a new temporary tablespace to complete
the activity.
I'm supposed to drop other instances undo tablespace

SELECT param2.inst_id, inst.instance_number, inst.instance_name, param2.value, param2.issys_modifiable, param2.ordinal FROM gv$parameter2 param2 JOIN gv$instance inst ON inst.inst_id=param2.inst_id
  2  WHERE name='undo_tablespace';

   INST_ID INSTANCE_NUMBER INSTANCE_N VALUE      ISSYS_MODI    ORDINAL
---------- --------------- ---------- ---------- ---------- ----------
         1               1 svcrmdb    UNDOTBS1   IMMEDIATE           1

SYS@11.2.0.4 svcrmdb>
SYS@11.2.0.4 svcrmdb>select tablespace_name from dba_tablespaces where contents='UNDO' ORDER BY tablespace_name;

TABLESPACE_NAME
------------------------------
UNDOTBS1
UNDOTBS2




DROP TABLESPACE UNDOTBS2 INCLUDING CONTENTS AND DATAFILES
ORA-604 signalled during: DROP TABLESPACE UNDOTBS2 INCLUDING CONTENTS AND DATAFILES...
[orac

SYS@11.2.0.4 svcrmdb>DROP TABLESPACE UNDOTBS2 INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE UNDOTBS2 INCLUDING CONTENTS AND DATAFILES
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 
ORA-00942: table or view does not exist 

alert log shows the following:


DROP TABLESPACE UNDOTBS2 INCLUDING CONTENTS AND DATAFILES
ORA-604 signalled during: DROP TABLESPACE UNDOTBS2 INCLUDING CONTENTS AND DATAFILES...

how do i proceed from here?
thanks in advance
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Is there anyway that I can append dbid at the end of a controlfile trace
Next Topic: Can restoring backup from tape to disk help me to restore spilfw
Goto Forum:
  


Current Time: Mon Sep 21 01:57:16 CDT 2020