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 基于時間的不完全恢複。