Home » RDBMS Server » Backup & Recovery » Offline Backup (oracle 10.2.0.1)
Offline Backup [message #396963] Wed, 08 April 2009 08:57 Go to next message
padhuoracle
Messages: 26
Registered: March 2009
Location: Chennai
Junior Member
Hi All,

Offline backup of X database is scheduled using Brbackup(3rd party tool) The script automatically shutdown the database , oracle files are backed up and database will be started. But last offline backup failed. Please find the alert log and trace file errors.

alert log:
Sat Apr 04 01:00:21 2009
Shutting down instance: further logons disabled
Sat Apr 04 01:00:21 2009
Stopping background process CJQ0
Sat Apr 04 01:00:21 2009
Stopping background process QMNC
Sat Apr 04 01:00:22 2009
Background process QMNC not dead after 150 seconds
Sat Apr 04 01:00:22 2009
Stopping background process MMNL
Sat Apr 04 01:00:24 2009
Background process MMNL not dead after 10 seconds
Sat Apr 04 01:00:24 2009
Stopping background process MMON
Sat Apr 04 01:00:25 2009
Background process MMON not dead after 30 seconds
Sat Apr 04 01:00:25 2009
Shutting down instance (immediate)
License high water mark = 231
Sat Apr 04 01:00:25 2009
Stopping Job queue slave processes, flags = 7
Sat Apr 04 01:00:25 2009
Job queue slave processes stopped
Sat Apr 04 01:05:24 2009
Active call for process 6500 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
SHUTDOWN: waiting for active calls to complete.
Sat Apr 04 01:07:48 2009
Incremental checkpoint up to RBA [0x121f1.8fc6.0], current log tail at RBA [0x121f1.8fc8.0]
Sat Apr 04 01:19:34 2009
MMNL absent for 1203 secs; Foregrounds taking over
Sat Apr 04 01:37:48 2009
Incremental checkpoint up to RBA [0x121f1.9018.0], current log tail at RBA [0x121f1.901b.0]
Sat Apr 04 02:00:24 2009
SHUTDOWN: Active sessions prevent database close operation


Trace file entries:

Dump file g:\oracle\p01\saptrace\usertrace\p01_ora_5728.trc
Sat Apr 04 01:00:22 2009
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V5.2 Service Pack 2
CPU : 16 - type 8664, 4 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:53937M/65532M, Ph+PgF:148785M/162225M
Instance name: p01

Redo thread mounted by this instance: 1

Oracle process number: 129

Windows thread id: 5728, image: ORACLE.EXE (SHAD)


*** ACTION NAME:() 2009-04-04 01:00:22.799
*** MODULE NAME:(fssvr.exe) 2009-04-04 01:00:22.799
*** SERVICE NAME:(SYS$USERS) 2009-04-04 01:00:22.799
*** SESSION ID:(1502.34513) 2009-04-04 01:00:22.799
*** 2009-04-04 01:00:22.799
Dumping diagnostic information for QMNC:
OS tid = 8996
Memory (Avail/Total): Ph:53937M/65532M, Ph+PgF:148785M/162225M

ERROR: thread 8996 is not alive
*** 2009-04-04 01:00:22.908
*** 2009-04-04 01:00:23.908
Dumping diagnostic information for MMNL:
OS tid = 8868
Memory (Avail/Total): Ph:53938M/65532M, Ph+PgF:148787M/162225M

ERROR: thread 8868 is not alive
*** 2009-04-04 01:00:24.018
*** 2009-04-04 01:00:25.018
Dumping diagnostic information for MMON:
OS tid = 5456
Memory (Avail/Total): Ph:53940M/65532M, Ph+PgF:148791M/162225M

ERROR: thread 5456 is not alive
*** 2009-04-04 01:00:25.127
*** 2009-04-04 01:05:24.123
SHUTDOWN: waiting for active calls to complete.
*** 2009-04-04 01:10:24.119
SHUTDOWN: waiting for active calls to complete.
*** 2009-04-04 01:15:24.115
SHUTDOWN: waiting for active calls to complete.
*** 2009-04-04 01:20:24.112
SHUTDOWN: waiting for active calls to complete.
*** 2009-04-04 01:25:24.108
SHUTDOWN: waiting for active calls to complete.
*** 2009-04-04 01:30:24.104
SHUTDOWN: waiting for active calls to complete.
*** 2009-04-04 01:35:24.100
SHUTDOWN: waiting for active calls to complete.
*** 2009-04-04 01:40:24.096
SHUTDOWN: waiting for active calls to complete.
*** 2009-04-04 01:45:24.092
SHUTDOWN: waiting for active calls to complete.
*** 2009-04-04 01:50:24.088
SHUTDOWN: waiting for active calls to complete.
*** 2009-04-04 01:55:24.085
SHUTDOWN: waiting for active calls to complete.


The oracle database and application are running in windows cluster.

I Kindly request somebody to help me in finding the actual problem.

Regards,
padhu.

Report message to a moderator

Re: Offline Backup [message #396965 is a reply to message #396963] Wed, 08 April 2009 09:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
There is no problem Oracle is just "waiting for active calls to complete".

Regards
Michel

Report message to a moderator

Re: Offline Backup [message #396966 is a reply to message #396965] Wed, 08 April 2009 09:09 Go to previous messageGo to next message
padhuoracle
Messages: 26
Registered: March 2009
Location: Chennai
Junior Member
Hi Michel,

Active calls in the sense what...

Due to that backup automation unable to shut down the database, what may the exact problem or solution for that.

padhu

Report message to a moderator

Re: Offline Backup [message #396972 is a reply to message #396966] Wed, 08 April 2009 09:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Something is still "alive" in the database and keeping it busy.
Seems your tool trying to do a clean shutdown.
Try again when there is no activity. It is not a problem. Just expected behavior.

[Updated on: Wed, 08 April 2009 09:27]

Report message to a moderator

Re: Offline Backup [message #396993 is a reply to message #396966] Wed, 08 April 2009 10:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
padhuoracle wrote on Wed, 08 April 2009 16:09
Hi Michel,

Active calls in the sense what...

Due to that backup automation unable to shut down the database, what may the exact problem or solution for that.

padhu

If you made a "normal" shutdown, Oracle waits everyone disconnects.
If you made an "immediate" shutdown, Oracle waits all transactions end (possibly currently rolling them back).

Regards
Michel

Report message to a moderator

Re: Offline Backup [message #397007 is a reply to message #396993] Wed, 08 April 2009 10:42 Go to previous messageGo to next message
padhuoracle
Messages: 26
Registered: March 2009
Location: Chennai
Junior Member
Hi all,

Okie ..

thanks for replying.



regards,
padhu.

Report message to a moderator

Re: Offline Backup [message #397011 is a reply to message #397007] Wed, 08 April 2009 11:03 Go to previous messageGo to next message
padhuoracle
Messages: 26
Registered: March 2009
Location: Chennai
Junior Member
Hi,

Is it possible to find the active call(session) which is not allowed to shutdown the database at the time backup now?

regards,
padhu

Report message to a moderator

Re: Offline Backup [message #397025 is a reply to message #397011] Wed, 08 April 2009 12:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Check
1/ v$session, only sessions with status='ACTIVE' if shutdown immediate
2/ v$transaction, all of them

Regards
Michel

Report message to a moderator

Re: Offline Backup [message #397030 is a reply to message #397025] Wed, 08 April 2009 12:16 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member
Hello Mr Michel,

Padhu already executed "shutdown" command; I think now there is no way to connect database (using sys also).

Only option need to wait or asking to close all session or need to fire abort command.

Please correct me.

Babu

[Updated on: Wed, 08 April 2009 12:17]

Report message to a moderator

Re: Offline Backup [message #397034 is a reply to message #397030] Wed, 08 April 2009 12:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You're right if he wants to follow the shutting down, he has to open 2 SYS sessions, one to execute shutdown and the other one to follow the process (if shutdown normal, in case of shutdown immediate the second session will be killed soon).

Regards
Michel

Report message to a moderator

Re: Offline Backup [message #397036 is a reply to message #397034] Wed, 08 April 2009 12:30 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Thanks Mr Mic

Babu

Report message to a moderator

Re: Offline Backup [message #397209 is a reply to message #397036] Thu, 09 April 2009 07:42 Go to previous messageGo to next message
padhuoracle
Messages: 26
Registered: March 2009
Location: Chennai
Junior Member
Hi All,

Is there any other way to find session or process or transaction performed at that time of scheduled backup, which didnt allow shutdown of database.

your reply would be helpful in preparing the Root cause analysis.

regards,
padhu

Report message to a moderator

Re: Offline Backup [message #397250 is a reply to message #397209] Thu, 09 April 2009 10:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You may rephrase the same question any number of times you want.
Did you read any of previous responses?
Root cause is your application is trying to shutdown it down cleanly.
Any active user / process will hold the shutdown until the job is done.
Instead of worrying what to do after the shutdown was issued, You have to check for active sessions before you shutdown.
The methods are hinted by Michel.

Report message to a moderator

Re: Offline Backup [message #397260 is a reply to message #397250] Thu, 09 April 2009 10:53 Go to previous message
padhuoracle
Messages: 26
Registered: March 2009
Location: Chennai
Junior Member

thanks.

Ok, i had read the previous responses. last question which i asked is to find the exact session or process. It is an unattended backup, scheduled by another DBA(Diff vendor).

Finally Here i just asked to prepare the Root cause analysis alone.

I am happy to receive the quick responses from you all.thanks a lot.

regards,
padhu

Report message to a moderator

Previous Topic: Restore from prod to test
Next Topic: when i am trying to import files in ora9i, I am getting the following error.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 07:21:46 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.