OraFAQ Forum: Server Administration » standby database goes down.

Home » RDBMS Server » Server Administration » standby database goes down. (oracle,8.1.7, unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

standby database goes down. [message #309606]

Fri, 28 March 2008 02:28

daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india

Member

Hi Experts,
My standby goes down. when i reviewed the alert log.
I got this error.

ORA-16038: log 9 sequence# 407431 cannot be archived
ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-00312: online log 9 thread 1: '/orapu11/redo09prod_a.log'
ORA-00312: online log 9 thread 1: '/orapu08/redo09prod_b.log'
ARCH: Connecting to console port...

ORA-16038: log 9 sequence# 407431 cannot be archived
ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-00312: online log 9 thread 1: '/orapu11/redo09prod_a.log'
ORA-00312: online log 9 thread 1: '/orapu08/redo09prod_b.log'
ARC1: Beginning to archive log# 9 seq# 407431

Could somebody please explain me the reason behind this.

Thanks,
Daniesh

Report message to a moderator

Re: standby database goes down. [message #309646 is a reply to message #309606]

Fri, 28 March 2008 05:25

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Quote:

ORA-01089: immediate shutdown in progress - no operations are permitted

Someone issued a SHUTDOWN IMMEDIATE command.

Report message to a moderator

Re: standby database goes down. [message #309649 is a reply to message #309646]

Fri, 28 March 2008 05:30

daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india

Member

nobody issued "shutdown immediate" statement.
you can there are 3-4 errors .
i think that will help.

Thanks,
Daniesh

Report message to a moderator

Re: standby database goes down. [message #309651 is a reply to message #309649]

Fri, 28 March 2008 05:33

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

The other errors will not shut the DB down.

01089, 00000, "immediate shutdown in progress - no operations are permitted"
// *Cause:  The SHUTDOWN IMMEDIATE command was used to shut down
//         a running ORACLE instance, so your operations have been
//         terminated.
// *Action: Wait for the instance to be restarted, or contact your DBA.

Report message to a moderator

Re: standby database goes down. [message #309823 is a reply to message #309649]

Sat, 29 March 2008 01:32

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Did you check "STATUS" column in v$instance?

Report message to a moderator

Previous Topic:	Droping a datafile from UNDO Segment
Next Topic:	moving an user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 19:23:35 CDT 2024