Skip to Main Content
  • Questions

  • Unified Audit Log Change Tablespace Location

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Tharmendran.

Asked: October 22, 2021 - 6:37 am UTC

Last updated: October 27, 2021 - 2:10 am UTC

Version: Oracle 19c

Viewed 1000+ times

You Asked

Hi Tom,

Is that we can changed the unified audit log tablespace from SYSAUX to standalone tablespace(example: TBS_AUDIT) online without restart the database? If yes, is that will be any impact by doing so?

and Connor said...

Yes there is an API for that

begin
  dbms_audit_mgmt.set_audit_trail_location(
    audit_trail_type => dbms_audit_mgmt.audit_trail_unified,
    audit_trail_location_value => 'NEW_TSPACE');
end;


Make sure the tablespace is large enough to contain the existing audit otherwise the routine will report an error before starting

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Performance impact

Tharmendran Sukumaran, October 26, 2021 - 6:52 am UTC

Hi Tom,
Thanks for the response. Is that while we changing the tablespace, the current audit logging can continue to log? If yes, is that will log into the new tablespace defined?
Connor McDonald
October 27, 2021 - 2:10 am UTC

That is my understanding, but I'd encourage you to test it before doing this in Production.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Security

All of the vital components for a secure database are covered in the Security guide.