oracle database hanged while offline backup

[Former Member]

Hi,

While taking Offline+redolog backup through DB13 scheduled @midnight, database was not shutdown.DB was not allowing either to shutdown or startup,it was in hanged stage.Hence manually shutdown the server next morning.

We have Production on Oracle 9 + UX 11 + cluster.

In DB13 it showed loggs as

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2010-01-30 00.01.24

BR0307I Shutting down database instance P3P ...

BR0280I BRBACKUP time stamp: 2010-01-30 13.04.58

BR0308I Shutdown of database instance P3P successful

Kindly help me to identify and resolve issue.

Regards,

Sam

[Former Member]

Hi,

Can you post the information from the DB alert log around that time..

Mark

[Former Member]

hi,

Fri Jan 29 21:07:49 2010

ARC1: Evaluating archive log 22 thread 1 sequence 8050

ARC1: Beginning to archive log 22 thread 1 sequence 8050

Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/P3P/oraarch/P3Parch1_8050.dbf'

Fri Jan 29 21:08:06 2010

ARC1: Completed archiving log 22 thread 1 sequence 8050

Fri Jan 29 21:37:58 2010

Completed checkpoint up to RBA [0x1f73.2.10], SCN: 0x0000.0916cc2a

Sat Jan 30 00:01:26 2010

Shutting down instance: further logons disabled

Shutting down instance (immediate)

License high water mark = 36

Sat Jan 30 00:01:30 2010

ALTER DATABASE CLOSE NORMAL

Sat Jan 30 00:01:31 2010

SMON: disabling tx recovery

Sat Jan 30 00:03:11 2010

SMON: disabling cache recovery

Sat Jan 30 00:03:11 2010

Shutting down archive processes

Archiving is disabled

Sat Jan 30 00:03:11 2010

ARCH shutting down

ARC0: Archival stopped

Sat Jan 30 00:03:11 2010

ARCH shutting down

ARC1: Archival stopped

Sat Jan 30 00:03:12 2010

Thread 1 closed at log sequence 8051

Successful close of redo thread 1

Sat Jan 30 00:03:34 2010

Completed: ALTER DATABASE CLOSE NORMAL

Sat Jan 30 00:03:34 2010

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archiving is disabled

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

ARCH: Archiving is disabled

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Sat Jan 30 10:49:07 2010

Starting ORACLE instance (normal)

Sat Jan 30 11:03:07 2010

Starting ORACLE instance (normal)

Sat Jan 30 14:23:26 2010

Starting ORACLE instance (normal)

Sam

Edited by: sam_ramya on Feb 9, 2010 12:29 PM

[Former Member]

hi,

Completed: ALTER DATABASE CLOSE NORMAL
Sat Jan 30 00:03:34 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT

Your Database shutdown ok @ 00:03:34

What kernel / patch level f the brtools are you running..

Mark

[Former Member]

hi,

thx Mark..

Kernel 640, Patch 109 , BRBACKUP 6.40 (37)

Sam

[Former Member]

Hi,

I would upgrade you kernel and brtools they are rather old......

Mark

[Former Member]

hi,

thx Mark..

I have queries

1. why it was not allowing me to shutdown or startup database if it was properly shutdown in midnight

2. offline backup started after we manually halted the server.

3. It wasn't happned before.After 2 days offline backup was succesful.Same configuration of kernel and patch is maintained in DEV and QAS,but their offline backup newer failed in this manner.

thx for help.

Sam

[Former Member]

Hi,

Are you saying other servers are showing the same symptoms ???

Mark

[former_member524429]

Hi,

Please refer this [SAP Note 521264 - Hang situations|https://service.sap.com/sap/support/notes/521264] to get more information about the possible causes which lead to Oracle DB Hang up situation.

What your OS System Log is telling ?

Apply latest Oracle 9 Patches corresponding to your OS.

Regards,

Bhavik G. Shroff

[Former Member]

Hi,

thx Bhavik....

I checking with the note and finding out most possible reson for hang.

Pls clear me on 1 doubt..

Can it be related to cluster or network issue?

Regards,

Sam