oracle 重设redo log 和倒入
重设redo log:
alter system set "_allow_resetlogs_corruption" = true scope = spfile;
recover database until cancel using bakcup controlfile;
alter database open resetlogs;
shutdown immediate;
startup mount;
alter database open resetlogs;
alter system reset "_allow_resetlogs_corruption" scope = spfile sid = '*'
导入:
Disable all constraints
Truncate all tables
imp milktest/milktest@gmtest file=DB10G_V1.dmp fromuser=milkvip touser=milktest ignore=y