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 ? Received on Mon May 15 2000 - 03:29:11 CDT