i have create table
take back up
alter database open ;
sqlplus>connect scott/tiger ;
sqlplus> select * from scott.emp1 ;
Ora:00942 table or view does not exist
i also try to
alter database open resetlogs but it give following error
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
rman>restore database ;
rman> recover database ;
It will recover database till date/time if your db is in Archive log mode...
in your case you created that table and the then drop.. so at the end you have no table..
If you want to check some scenario then you can use point in time recovery . Recover database until time.. and you will get the desired result.
or use the same what i said in my previous reply.
Hope this help
what you have done is complete recovery. So the database opened without resetlog.
You before query.
If your backup is of night and your table droped in the morning then you can do as below,
1. restore database.
2. recover database until (cancel/scn/time). if you know the scn number before the table was dropped or time when it was dropped.
3. alter database open resetlogs. As it is an incomplete recovery.
Check this test case
SQL> create table TEST2 as select * from emp;
SQL> select count(*) from TEST2;
SQL> select TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS') from dual;
SQL> alter system switch logfile;
SQL> drop table TEST2 purge;
SQL> shu immediate
[oracle@vnode MYSHELL]$ rman target /
Recovery Manager: Release 126.96.36.199.0 - Production on Tue Sep 10 10:58:39 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: DDTEST (DBID=1667776968, not open)
set until time "to_date('2013 Sep 10 10:57','yyyy mon dd hh24:mi')";
alter database open resetlogs;
}2> 3> 4> 5> 6>
media recovery complete, elapsed time: 00:00:02
Finished recover at 10-SEP-13
SQL> set lin 200 pages 100
SQL> select count(*) from test2;