Re: recovering data from archive logs

From: John P. Higgins <jh33378_at_deere.com>
Date: Mon, 09 Nov 1998 16:42:52 -0600
Message-ID: <36476FEC.DCA57EEB@deere.com>

If you also restored the control files, Oracle will think the database is up-to-date.

The reason we keep multiple copies of the control file is that we want at least one to survive any crash. We do NOT want to restore the control files. We want to have the up-to-date control file so that Oracle can see that the data files are out-of-date.

There is a work-around:

recover database until cancel using backup controlfile

Now Oracle knows that the control file itself is out-of-date. Oracle begins applying logs in sequence. Since we gave it an old control file, Oracle has no idea when to stop recovering. So, when the last log file has been applied, we respond to the prompt with 'cancel'.

Joe gulla wrote:

    Unfortunatly I cannot get training so I' trying
to teach myself can someone tell me what I'm missing
here.
    I've got a database in archiving mode. I've done
a cold backup of all the database control parameter
logfile and password files. I deleted db  and restored
from backup to make sure procedure works.
paramerters log_archive_start=true,log_archive_dest=d\archivelogs,
log_archive_format=arch%S.log are set archiving is enabled.
    Now I execute or commit a bunch or transactions the archive logs do get
created 4 of them.
    I shutdown instance, destroy the database,restore cold backups, start up
the instance in effect to a point in time
before the archive logs.
   The recovery method I try is using  svrmgr23
        connect as sysdba,
        startup mount
        set autorecovery on
        issue recover database command
  it responds that database does not need recover and some
error codes. (now all parameters are still intack .
what am I missing ? how can I get data in archive logs into database

                    any help will be appreciated
                            Joe Gulla

  Received on Mon Nov 09 1998 - 16:42:52 CST