BP Key: 144 Status: AVAILABLE Compressed: NO Tag: TAG20140216T191455
Piece Name: /u01/flash_recovery_area/WILSON/autobackup/2014_02_16/o1_mf_s_839704495_9j17flq9_.bkp
SPFILE Included: Modification time: 16-FEB-14
SPFILE db_unique_name: WILSON
Control File Included: Ckp SCN: 5398809 Ckp time: 16-FEB-14
3、误操作过程
当前时间，我们通过logseq编号进行表示。
SQL> select sequence#, status from v$log;
SEQUENCE# STATUS
---------- ----------------
502 INACTIVE
503 CURRENT
501 INACTIVE
SQL> create table t tablespace TSPTIPTBL as select * from dba_objects;
Table created
SQL> alter system switch logfile;
System altered
SQL> select sequence#, status from v$log;
SEQUENCE# STATUS
---------- ----------------
502 INACTIVE
503 ACTIVE
504 CURRENT
切换日志，到下一个日志对象中出现误操作。
SQL> alter system switch logfile;
System altered
SQL> select sequence#, status from v$log;
SEQUENCE# STATUS
---------- ----------------
505 CURRENT
503 ACTIVE
504 ACTIVE
SQL> truncate table t;
Table truncated
SQL> alter system switch logfile;
System altered
SQL> select sequence#, status from v$log;
SEQUENCE# STATUS
---------- ----------------
505 ACTIVE
506 CURRENT
504 ACTIVE
恢复目标是将表空间TSPTIPTBL恢复到logseq=504位置上。