| Startup sequence 10g RAC database with ASM? [message #573413] |
Fri, 28 December 2012 04:42  |
 |
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 #600244 is a reply to message #600239] |
Mon, 04 November 2013 01:15  |
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 |
 |
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 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
Jack14 wrote on Mon, 04 November 2013 13:20Thats 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 #600280 is a reply to message #600256] |
Mon, 04 November 2013 11:10 |
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 :
Jack14 wrote on Mon, 04 November 2013 20:00Also 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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
