Database Administration (MOSC)

MOSC Banner

Managing / Removing rotated in-use trace files not managed by ADRCI

edited Apr 5, 2019 10:35AM in Database Administration (MOSC) 4 commentsAnswered

Hi,

We've already written a script that does this. While the script does what it does, it is not really fool proof. All it does is search for the 'name' of the trace file that are in some kind of formatted filename and remove it, for example, am looking for test1_tt00_<nnn>.trc or test1_rfs_<nnn>.trc and then removing them every so often. This is because these files has grown so huge at some point to 20G that we didn't notice it is happening. Main reason it has gone to that size is we have max dump file size parameter set to unlimited

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