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
SELECT
originating_timestamp,
message_text
FROM
sys.x$dbgalertext
WHERE
message_text LIKE '%Starting up%';
Grep The word “Instance shutdown complete” of Alert log file from Instance.
SELECT
originating_timestamp,
message_text
FROM
sys.x$dbgalertext
WHERE
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
Thank you
Osama mustafa
Like this:
Like Loading...
Related
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
Very helpfull thank you
LikeLike
Mustafa,Today I saw your blog, thanks for Your comments and for referring my blog.– Nassyam Basha
LikeLike
@Mesli : your welcome , and can back to me any time
LikeLike
Nassyam Basha Your welcome , no need to thanks , Hope to see you in Open World .
LikeLike
Osama,I do not have plans to attend OOW, it's long way for me. So you attending? All the best.
LikeLike
its the same here Nassyam , But it will be my first attending.
LikeLike
Great info!file tracking systemfile sharing
LikeLike
Thank you
LikeLike