Archive

Archive for the ‘oracle’ Category

使用logmnr找回数据

November 23rd, 2010 No comments

应用程序的误删除了线上的一条数据,需要恢复

删除时间:2010-11-08 00:11:21

1.首先考虑使用oracle的flashback query

select *
from users

as of scn
timestamp_to_scn(to_timestam[……]

Read more

Categories: oracle Tags: