Re: Recovery problem

I have a script that does something very similar with 8.1.7. Before I run the script I restore my hot backup data files, archived redo logs, and control file. The script looks something like this.

    set autorecovery on
    startup mount
    recover database using backup controlfile until cancel     alter database open resetlogs;

The recover statement stops with an error message when it can't find the next archived redo log, so I don't have to issue the cancel.

"Foggy" <sjefke12_at_hotmail.com> wrote in message news:f78e018a.0209190537.382fce88_at_posting.google.com...
> Hi Richard,
>
> This is the background of my problem:
> i have a hot backup of a production database, that I need to restore
> to a stand-alone server. On that server, queries will be executed to
> feed a data warehouse. The database should be updated every night,
> and the idea was that it would be the cheapest solution to use the
> hot backup of the production server, and recover it on the stand-alone
> server.
> This should be done automatically by a script, but until now I only
> could do an incomplete recovery with 'recover until cancel', and I
> can not automate the answer that this command requires (the word
> 'cancel').
> So, I want to do a complete recovery, but Oracle keeps asking for
> logfiles until the current online redo logfile is reached. And the
> only possibility that remains is an incomplete recovery :(
> Replication requires to much maintenance in case of database changes,
> and can not be used (not my choice, but I have to live with it).
>
> Is there a solution for my problem, or is there another way to do what i
have to do?
>
> Regards, Johan
>
> Oracle 8.0.5 on WinNT 4
>
>
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:<riei9.35685$g9.101622_at_newsfeeds.bigpond.com>...
> > Hi Foggy,
> >
> > I don't know the full history here so forgive me.
> >
> > Are you trying to perform a complete recovery by restoring a hot backup
> > datafile that you haven't yet taken out of backup mode ?
> >
> > If so, interesting, but assuming the backup has completed, then there
> > shouldn't be a problem (the fact they're still recorded in backup mode
> > should make no difference). Restore the datafile(s), recover the
datafile,
> > tablespace, database (depending on what you're trying to recover) and it
> > will simply apply all the required redo logs, resync the buggers and
you're
> > away.
> >
> > You should get the magical Media Recovery Complete message and be able
to
> > put the datafile, tablespace or database online.
> >
> > That's *if* I understood your question correctly.
> >
> > Good Luck
> >
> > Richard
> > "Foggy" <sjefke12_at_hotmail.com> wrote in message
> > news:f78e018a.0209182229.19bcf093_at_posting.google.com...
> > > Hi,
> > >
> > > when i restore the datafiles from a hot backup, then the backup status
> > > of these
> > > files is shown as 'ACTIVE' before starting a recovery. Is this normal?
> > > The problem is that I can't do a complete recovery, and some of you
> > > suggested
> > > that the datafiles could still be in backup mode. I cannot set the
> > > datafiles to 'end backup', because Oracle says that recovery is
> > > required.
> > > What am I doing wrong?
> > >
> > > Regards, Johan
Received on Thu Sep 19 2002 - 13:40:28 CDT