Re: RMAN TSPITR / AUM Problem
- From: Charlotte Hammond <charlottejanehammond@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 20 Jul 2005 09:25:44 -0700 (PDT)
Hi All,
Problem solved... (it was my fault!)
I'm not 100% sure I understand what was happening but
the jist of it was that there was a trigger which
audited all database DDL to a log table in the USERS
tablespace. Because this tablespace was offline the
trigger was failing.
Now, I have seen this trigger fail before for various
reasons - normally however it just prevents the
logging (but permits the underlying DDL to complete)
happening but it seems as if somehow it was also
preventing the undo segments becoming active at all.
If I set _system_trig_enabled=FALSE in the auxiliary
instance then it all works nicely.
I might look into the exact details of why the trigger
was preventing the undo segments coming online if I
have more time, but most likely I'll just have to
remember to set this parameter if I have a similar
situation in future.
Charlotte
--- Charlotte Hammond <charlottejanehammond@xxxxxxxxx>
wrote:
> 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
>
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
--
//www.freelists.org/webpage/oracle-l
Other related posts:
