|
–通过回收站找回删除表
–查看回收站是否开启
select value from V
p
a
r
a
m
e
t
e
r
w
h
e
r
e
n
a
m
e
=
′
r
e
c
y
c
l
e
b
i
n
′
;
?
?
删除表
d
r
o
p
t
a
b
l
e
s
k
s
j
s
h
a
d
o
w
t
w
o
?
?
查询回收站删除的表
s
e
l
e
c
t
?
f
r
o
m
u
s
e
r
r
e
c
y
c
l
e
b
i
n
w
h
e
r
e
o
r
i
g
i
n
a
l
n
a
m
e
=
′
S
K
S
J
S
H
A
D
O
W
T
W
O
′
;
?
?
恢复删除的表
f
l
a
s
h
b
a
c
k
t
a
b
l
e
"
B
I
N
parameter where name = 'recyclebin'; --删除表 drop table sksj_shadow_two --查询回收站删除的表 select * from user_recyclebin where original_name='SKSJ_SHADOW_TWO'; --恢复删除的表 flashback table "BIN
parameterwherename=′recyclebin′;??删除表droptablesksjs?hadowt?wo??查询回收站删除的表select?fromuserr?ecyclebinwhereoriginaln?ame=′SKSJS?HADOWT?WO′;??恢复删除的表flashbacktable"BINWnGARoz0SJGry9zs+sAE/A==$0" to before drop;
和达梦数据库一样
–通过归档日志找回删除数据
1.查看日志，找出删除时间点最近的归档日志
select t.first_time,t.name from vKaTeX parse error: Double subscript at position 131: …h/arch1/31780_1_?906742008.log')…logmnr_contents t
where operation = ‘DELETE’
AND SEG_NAME = ‘SKSJ_SHADOW_TWO’;
5.终止归档日志分析
execute DBMS_LOGMNR.END_LOGMNR();
–查询删除数据的时间点的数据（也就是闪回至该时间点之前的数据）
select * from A as of timestamp to_timestamp(‘2016-02-25 17:10:00’, ‘yyyy-mm-dd hh24:mi:ss’);
|