RE: trying out recovery - solved

Rahul,

Whenever you are doing a point-in-time recovery (PITR) you must restore ALL datafiles from a backup taken prior to the PITR time. The exception is if you are performing the PITR simply to recover one or more tables, in which case you can restore just the system and rbs datafiles along with the datafiles for the tablespace(s) to which the table(s) belong (see doc 96197.1 on MetaLink). Oracle cannot roll a db or datafile back in time, recovery can only roll forward.

Whenever an incomplete recovery is performed you must open resetlogs. This is to prevent the unapplied redo from being applied. That's why it's important to take a backup after opening with resetlogs as the old backup is no longer valid.

BTW, I highly recommend the Oracle Press Backup & Recovery Handbook.

HTH,

• Anita
  • Rahul <rahul_at_ratelindo.co.id> wrote:
    > i was wrong at step# 2 & 8 , i must backup/restore
    > ALL DATA FILES
    > not just a single DB file !!, i think the resason
    > being the use of
    > RESETLOGS after this type of recovery (incomplete
    > media recovery)
    > to open a DB in RESETLOGS.
    >
    > can someone point to a doc which explains the
    > RESETLOGS AND NORESETLOGS
    > options ??
    >
    > TIA
    >
    > Rahul
    >
    >
    > > ----------
    > > From: William Beilstein[SMTP:BeilstWH_at_obg.com]
    > > Sent: 15 Mei 2000 19:31
    > > To: ORACLE-L_at_fatcity.com; rahul_at_ratelindo.co.id
    > > Subject: Re: trying out recovery
    > >
    > > Because it applied all the changes stored in the
    > redo logs including the drop command. What you want
    > is a point of time recovery. For example
    > >
    > > 1) shutdown DB
    > > 2) take a backup of a single datafile which makes
    > a tbs 'DATA1'
    > > 3) startup mount
    > > 4) issue 'alter db archivelog' and 'archive log
    > start'
    > > 5) create a table 'TAB' in tbs 'DATA1' and insert
    > some records and commit
    > > 6) drop the table 'TAB' at 05/15/00 @ 17:23
    > > 7) Issue 'alter database switch logfile'
    > > 8) shutdown, restore the backup datafile and
    > startup mount
    > > 9) issue 'recover database until time
    > '2000-05-13:17:22'' in SVRMGRL
    > >
    > > >>> Rahul <rahul_at_ratelindo.co.id> 05/15/00 05:44AM
    > >>>
    > > List (ora 7.2.3 AIX - new to recovery)
    > >
    > > trying out this recovery scenario on a test DB,
    > > to recover from a 'drop table'
    > >
    > > 1) shutdown DB
    > > 2) take a backup of a single datafile which makes
    > a tbs 'DATA1'
    > > 3) startup mount
    > > 4) issue 'alter db archivelog' and 'archive log
    > start'
    > > 5) create a table 'TAB' in tbs 'DATA1' and insert
    > some records and commit
    > > 6) drop the table 'TAB'
    > > 7) Issue 'alter database switch logfile'
    > > 8) shutdown, restore the backup datafile and
    > startup mount
    > > 9) issue 'recover' in SVRMGRL
    > >
    > > alter all the logs are applied, i open the DB but
    > CANNOT FIND THE TABLE 'TAB' !!!
    > >
    > > why ?
    > >
    > > TIA
    > > Rahul
    > >
    > >
    > >
    > >
    > >
    > > --
    > > Author: Rahul
    > > INET: rahul_at_ratelindo.co.id
    > >
    > > Fat City Network Services -- (858) 538-5051
    > FAX: (858) 538-5051
    > > San Diego, California -- Public Internet
    > access / Mailing Lists
    > >
    >

    ---

    
    > > To REMOVE yourself from this mailing list, send an
    > E-Mail message
    > > to: ListGuru_at_fatcity.com (note EXACT spelling of
    > 'ListGuru') and in
    > > the message BODY, include a line containing: UNSUB
    > ORACLE-L
    > > (or the name of mailing list you want to be
    > removed from). You may
    > > also send the HELP command for other information
    > (like subscribing).
    > >
    > --
    > Author: Rahul
    > INET: rahul_at_ratelindo.co.id
    >
    > Fat City Network Services -- (858) 538-5051 FAX:
    > (858) 538-5051
    > San Diego, California -- Public Internet
    > access / Mailing Lists
    >

    ---

    
    > To REMOVE yourself from this mailing list, send an
    > E-Mail message
    > to: ListGuru_at_fatcity.com (note EXACT spelling of
    > 'ListGuru') and in
    > the message BODY, include a line containing: UNSUB
    > ORACLE-L
    > (or the name of mailing list you want to be removed
    > from). You may
    > also send the HELP command for other information
    > (like subscribing).