1 recover database until time "to_date('2024-05-28 14:00:00','yyyy-mm-dd hh24:mi:ss')"
如图:
2 执行 alter database open resetlogs;,报错
试过很多办法,修改redo,但依然报错,如图:
后来想到重做控制文件,如下:
sql>alter database backup controlfile to trace as '/home/oracle/con.trace';
sql>shutdown immediate
slq>startup nomount
sql>CREATE CONTROLFILE REUSE DATABASE "XXX" RESETLOGS FORCE LOGGING ARCHIVELOG
MAXLOGFILES 384
MAXLOGMEMBERS 3
&n