Home » Server Options » Data Guard » dbstart script for standby database (oracle 10.2.0.3, LINUX REDHAT 4.0)
dbstart script for standby database [message #339519] Thu, 07 August 2008 14:22 Go to next message
leahchow
Messages: 11
Registered: June 2005
Junior Member
I have a Linux box which has two oracle instances, one is standby database. I want to modify $ORACLE_HOME/bin/dbstart script, link it with /etc/init.d/dbora script to startup oracle automatically when rebooting.

I added some lines in the dbstart script, like this:

if test $STATUS -eq 1 ; then
if [ -e $SPFILE -o -e $SPFILE1 -o -e $PFILE ] ; then
case $VERSION in
"6") sqldba command=startup ;;
"internal") $SQLDBA <<EOF
connect internal
startup
EOF
;;
*)
if [ "$ORACLE_SID" = 'teststby' ] ; then
$SQLDBA <<EOF
connect / as sysdba
startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect;
EOF
else
$SQLDBA <<EOF
connect / as sysdba
startup
EOF
fi
;;
esac


I just added the startup standby part, both instances couldn't be started up anymore.

Could someone help me? I didn't make changes in DBORA file.

Thanks
Leah
Re: dbstart script for standby database [message #339530 is a reply to message #339519] Thu, 07 August 2008 15:24 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

> both instances couldn't be started up anymore.

My car won't go.
Tell me how to make my car go.
Previous Topic: remote standby database behind firewall
Next Topic: problem in opening standby database
Goto Forum:
  


Current Time: Thu Mar 28 14:11:11 CDT 2024