Hi,
Try this:
Edit the dbstart script by adding the condition in the section where the
startup command is there:
if [ "$ORACLE_SID" = 'stdby_sid' ] ; then
startup mount;
alter database recover managed standby database using current
logfile disconnect;
else
startup
fi
Don't forget to add the "else" part, otherwise other databases will not
startup.
Thanks & Regards,
Manash Partim Baruah
MS-LCS| DBA| Tech Mahindra Ltd.
Sharda Center, 6th Floor Annex Building, Pune-4, India
www.techmahindra.com
-----Original Message-----
From: Solange Januzi Tanuz Maia
[mailto:oracledba-ezmlmshield-x94153497.[Email address protected]
Sent: Monday, March 31, 2008 8:58 PM
To: LazyDBA Discussion
Subject: ENC: ENC: Enterprise Manager 10G and dataguard
1) How to configure automatic STARTUP of my standby database in case
of reboot of the server?
I'm running under Red Hat AS5.
If I put "Y" in the definition of the sid in the ORATAB file the
dbstart executes a startup open and then the standby is opened in
READONLY MODE. So
I have to MANUALLY startup the standby with the following commands:
startup mount;
alter database recover managed standby database using current logfile
disconnect;
Any help would be appreciated.
Missao Cedro
Criar valor com tecidos e servicos de qualidade, contribuindo para o
sucesso dos nossos clientes.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
============================================================================================================================
Disclaimer:
This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.
============================================================================================================================
Oracle LazyDBA home page