Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Enable Auditing in production & DR server.

Ken IJan 3 2013 — edited Jan 4 2013

Hi Gurus,

I have an issue regarding enable audit in DR server.

My oracle version is 9i with dataguard enabled.My requirement is to enable user level audit in PROD and DR server as well.Since DR is always in mount stage.

1)So how can I enable user level audit in DR Server?

2)As per my understanding when we enable audit in PROD database and not in DR database then more no. of logs will be generate in PROD,which will result in asynchronization of logs between Production & DR database.So how to avoid this one?

3)Is there any way to specify the size of user level audit?or any method or script to delete the old records?If so,can you provide me?

4)How long we need to do clean up of old data and how?

Thanks & Regards,
Meena

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 1 2013

Added on Jan 3 2013

#data-guard, #performance-availability

5 comments

682 views