Fy_Recover_Data是利用Oracle表扫描机制、数据嫁接机制恢复TRUNCATE或者损坏数据的工具包。由纯PLSQL编写。

 ---------------------------------------------------------------------------
  -- WWW.HelloDBA.COM                                                     ---
  -- Created By: Fuyuncat                                                 ---
  -- Created Date: 08/08/2012                                             ---
  -- Email: Fuyuncat@gmail.com                                            ---
  -- Copyright (c), 2014, WWW.HelloDBA.COM All rights reserved.           ---
  -- Latest Version: http://www.HelloDBA.com/download/FY_Recover_Data.zip ---
  --                                                                      ---
  -- Update Logs                                                          ---
  -- 15/08/2012, Fuyuncat:                                                ---
  --   1. Fixed Bug in Clean_Up_Ts (Not change TS status correctly)        ---
  --   2. Added Exception Handle when Restore Data                        ---
  --   3. Added Parameter in recover_table,                               ---
  --            to balance Fault Tolerance and Performance                ---
  --                                                                      ---
  -- 16/08/2012, Fuyuncat:                                                ---
  --   1. Enhanced corrupted block processing, get rows as possilbe       ---
  --                                                                      ---
  -- 17/08/2012, Fuyuncat:                                                ---
  --   1. Omit the LOB columns raised ORA-22922 exception                 ---
  --                                                                      ---
  -- 20/08/2012, Fuyuncat:                                                ---
  --   1. Omit the LOB columns via db link                                ---
  --                                                                      ---
  -- 22/08/2012, Fuyuncat:                                                ---
  --   1. Updated logging and tracing interface                           ---
  --                                                                      ---
  -- 19/02/2014, Fuyuncat:                                                ---
  --   1. Temp Restore and Recover tablespace & files                     ---
  --      will be created on temp folder                                  ---
  --   2. Handle tablespace has files located at diff folders             ---
  --   3. Handle tables on ASM                                            ---
  --                                                                      ---
  -- 05/03/2014, Fuyuncat:                                                ---
  --   1. Fixed bugs                                                      ---
  --   2. Use existing dirctory if applicable                             ---
  --   3. Recover data from offline files                                 ---
  ---------------------------------------------------------------------------