Oracle Takes A Very Long Time Or Slow To Start After SAP Backup On Solaris / ZFS
(Doc ID 1075171.1)
Last updated on FEBRUARY 18, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.0. [Release 9.2 to 11.2]Information in this document applies to any platform.
Symptoms
Right after offline backup of SAP database completed, database startup takes a very long time to start.
A review of the alert.log, shows that the startup is taking a long time for both alter database mount and open to complete. However Oracle shutdown / startup is fine before SAP backup:
Thu Mar 4 14:33:28 2010 <----
Starting ORACLE instance (normal)
.....
Thu Mar 4 14:33:57 2010 <------
ALTER DATABASE MOUNT
Thu Mar 4 14:54:15 2010 <----------- Taking a long time to mount 21 minutes.
Setting recovery target incarnation to 1
Thu Mar 4 14:54:15 2010
Successful mount of redo thread 1, with mount id 2210562194
Thu Mar 4 14:54:15 2010
Database mounted in Exclusive Mode
Thu Mar 4 14:54:51 2010
Completed: ALTER DATABASE MOUNT
Thu Mar 4 14:54:51 2010
ALTER DATABASE OPEN
Thu Mar 4 14:54:51 2010
....
Thu Mar 4 14:58:57 2010 <---------------- Open about 25 mins.
Completed: ALTER DATABASE OPEN
...
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |