!![Err] ORA-01555: 快照过旧: 回退段号 1 (名称为 "_SYSSMU1$") 过小如何解决??
1
连接别人机器上的ORACLE 10g 数据库时 执行了一段sql文: delete from Categories where categoryid>'25'
2
数据删除过多 想要恢复 , 然后上网上查找了如下
http://hi.baidu.com/hanbingxiaoshi/blog/item/fec90afab1c45912a9d3113c.html
3
按照文章文章后查询走到了:
declare
i int :=19265060;
begin
for i in 19265060..19271169 loop
insert into temp (scn) values (i);
update temp set count=(select count(*) from Categories as of scn i) where scn=i;
end loop;
end ;select count(*) from Categories as of scn 19269184;
这一步 查询条数 有了 是8K+
4 在执行恢复:
insert into Categories select * from Categories as of scn 19269185;时报错:
[SQL] insert into Categories select * from Categories as of scn 19269185[Err] ORA-01555: 快照过旧: 回退段号 1 (名称为 "_SYSSMU1$") 过小求助!
1
连接别人机器上的ORACLE 10g 数据库时 执行了一段sql文: delete from Categories where categoryid>'25'
2
数据删除过多 想要恢复 , 然后上网上查找了如下
http://hi.baidu.com/hanbingxiaoshi/blog/item/fec90afab1c45912a9d3113c.html
3
按照文章文章后查询走到了:
declare
i int :=19265060;
begin
for i in 19265060..19271169 loop
insert into temp (scn) values (i);
update temp set count=(select count(*) from Categories as of scn i) where scn=i;
end loop;
end ;select count(*) from Categories as of scn 19269184;
这一步 查询条数 有了 是8K+
4 在执行恢复:
insert into Categories select * from Categories as of scn 19269185;时报错:
[SQL] insert into Categories select * from Categories as of scn 19269185[Err] ORA-01555: 快照过旧: 回退段号 1 (名称为 "_SYSSMU1$") 过小求助!
逐步调整时间试一下
是怎么调???
的意思是查出sysdate-1/1400这个时间点下的emp表数据