Home » RDBMS Server » Server Administration » standby database goes down. (oracle,8.1.7, unix)
standby database goes down. [message #309606] Fri, 28 March 2008 02:28 Go to next message
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
Re: standby database goes down. [message #309646 is a reply to message #309606] Fri, 28 March 2008 05:25 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Quote:
ORA-01089: immediate shutdown in progress - no operations are permitted


Someone issued a SHUTDOWN IMMEDIATE command.
Re: standby database goes down. [message #309649 is a reply to message #309646] Fri, 28 March 2008 05:30 Go to previous messageGo to next message
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
Re: standby database goes down. [message #309651 is a reply to message #309649] Fri, 28 March 2008 05:33 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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.
Re: standby database goes down. [message #309823 is a reply to message #309649] Sat, 29 March 2008 01:32 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Did you check "STATUS" column in v$instance?
Previous Topic: Droping a datafile from UNDO Segment
Next Topic: moving an user
Goto Forum:
  


Current Time: Fri Dec 02 12:24:16 CST 2016

Total time taken to generate the page: 0.15560 seconds