Home » RDBMS Server » Server Administration » ASM with immediate shutdown (Oracle 10g,11g , Linux)
ASM with immediate shutdown [message #609994] Sat, 15 March 2014 08:58 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

There is one question asked in interview which i would like to share and verify answer with you.

There are 3 databases ORCL11,ORCL2,ORCL3 associated with ASM instance and when we do a shutdown immediate
in ASM instance which is in mount state , what will happen to other database ?

1. will other databases (ORCL11,ORCL2,ORCL3) will have a clean shutdown along ASM with shutdown immediate
or other databases will have improper shutdown along with ASM having immediate shutdown ?

Could someone provide answer to my question.

Thanks,

[Updated on: Sat, 15 March 2014 09:00]

Report message to a moderator

Re: ASM with immediate shutdown [message #609996 is a reply to message #609994] Sat, 15 March 2014 09:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://psoug.org/oraerror/ORA-15097.htm
Re: ASM with immediate shutdown [message #610005 is a reply to message #609994] Sat, 15 March 2014 10:25 Go to previous messageGo to next message
John Watson
Messages: 4400
Registered: January 2010
Location: Global Village
Senior Member
I cannot remember the details now, but the behaviour changes somewhere between release 10.1.x and release 11.2.x. You'll have to do your own tests, but in some releases the shutdown command is propagted from the ASM instance to the dependent RDBMS instances, and in others it is blocked.
Re: ASM with immediate shutdown [message #610031 is a reply to message #610005] Mon, 17 March 2014 00:33 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
John,

The link that Mahesh has provided has answers to my question but still as you said i am concern about the releases.

I am using Oracle 11.2.0.3.0

Mahesh,

Thanks for the link.

Regards,
Jack

[Updated on: Mon, 17 March 2014 00:40]

Report message to a moderator

Previous Topic: Small table consume too much tablespace
Next Topic: How to create a database (Oracle 10g)
Goto Forum:
  


Current Time: Tue Jul 29 00:07:16 CDT 2014

Total time taken to generate the page: 0.09484 seconds