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: RECOVER AUTOMATIC STANDBY DATABASE; Script question

Re: RECOVER AUTOMATIC STANDBY DATABASE; Script question

From: Ton <76434.1353_at_compuserve.com>
Date: 3 Mar 2004 07:02:09 -0800
Message-ID: <4477604.0403030702.126d5bfc@posting.google.com>


Sorry Nial...... for not responding. WIN NT Oracle 8i 8.1.7.4 I appreciate your advice .....

I tried the following:

" alter database recover automatic standby database until cancel; " " alter database recover cancel; "

The database still hangs after the " automatic recover " command waiting for the log file which is not available yet. Can only continue the script by the manual " cancel " and that is what I want to prevent. It has to run unattended.

You told in an earlier mail that it is not hanging in your environment. How is this possible?
Regards,

      
      Ton

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:<4044eda8$0$10131$cc9e4d1f_at_news.dial.pipex.com>...
> did you get anywhere?
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************
> <ITAPORT06> wrote in message news:403be261.17591775_at_news.hccnet.nl...
> > Thanks will test it tomorrow and will come back with the result.
> >
> > Sybrand I was not sure with your " NOT Possible " reply if undertood
> > my goal well (maybe you did)
> >
> > In short terms I want to give the CANCEL in the script as a answer for
> > RECOVER AUTOMATIC STANDBY DATABASE command so the script can continue
> > to set the dastabase into the " Standby Managed " mode after it has
> > applied the manual shipped log files.
> >
> > Thanks
> >
> >
> >
> >
> >
Received on Wed Mar 03 2004 - 09:02:09 CST

Original text of this message

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