Database Administration (MOSC)

MOSC Banner

Patch install and SYSAUX tablespace fixes

edited Sep 20, 2013 6:54AM in Database Administration (MOSC) 6 commentsAnswered ✓

RDBMS 11.2.0.2, Linux 64-bit.

I just applied patch 14373728 and all went well despite nagging errors in the postinstall.script ("SET PAGESIZE 0", and the role "gather_system_statistics" conflicts with another user or role name).

Probably shot myself in the foot dropping the "gather_system_statistics" role and re-running postinstall.sql, but that is yet to be seen.

So, I have 40 million rows to clear out of WRI$_OPSTAT_HISTGRM_HISTORY, and I'd like a "best practice".  Here's what I think will work:

1) take a metadata only datapump export of the SYSAUX tablespace

2) shutdown the database and bring it up restricted

3) offline the tablespace, and move the datafiles out of the way

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center