使用RMAN进行表空间TSPITR自动恢复(2)

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位置上。

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/ffa3f245ca4067f13ad50a558fa56de6.html