Re: trying out recovery

The recovery that you performed is a complete recovery. In a full recovery situation, every DML (data manipulation language) and DDL (data definition language) statement issued, which includes your "DROP TABLE" statement WILL BE recovered.

To recover this sort of situation, you need to use a incomplete recovery
(either by time, cancel or SCN) to recover to the point before you issue the
"DROP TABLE" statement.
----- Original Message -----
From: Rahul <rahul_at_ratelindo.co.id>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, May 15, 2000 5:44 PM
Subject: trying out recovery

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).