Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: standby database

Re: standby database

From: koert54 <nospam_at_nospam.com>
Date: Fri, 24 Jan 2003 20:10:14 GMT
Message-ID: <G4hY9.4539$Jd.815@afrodite.telenet-ops.be>


Yeah - I also guess "recover managed standby database disconnect" is only valid for 9i

"Hanne Iren Midttun" <hannem_at_tihlde.org> wrote in message news:Pine.LNX.4.21.0301240828460.9119-100000_at_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 - 14:10:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US