BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
142 Full 1.33G DISK 00:02:52 16-FEB-14
BP Key: 142 Status: AVAILABLE Compressed: NO Tag: TAG20140216T191156
Piece Name: /u01/flash_recovery_area/WILSON/backupset/2014_02_16/o1_mf_nnndf_TAG20140216T191156_9j177yk1_.bkp
List of Datafiles in backup set 142
(篇幅原因,有省略……)
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
143 21.50K DISK 00:00:00 16-FEB-14
BP Key: 143 Status: AVAILABLE Compressed: NO Tag: TAG20140216T191454
Piece Name: /u01/flash_recovery_area/WILSON/backupset/2014_02_16/o1_mf_annnn_TAG20140216T191454_9j17fgd3_.bkp
List of Archived Logs in backup set 143
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 497 5398705 16-FEB-14 5398798 16-FEB-14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
144 Full 9.67M DISK 00:00:04 16-FEB-14
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位置上。