hung db
From: MJ Mody <emjay.mody_at_gmail.com>
Date: Fri, 8 Jan 2016 19:03:56 -0600
Message-Id: <EB7505A6-542A-4093-BF82-208CC764FEF7_at_gmail.com>
Nothing like ringing in a new year than with a hung database. In this case, running 11.2.0.3 EE with ASO/TDE on W2K8-R2 with last CPU. From what is known, external backups (tape writes) were taking place in backup software, both rman and data pump (the .dmp files were created early in the evening). Additionally, nightly EOD processing was also taking place.
Date: Fri, 8 Jan 2016 19:03:56 -0600
Message-Id: <EB7505A6-542A-4093-BF82-208CC764FEF7_at_gmail.com>
Nothing like ringing in a new year than with a hung database. In this case, running 11.2.0.3 EE with ASO/TDE on W2K8-R2 with last CPU. From what is known, external backups (tape writes) were taking place in backup software, both rman and data pump (the .dmp files were created early in the evening). Additionally, nightly EOD processing was also taking place.
Performed a server reboot to bring the database online. Point of concern is from 9pm onwards, until the database came back online (~1:30am), there is no entries in the alert log.
Feel free to share if anyone has come across this or have some words of wisdom for troubleshooting and remediation.
Thank you in advance.
Best
MJ--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jan 09 2016 - 02:03:56 CET