RMAN TSPITR / AUM Problem

From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: Wed, 20 Jul 2005 04:29:05 -0700 (PDT)
Message-ID: <20050720112905.28822.qmail@web33102.mail.mud.yahoo.com>

Hi All,

I'm testing TSPITR using RMAN (9i) and get the following error during the export:

About to export Tablespace Point-in-time Recovery objects...

EXP-00008: ORACLE error 1552 encountered
ORA-01552: cannot use system rollback segment for
non-system tablespace 'USERS'
ORA-06512: at "SYS.DBMS_PITR", line 606
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

Any suggestions on what I'm missing here?

Further details on the test:

Both the target and auxiliary databases are using automatic undo:

SQL> show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_suppress_errors                 boolean     FALSE
undo_tablespace                      string      UNDO

The Undo tablespace seemed to get selected for duplication ok:

# make the controlfile point at the restored datafiles, then recover them
recover clone database tablespace "USERS", "SYSTEM", "UNDO";
alter clone database open resetlogs;

However none of the automatic undo segments in the auxiliary database are online:

SQL> select segment_name,status
2 from dba_rollback_segs
3 /

SEGMENT_NAME                   STATUS
------------------------------ ----------------
SYSTEM                         ONLINE


_SYSSMU1$                      OFFLINE

_SYSSMU2$                      OFFLINE

_SYSSMU3$                      OFFLINE

_SYSSMU4$                      OFFLINE

_SYSSMU5$                      OFFLINE

_SYSSMU6$                      OFFLINE

_SYSSMU7$                      OFFLINE

_SYSSMU8$                      OFFLINE

_SYSSMU9$                      OFFLINE

_SYSSMU10$                     OFFLINE

Many thanks in advance for any help,
Charlotte

Yahoo! Mail for Mobile
Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 20 2005 - 06:31:44 CDT