Oracle Takes A Very Long Time Or Slow To Start After SAP Backup On Solaris / ZFS (Doc ID 1075171.1)

Last updated on DECEMBER 15, 2016

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.
***Checked for relevance on 15-Dec-2016***

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
...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms