Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Moving SYS.AUD$ unsupported?

RE: Moving SYS.AUD$ unsupported?

From: Steve Orr <sorr_at_arzoo.com>
Date: Tue, 16 Jan 2001 10:28:43 -0800
Message-Id: <10743.126818@fatcity.com>


Here's one explanation...
"The Oracle Migration Utility takes all non-SYSTEM rollback segments OFFLINE when it runs but in order to update a table outside the SYSTEM tablespace, a non-SYSTEM rollback segment must be used."

That doesn't concern me so much because one could move SYS.AUD$ back into system before a migration and still be in good graces with Support. What concernes me is the phrase, "...could cause problems with upgrades and backup/recovery scenarios." Is backup/recovery impacted in general or only in connection with migrations?

Steve Orr

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rachel Carmichael
Sent: Tuesday, January 16, 2001 8:51 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Moving SYS.AUD$ unsupported?

I understand, but according to my source in support, there is nothing wrong with moving the table.. at least not in earlier versions. My friend is going to do some more digging and get back to me on whether or not you can still move the table.

Rachel

>From: "Trassens, Christian" <CTrassens_at_uni2.es>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Moving SYS.AUD$ unsupported?
>Date: Tue, 16 Jan 2001 08:05:58 -0800
>
>I think that I have to explain myself more clearly. I had implemented
>auditory several times. However I had never move the table. I used to copy
>the records from it with a cron or job to another table in another tbsp.
>
>Regards.
>
> > -----Mensaje original-----
> > De: Rachel Carmichael [SMTP:carmichr_at_hotmail.com]
> > Enviado el: martes 16 de enero de 2001 15:25
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: RE: Moving SYS.AUD$ unsupported?
> >
> > the data is IN the table.... or is there a new feature of Oracle that
> > allows
> > you to have a table in one tablespace and the data within that table in
> > another tablespace that I hadn't heard of?
> >
> > I was at a site where we enabled auditing and did not move sys.aud$
> >
> > System tablespace filled and the database froze.
> >
> > Move the table. Or be very very careful of what auditing you enable and
> > monitor the hell out of it to make sure you are not eating up the system
> > tablespace space and not fragmenting it. 'Cause if you do that, well,
>you
> > either add another datafile or rebuild the database.
> >
> > I suppose you could just leave aud$ in the system tablespace and then
> > archive off the old data into a different table in a different
>tablespace
> > and then purge aud$ but that seems a bit convoluted to me.
> >
> >
> >
> >
> > >From: "Trassens, Christian" <CTrassens_at_uni2.es>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: RE: Moving SYS.AUD$ unsupported?
> > >Date: Tue, 16 Jan 2001 02:40:25 -0800
> > >
> > >Rachel,
> > >
> > >I never wondered about moving the table, only the data.
> > >
> > >Regards.
> > >
> > > > -----Mensaje original-----
> > > > De: Rachel Carmichael [SMTP:carmichr_at_hotmail.com]
> > > > Enviado el: martes 16 de enero de 2001 11:11
> > > > Para: Multiple recipients of list ORACLE-L
> > > > Asunto: RE: Moving SYS.AUD$ unsupported?
> > > >
> > > > in prior releases of Oracle, Support recommended that AUD$ be moved
> > out
> > >of
> > > >
> > > > the system tablespace. It was the ONLY table they sanctioned moving.
> > > >
> > > >
> > > >
> > > >
> > > > >From: "Trassens, Christian" <CTrassens_at_uni2.es>
> > > > >Reply-To: ORACLE-L_at_fatcity.com
> > > > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > > >Subject: RE: Moving SYS.AUD$ unsupported?
> > > > >Date: Tue, 16 Jan 2001 00:25:53 -0800
> > > > >
> > > > >Steve,
> > > > >
> > > > >You should never move any table of the dictionary in any release.
>And
> > > > that
> > > > >includes sys.aud$. However and maybe you are confused with those
> > > > procedures
> > > > >or scripts that keeps the data of sys.aud$ off the system tbsp.
> > > > >
> > > > >Regards.
> > > > >
> > > > > > -----Mensaje original-----
> > > > > > De: Steve Orr [SMTP:sorr_at_arzoo.com]
> > > > > > Enviado el: martes 16 de enero de 2001 3:05
> > > > > > Para: Multiple recipients of list ORACLE-L
> > > > > > Asunto: Moving SYS.AUD$ unsupported?
> > > > > >
> > > > > > I'm getting ready to set up some auditing and in the past I've
> > > > routinely
> > > > > > moved the SYS.AUD$ out of the system tablespace thinking it was
> > the
> > > > only
> > > > > > data dictionary table move supported by Oracle. But I just
> > stumbled
> > >on
> > > >
> > > > >the
> > > > > > following in the 8.1.6 Admin manual:
> > > > > >
> > > > > > "Note: Moving the SYS.AUD$ table out of the SYSTEM tablespace
> > > > > > is not supported because the Oracle code makes implicit
> > > > > > assumptions about the data dictionary tables such as SYS.AUD$,
> > > > > > which could cause problems with upgrades and backup/recovery
> > > > > > scenarios."
> > > > > >
> > > > > > Is this a documentation change reflecting a new Oracle policy?
> > Does
> > > > >anyone
> > > > > > know why Oracle made this change? What would be the
>ramifications
> > of
> > > > > > moving
> > > > > > the table?
> > > > > >
> > > > > > Steve Orr
> > > > > >
> > > > > > --
> > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
Received on Tue Jan 16 2001 - 12:28:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US