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

Home -> Community -> Usenet -> c.d.o.misc -> help recover archive redo data what am i missing?

help recover archive redo data what am i missing?

From: Joe gulla <jgulla_at_erols.com>
Date: Mon, 9 Nov 1998 15:21:36 -0500
Message-ID: <727j03$r1m$1@autumn.news.rcn.net>

    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 - 14:21:36 CST

Original text of this message

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