RE: trying out recovery - solved

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).
Received on Mon May 15 2000 - 21:38:05 CDT