oracle中ORA-01219错误的解决方法
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 NOINACTIVE
2 87 NOINVALIDATED
3 85 NOINACTIVE
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 NOCURRENT
2 0 NOUNUSED
3 0 NOUNUSED
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;
页:
[1]