History of Instance startup and shutdown
i want to have history of an oracle instance startup for last Six month
9/1/07 3:36 PM
8/31/07 9:25 PM
8/3/07 4:23 PM
7/28/07 10:26 AM
4/6/07 6:21 PM
3/28/07 8:34 PM
3/19/07 1:10 AM
3/16/07 12:48 PM
3/14/07 12:11 PM
can anybody help me in this regard?
look in your alert log, database doesnt store this time (unless you do)
Look for the '*.aud' files under $OH/rdbms/audit.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Where it says...
... please read "You can always create startup/shutdowndatabase triggers and populate your own activity-tracking table."
Originally Posted by PAVB
Sorry about the typo; what the user wants to track are startup/shutdown operations.
Last edited by PAVB; 09-10-2007 at 02:15 PM.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
you always get auditing files for sysdba logins, cant turn those off
Click Here to Expand Forum to Full Width