Common Trouble Solution--CASE NE…

scenario:

    database operates in ARCHIVELOG mode. User-managed consisten

t backups are performed every Sunday night.  

On Tuesday, client A drops a table at 8:00 a.m. as follows:  

SQL> DROP TABLE cust_ord PURGE;  

Table dropped.  

Client B executes a query at 9:00 a.m. on the same table as follows:  

SQL> SELECT * FROM cust_ord;  

SELECT * FROM cust_ord  

ERROR at line 1:  

ORA-00942: table or view does not exist  

Client B needs the dropped table and reports the problem to you.  

 which action should we take?  

Action: restore all the data files from last Sunday's backup and then perf

orm a time-based recovery  

   NOTE:表被删除，同时 purge 从 recycle bin 中，无法使用闪回来闪回表，只能基

于 scn 或时间的不完全恢复,因为是不完全恢复，必须基于数据库级，而且已经

知道时间要恢复的时间了,所以 recover all data files 基于时间的不完全恢复。