Incomplete Recovery through RMAN

SQL> create table t (id number(3));

SQL> set time on;

15:36:16 SQL> insert into t values (101);

15:36:19 SQL> insert into t values (102);

15:36:21 SQL> insert into t values (103);

15:36:27 SQL> insert into t values (104);

15:36:29 SQL> insert into t values (105);

15:36:33 SQL> select * from t;

15:36:36 SQL> commit;

>>>>> export ORACLE_SID=orcl

>>>>> rman target /

RMAN> delete backup; RMAN> backup database;

15:36:48 SQL> insert into t values (106);

15:38:22 SQL> insert into t values (107);

15:38:25 SQL> insert into t values (108);

15:38:29 SQL> insert into t values (109);

15:38:31 SQL> commit;

15:38:34 SQL> alter system checkpoint;

15:38:38 SQL> alter system flush buffer_cache;

15:38:42 SQL> commit;

15:39:17 SQL> drop table t purge;

15:39:32 SQL> select * from t;

RMAN> run2> {3> shutdown abort;4> startup mount;5> set until time "to_date('30-10-2012 15:38:31','DD-MM-RRRR HH24:MI:SS')";6> restore database;7> recover database;8> sql 'alter database open resetlogs';9> }

15:59:24 SQL> conn / as sysdba

15:59:32 SQL> select * from t;