MIME-Version: 1.0
In-Reply-To: <96FC82DA2FD4354D9A8B8434B6E7003D209E59C9@COL0SGEM20.AD.DLA.MIL>
References: <96FC82DA2FD4354D9A8B8434B6E7003D209E59C9@COL0SGEM20.AD.DLA.MIL>
Date: Thu, 6 Jun 2013 20:53:35 +0200
Message-ID: <CAJ2-Qb8hXNGdbj-wziVCPNwgMgzLA5WjJKgdXvT9fV4huquH9A@mail.gmail.com>
Subject: Re: auto start a data guard physical standby Oracle 11.2
From: Ls Cheng <exriscer@gmail.com>
To: Tom.Terrian.ctr@dla.mil
Cc: Oracle Mailinglist <oracle-l@freelists.org>
Content-type: text/plain
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: exriscer@gmail.com

Hi
Any reason not use Data Guard in 11g? It works pretty good in 11g.

In ther other hand a few years ago I had to do a db startup script in Linux
for DG, the code is roughly following. If you are using RAC then use the
srvctl command you have mentioned.


start_db()
{
    # Parameter 1 -> Oracle SID
    ORACLE_SID=$1
    # Do not start oracle until the /u02/oradata fs is mounted
    if [ ! -d $ORADATA ]; then
        echo "$ORADATA not mounted..."
        return 1
    fi

    tmpfile='/tmp/oracle-init.tmp'
    dgfile='/tmp/oracle-dg.tmp'

    echo "startup mount" > $tmpfile
    echo "set pagesize 0" >> $tmpfile
    echo "select 'DB_ROLE:' || decode(DATABASE_ROLE, 'PRIMARY', 'FALSE',
'TRUE') from v\$database;" >> $tmpfile
    echo "quit" >> $tmpfile

    $SUBIT "export ORAENV_ASK=NO; export ORACLE_SID=$ORACLE_SID; .
/usr/local/bin/oraenv; sqlplus / as sysdba" < $tmpfile | tee -a $LOGFILE |
tee $dgfile > /dev/null

    result=$?

    if [ $result -ne 0 ]; then
        echo "Oracle DB did not mount..."
        return 1
    fi

    ISDG=`grep DB_ROLE $dgfile | awk -F":" '{ print $2 }'`
    if [ "$ISDG" == "FALSE" ]; then
        echo "alter database open;" > $tmpfile
        echo "quit" >> $tmpfile
    else
        echo "alter database recover managed standby database using current
logfile;" > $tmpfile
        echo "quit" >> $tmpfile
    fi

    $SUBIT "export ORAENV_ASK=NO; export ORACLE_SID=$ORACLE_SID; .
/usr/local/bin/oraenv; sqlplus / as sysdba" < $tmpfile >> $LOGFILE

    result=$?

    if [ $result -ne 0 ]; then
        #echo "Oracle DB did not start..."
        return 1
    else
        return 0
    fi
}

Regards


--
http://www.freelists.org/webpage/oracle-l