OraFAQ Forum: Data Guard » to start and stop a standby database on server startup

Home » Server Options » Data Guard » to start and stop a standby database on server startup (Oracle 9i R2, Linux)

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

to start and stop a standby database on server startup [message #336136]

Fri, 25 July 2008 00:10

sajut
Messages: 69
Registered: January 2007

Member

Dear All

I have a test standby database setup, which I have to shutdown every evening and start again in the morning. I use the following method for this
to startup

Code: [Select all] [Show/ hide]

   sqlplus '/as sysdba'
     startup nomount
     alter database mount standby database
     alter database recover managed standby database disconnect from session;

and to shutdown

Code: [Select all] [Show/ hide]

    sqlplus '/as sysdba'
    alter database recover managed standby database cancel;
    shutdown;

Is there any way I can automate these two processes

Thanks in advance

Saju

Report message to a moderator

Re: to start and stop a standby database on server startup [message #336149 is a reply to message #336136]

Fri, 25 July 2008 00:48

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Write a script and put it in the crontab?

Regards
Michel

Report message to a moderator

Re: to start and stop a standby database on server startup [message #336183 is a reply to message #336149]

Fri, 25 July 2008 02:20

sajut
Messages: 69
Registered: January 2007

Member

Thanks for the hint. I could do this using the following script
for startup

Code: [Select all] [Show/ hide]

#!/bin/bash
ORA_HOME="/opt/oracle/920"
ORA_OWNER="oracle"
SQLCMD="sqlplus '/as sysdba'"
LOGFILE="strt.log"
cat startup.sql | su - $ORA_OWNER  -c "$SQLCMD" > $LOGFILE

startup.sql

Code: [Select all] [Show/ hide]

startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect from session;

and for shutdown

Code: [Select all] [Show/ hide]

#!/bin/bash
ORA_HOME="/opt/oracle/920"
ORA_OWNER="oracle"
SQLCMD="sqlplus '/as sysdba'"
LOGFILE="sht.log"
cat shutdown.sql | su - $ORA_OWNER  -c "$SQLCMD" > $LOGFILE

shutdown.sql

Code: [Select all] [Show/ hide]

alter database recover managed standby database cancel;
shutdown;
exit

Report message to a moderator

Re: to start and stop a standby database on server startup [message #336189 is a reply to message #336183]

Fri, 25 July 2008 02:29

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to explicitly set ORACLE_HOME and ORACLE_SID.
Don't "su" in your script, put the script in oracle crontab not root one then you just have to call "sqlplus '/ as sysdba' @startup"

Regards
Michel

Report message to a moderator

Re: to start and stop a standby database on server startup [message #336547 is a reply to message #336189]

Mon, 28 July 2008 02:02

sajut
Messages: 69
Registered: January 2007

Member

Thanks Michel for your advice. But, if I put these scripts as cron entries for user oracle, how will it execute at system boot and shutdown?. If I am right, cron executes at preset timings and not at system startup and system shutdown. That is why I put these scripts in /etc/init.d/rc.n (n stands for runlevel).

Saju

Report message to a moderator

Re: to start and stop a standby database on server startup [message #336555 is a reply to message #336547]

Mon, 28 July 2008 02:20

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

, how will it execute at system boot and shutdown?

This was not your original qyestion.
Different question, different answer.

Regards
Michel

Report message to a moderator

Previous Topic:	Physical Standby Database problems
Next Topic:	About Data Guard

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 08:40:59 CDT 2025