First i would thank CKPT for this amazing article
that post in his blog .
Instead of reviewing whole alert log file for any Particular information, We can search using that key word from X$DBGALERTEXT Table.
Grep The word “Starting Up” of Alert log file from Instance.
col ORIGINATING_TIMESTAMP for a40
col MESSAGE_TEXT for a80
set linesize 500
message_text LIKE '%Starting up%';
Grep The word “Instance shutdown complete” of Alert log file from Instance.
message_text LIKE '%Instance shutdown complete%';
again thank you CKPT for this article since its useful for all DBA’s , you can check CKPT Blog From the above link
Published by Osama Mustafa
Osama considered as one of the leaders in Cloud technology, DevOps and database in the Middle-East. I have more than ten years of experience within the industry. moreover, certfied 4x AWS , 4x Azure and 6x OCI, have also obtained database certifications for multiple providers.
In addition to having experience with Oracle database and Oracle products, such as middle-ware, OID, OAM and OIM, I have gained substantial knowledge with different databases.
Currently, I am architecting and implementing Cloud and DevOps. On top of that, I'm providing solutions for companies that allow them to implement the solutions and to follow the best practices.
View all posts by Osama Mustafa
8 thoughts on “Tracking Alert Log file by x$dbgalertext”
Very helpfull thank you
Mustafa,Today I saw your blog, thanks for Your comments and for referring my blog.– Nassyam Basha
@Mesli : your welcome , and can back to me any time
Nassyam Basha Your welcome , no need to thanks , Hope to see you in Open World .
Osama,I do not have plans to attend OOW, it's long way for me. So you attending? All the best.
its the same here Nassyam , But it will be my first attending.
Great info!file tracking systemfile sharing