| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN TSPITR / AUM Problem
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
> 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-lReceived on Wed Jul 20 2005 - 11:27:40 CDT
 |
 |