Oracle系统查询很慢或索引慢 数据库清理日志

系统查询很慢或索引慢

 

Enter user-name: conn /as sysdba

Enter password:

3、打开数据库

SQL> alter database open;

alter database open

4、查日志

SQL> select group#,sequence#,archived,status from v$log;

 

    GROUP#  SEQUENCE# ARC STATUS

---------- ---------- --- ----------------

         1       4911 NO  INACTIVE

         2       4912 NO  INACTIVE

         3       4913 NO  CURRENT

 

根据显示的1、2、3分别清理日志

SQL> alter database clear unarchived logfile group 1;

Database altered.

SQL> alter database clear unarchived logfile group 2;

Database altered.

 

SQL> alter database clear unarchived logfile group 3;

alter database clear unarchived logfile group 3

*

ERROR at line 1:

ORA-01624: log 3 needed for crash recovery of instance orcl (thread 1)

ORA-00312: online log 3 thread 1:

'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG'