Re: standby database

From: Hanne Iren Midttun <hannem_at_tihlde.org>
Date: Fri, 24 Jan 2003 08:34:11 +0100
Message-ID: <Pine.LNX.4.21.0301240828460.9119-100000@colargol.tihlde.org>

Hi,
thanks, when I was reading my own question I saw it was really difficult to understand what I meant. I want to run the "recover managed standby database;" without having a terminal open agains the database all the time. Found this via google (from Pete Sharman. Thanks to you to :)

#!/bin/ksh

export ORACLE_SID=XX

nohup $ORACLE_HOME/bin/sqlplus "/ as sysdba"<<EOF>a.log 2>&1 & recover managed standby database;
EOF

regards Hanne

--
Hanne Midttun
http://www.tihlde.org/~hannem

On Thu, 23 Jan 2003, koert54 wrote:



> recover managed standby database disconnect ;

> 

> "Hanne Iren Midttun" <hannem_at_tihlde.org> wrote in message

> news:Pine.LNX.4.21.0301231329450.4655-100000_at_colargol.tihlde.org...

> > Hi,

> > I am running oracle 8.1.7.4 on AIX 3.4.

> > I have primary database running on host A, and a standby database running

> > on host B. I am trying to run a managed recovery mode.

> >

> > Everything seems to work fine, but I need to close the connection to the

> > Unix host. The problem is that the sql*plus command:

> > RECOVER MANAGED STANDBY DATABASE;

> > does not give me the oppertunety to do this :( I do not get the promp

> > back. cntr+c aborts the recovery mode.

> >

> > Does somebody knows how to do this? (I have to take my laptop with

> > me home! :)

> >

> > regard Hanne

> > --

> > Hanne Midttun

> > http://www.tihlde.org/~hannem

> >

> 

> 

>

Received on Fri Jan 24 2003 - 01:34:11 CST