Oracle-L: RE: Correct method of auto starting standby db

From: Ross Collado <Ross.Collado_at_techpac.com>
Date: Thu, 31 Jul 2003 07:24:28 -0800
Message-ID: <F001.005C7FCF.20030731072428@fatcity.com>

Hi,

What version of Oracle and OS platform you're using? The document you read refers to an 8i db so I assume you are in 8i. In our Solaris box with 8i on it, I created a shell script like so:

#!/bin/ksh
sqlplus -s /nolog <<!
Connect sys/*** as sysdba
recover managed standby database ;
exit
!

Then from the Unix prompt I run this script using nohup, eg:

$ nohup ./rcv_mng.sh > /dev/null 2>&1 &

Logging out of the session doesn't affect the script at all. It'll just keep running in the background until you either kill the session or cancel it from within another sqlplus window.

HTH
Ross

-----Original Message-----
Sent: Friday, 1 August 2003 12:54 AM
To: Multiple recipients of list ORACLE-L

All,

I have a question of how to auto start a standby database. IOW, it seems the logs are only applies if I issue the command Recover managed standby database;

With thatcommand, the logs are applied, however, if I (or someone else) exits the cmd window the process stops

So, how can I set this up to be automated?

I need to keep the database in this state.... (I must be missing the obivious)

Sqlplus /nolog
Connect sys/*** as sysdba
Startup mount;
Alter databse mount standby database;

Recover managed standby database;

I used this doc as a base for my initSID.ora files and dosnt seem to mention the starting up on the db
http://www.oracle-base.com/Articles/8i/StandbyDatabase.asp

Thanks!
bob

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Bob Metelsky
INET: bmetelsky_at_cps92.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ross Collado
INET: Ross.Collado_at_techpac.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------