Re: trying out recovery

From: William Beilstein <BeilstWH_at_obg.com>
Date: Mon, 15 May 2000 08:31:52 -0400
Message-Id: <10498.105637@fatcity.com>

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'=20
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)=20

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'=20
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

--=20
Author: Rahul
  INET: rahul_at_ratelindo.co.id=20

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 - 07:31:52 CDT