How to rebuild AUD$ [message #578549] |
Fri, 01 March 2013 03:04 |
|
appi
Messages: 3 Registered: March 2013 Location: Zurich
|
Junior Member |
|
|
Hi all
I just have one question regarding the table AUD$.
Here is the Szenario we have:
We just move the table AUD$ into a special tablespace and activate default Auditing on Production Databases.
Now we clone our databases with rman duplicate database to Test environments.
Customers does not want to duplicate the GB's of Auditing as well, so we think about to exclude teh AUDITING Tablespace from cloning.
But we guess its not possible to start DB without AUD$ table.
How can we proceed to "create" the table in e.g AUDITING Tablespace with maybe 10M size that Oracle will accept this table and work normally if the auditing is set to NONE in pfile/spfile of TEST Environment.
Is there any function to recreate the table aud$ ?
thanks in advance
Uwe
|
|
|
Re: How to rebuild AUD$ [message #578552 is a reply to message #578549] |
Fri, 01 March 2013 03:42 |
|
Michel Cadot
Messages: 68687 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Is there any function to recreate the table aud$ ?
No.
I think you have to ask Oracle support to get a valid answer on this point.
One option could be to save the sys.aud$ data somewhere (in another table for instance), truncate the table, duplicate your databases and remove the data to your sys.aud$ table.
In this case, why not periodically save the sys.aud$ to your own table and truncate the sys.aud$. this can be done by a job for instance, every hour. In this way, you can let sys.aud$ in SYSTEM tablespace and manage your own auditing table as you want, for instance excluding the tablespace that contains it.
Regards
Michel
[Updated on: Fri, 01 March 2013 03:43] Report message to a moderator
|
|
|
|
|
|
Re: How to rebuild AUD$ [message #578563 is a reply to message #578558] |
Fri, 01 March 2013 04:37 |
|
Michel Cadot
Messages: 68687 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You don't understand what I mean.
1/ You let SYS.AUD$ in SYSTEM tablespace
2/ You create your own audit table in AUDITING tablespace
3/ Every hour you move the data from sys.aud$ to your auditing table and truncate sys.aud$
There you have an (almost) empty sys.aud$ table and you can exclude your auditing table.
Regards
Michel
|
|
|