oracle中ORA-01219错误的解决方法
来源:青年人(Qnr.Cn) 2009-11-24 20:07:30
造成的原因是log被损坏。
cmd -> sqlplus
SQL> select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
1 86 NO INACTIVE
2 87 NO INVALIDATED
3 85 NO INACTIVE
alter database clear logfile group 1;
alter database clear logfile group 2;
alter database clear logfile group 3;
shutdown immediate;
startup mount;
SQL> select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
1 88 NO CURRENT
2 0 NO UNUSED
3 0 NO UNUSED
alter database clear logfile group 1;
alter database clear unarchived logfile group 1;
alter database clear logfile group 2;
alter database clear unarchived logfile group 2;
alter database clear logfile group 3;
alter database clear unarchived logfile group 3;
转载于:https://blog.51cto.com/longithome/1726487