Home » Server Options » RAC & Failsafe » Startup sequence 10g RAC database with ASM? (Oracle 10.2.0.3.0 on AIX)
Startup sequence 10g RAC database with ASM? [message #573413] Fri, 28 December 2012 04:42 Go to next message
sysdba007
Messages: 28
Registered: November 2012
Junior Member
Hello

I want to restart a 10g database on ASM

Could you please let me know the startp and shutdown sequence?
I would like to shutdown everything including database, ASM and cluster and startup again

I read at various places but not sure of the sequence

For database DB with database instance DB01 and DB02 having ASM instances ASM01 and ASM02 on node1 and node2, I understand following would be the sequence

1)
Login as root on node1
cd $CRS_HOME/bin
./crsctl start crs        

2)
Login as root on node2
cd $CRS_HOME/bin
./crsctl start crs        

3)
login as oracle on node1
$ORACLE_HOME/bin/srvctl start nodeapps -n node1

4)
login as oracle on node2
$ORACLE_HOME/bin/srvctl start nodeapps -n node2

5)
login as oracle on node1
start ASM instance on node1
$ORACLE_HOME/bin/srvctl start asm01 -n node1

6)
login as oracle on node2
start ASM instance on node2
$ORACLE_HOME/bin/srvctl start asm02 -n node2

7)
Start oracle database (from any node)
$ORACLE_HOME/bin/srvctl start database -d DB

 
A. Could you please confirm if the above sequence is correct?
B. This sequence if corrrect, is same for 10g and 11g?
C. Is shutdown sequence exact reverse of the above?


Thank you

Regards
sysdba007
Re: Startup sequence 10g RAC database with ASM? [message #575367 is a reply to message #573413] Tue, 22 January 2013 09:49 Go to previous messageGo to next message
mkounalis
Messages: 147
Registered: October 2009
Location: Dallas, TX
Senior Member
Crs should start at system boot. Crs would then bring things up in the correct order for you. Why are you needing to do this manually?

[Updated on: Tue, 22 January 2013 09:50]

Report message to a moderator

Re: Startup sequence 10g RAC database with ASM? [message #600239 is a reply to message #575367] Mon, 04 November 2013 00:06 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

Shutdown and startup sequence in RAC.

1.shutdown database using srvctl command.

2.shutdown asm instance using srvctl.

3.stop crsctl

For startup

Just cluster startup will bring all databases and asm instance.

With Regards,

[Updated on: Mon, 04 November 2013 00:07]

Report message to a moderator

Re: Startup sequence 10g RAC database with ASM? [message #600244 is a reply to message #600239] Mon, 04 November 2013 01:15 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Even these tasks are commonly done alongwith the above mentioned steps -

Before shutdown :

Another point is to Backup/remove the Oracle cron and temporarily stop the Oracle Enterprise Management (OEM) alerts before the shutdown to avoid the obvious alerts else it would flood with a lot of alerts.

After startup :

1. Restore the above processes to enable monitoring on OEM and put the oracle cron back after startup.
2. To validate that the clustered resources are running, execute crsstat.sh
Re: Startup sequence 10g RAC database with ASM? [message #600246 is a reply to message #600244] Mon, 04 November 2013 01:50 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thats a valid points i would say that i have missed to add in startup and shutdown.

Quote:
Before shutdown :

Another point is to Backup/remove the Oracle cron


Can you tell me how to Backup/remove the Oracle cron and how to put the oracle cron back after startup and also would like to know why we need to do this as part of shutdown and startup?

Database used -- Oracle RAC 11gr2.

OS used --- RHL 6.4

Thank you

[Updated on: Mon, 04 November 2013 01:52]

Report message to a moderator

Re: Startup sequence 10g RAC database with ASM? [message #600247 is a reply to message #600246] Mon, 04 November 2013 03:14 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Jack14 wrote on Mon, 04 November 2013 13:20
Thats a valid points i would say that i have missed to add in startup and shutdown.

Quote:
Before shutdown :

Another point is to Backup/remove the Oracle cron


Can you tell me how to Backup/remove the Oracle cron and how to put the oracle cron back after startup


It's mostly/only applicable in scheduled maintenance as a pre-work.

Pre-work before shutdown :

1. Backup, Remove Cron,

    1. Go to Oracle directory : cd /opt/oracle
    2. crontab -l > crontab.backup
    3. crontab -r2. Set Blackout of OEM

2. Set Blackout of OEM

    1. emctl start blackout outage -nodeLevel

Post-work on all instances after startup :

1. Restore the crontab.


    1. Go to Oracle directory : cd /opt/oracle
    2. crontab crontab.backup
    3. crontab -l --> to validate

2. Stop the OEM Blackout

    1. emctl stop blackout outage


Regards,
Lalit
Re: Startup sequence 10g RAC database with ASM? [message #600256 is a reply to message #600247] Mon, 04 November 2013 08:30 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Lalit,

Thanks for your answers.

Quote:
crontab -r2. Set Blackout of OEM

Is it something typo ? Also would want to know why we need to backup oracle cron ?

Thanks

[Updated on: Mon, 04 November 2013 08:30]

Report message to a moderator

Re: Startup sequence 10g RAC database with ASM? [message #600280 is a reply to message #600256] Mon, 04 November 2013 11:10 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Yes it's a silly typo, I was using add numbered list tool to format and I overlooked at the typo. It should be :

crontab -r


Jack14 wrote on Mon, 04 November 2013 20:00
Also would want to know why we need to backup oracle cron ?


Depends on what is scheduled in Oracle crontab. I mentioned that it is usually done in scheduled maintenance. A lot of automated scripts are scheduled in crontab. Now I want to have a clean shutdown and startup. Since, I need to remove crontab before shutdown, obviously I have to take a backup before I remove it. And restore it after startup.

[Updated on: Thu, 06 March 2014 13:40] by Moderator

Report message to a moderator

Re: Startup sequence 10g RAC database with ASM? [message #600322 is a reply to message #600256] Mon, 04 November 2013 23:32 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thanks Lalit for your explanation..
Previous Topic: Verify failover testing
Next Topic: Stop user connections to database
Goto Forum:
  


Current Time: Thu Mar 28 15:56:32 CDT 2024