今天清理垃圾的时候不小心将oracle 的redo01-03.log 3个日志文件删除了,以下是解决方法,备注一下:
$ sqlplus /nolog
sql> conn as sysdba
sql> startup mount
sql> select group#,sequence#,archived,status from v$log;
sql> alter database clear logfile group 3;
sql> alter database open resetlogs;
sql> recover database until cancel;
sql> alter database open resetlogs;
sql> alert database open; ok。