oracle归档日志清理

SQL>startup mount;
ORACLE 例程已经启动。

TotalSystem Global Area  835104768 bytes
FixedSize                 2217952 bytes
VariableSize            637536288 bytes
Database Buffers         188743680 bytes
RedoBuffers               6606848 bytes
数据库装载完毕。
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-03113: 通信通道的文件结尾
进程 ID: 4272
会话 ID: 125 序列号:5

SQL>conn ' / as sysdba'
已连接到空闲例程。
SQL> startup mount
ORACLE 例程已经启动。

TotalSystem Global Area  835104768 bytes
FixedSize                 2217952 bytes
VariableSize            637536288 bytes
Database Buffers         188743680 bytes
RedoBuffers               6606848 bytes
数据库装载完毕。
SQL> select * from v$log;

   GROUP#    THREAD#  SEQUENCE#     BYTES  BLOCKSIZE    MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS          FIRST_CHANGE# FIRST_TIME     NEXT_CHANGE# NEXT_TIME
---------------- ------------- -------------- ------------ --------------
        1         1         97  52428800        512         1 NO
INACTIVE             12980317 07-9月-10         12988303 07-9月 -10

        3         1         99  52428800       512          1 NO
CURRENT              12991762 07-9月-10       2.8147E+14

        2         1         98   52428800       512          1 NO
INACTIVE             12988303 07-9月-10         12991762 07-9月 -10

SQL> alter database open resetlogs;
alter database open resetlogs
*
第 1 行出现错误:
ORA-01139: RESETLOGS 选项仅在不完全数据库恢复后有效

SQL> recover database until time '2010-09-09 1:45:02';
完成介质恢复。
SQL> alter database open resetlogs;

数据库已更改。

SQL>shutdown
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。

TotalSystem Global Area  835104768 bytes
FixedSize                 2217952 bytes
VariableSize            637536288 bytes
Database Buffers         188743680 bytes
RedoBuffers               6606848 bytes
数据库装载完毕。
数据库已经打开。
SQL>

————————————————————————————————————————————

然后删除log

[oracle@db1 ~]$ rman target /
Recovery Manager: Release 10.1.0.5.0 - Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
connected to target database: URPDB(DBID=2772226681)
RMAN> 
RMAN>delete archivelog all; 
RMAN>exit
[oracle@db1 ~]$ sqlplus /nolog
SQL*Plus: Release 10.1.0.5.0 - Production on ThuNov 29 13:39:50 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> SELECT space_limit/1024/1024/1024 AS"Quota_G",space_used/1024/1024 AS"Used_M",space_used/space_limit*100"Used_%",space_reclaimable AS reclaimable,number_of_files AS filesFROM v$recovery_file_dest ;
Quota_G Used_M Used_% RECLAIMABLE FILES
---------- ---------- ---------- ---------------------
20 0 0 0 0
SQL> 
嘿嘿，都清除了

  ————————————————————————————————————————————

 

重启实例

SQL> conn /as sysdba

Connected.

SQL> shutdown abort

ORACLE instance shut down.

SQL> startup openSAASDB

ORACLE instance started.

Total System Global Area3774713856 bytes

Fixed Size                  2218992 bytes

Variable Size            2885682192 bytes

Database Buffers          872415232 bytes

Redo Buffers               14397440 bytes

Database mounted.

Database opened.

SQL>