Usually I'd suspect an out-of-memory situation. The scenario reminds me of a
case I had where the backup software (Tivoli, I think), would use Windows
shadow copy to execute an RMAN backup. The shadow copy process never exited and
after a (large) number of backups the Oracle process memory was exhausted and
the database hang. From memory that was also W2K8R2/11.2.0.3. I believe there
was a bug in the Oracle shadow copy interface.
You did check the Windows Event Logs (Application and System) I presume?
Hth,
Tony
On 09/01/16 11:03, MJ Mody wrote:
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--
//www.freelists.org/webpage/oracle-l