2009-07-24 TIPTOP

1)Oracle 删除表恢复

 

（1）select * from user_recyclebin where original_name='drop_test'

 

（2）flashback table drop_test to before drop

 

2)Oracle 删除记录恢复

 

DELETE FROM T1 WHERE ROW_NUM='9'

---回闪5分钟前记录
INSERT INTO T1 SELECT * FROM T1 AS OF TIMESTAMP SYSDATE-5/1440 WHERE ROW_NUM NOT IN (SELECT ROW_NUM FROM T1)

 

3)HP-UNIX losf 工具安装

 

（1）用FTP上传losf工具到服务器

 

        FTP:bin

        FTP:put losf工具路径

（2）用SAM安装losf工具

 

（3）设置root的path增加

 

 .profile增加path=/usr/local/bin