今天清理垃圾的时候不小心将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。