熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

Oracle數據庫的歸檔日志寫滿磁盤空間解決辦法

2013-11-13 22:13:10  來源: Oracle 

  數據庫不能啟動

  SQL> startup

  ORACLE 例程已經啟動

  Total System Global Area bytes

  Fixed Size                  bytes

  Variable Size              bytes

  Database Buffers          bytes

  Redo Buffers                bytes

  數據庫裝載完畢

  ORA: 日志 序列號 無法歸檔

  ORA: 超出了恢復文件數的限制

  ORA: 聯機日志 線程 :

  D:\ORACLE\PRODUCT\\ORADATA\ORCL\REDOLOG

  查看$ORACLE_HOME\admin\SID\bdump\alert_SIDlog日志

  Thu Feb ::

  Errors in file d:\oracle\product\\admin\orcl\bdump\orcl_arc_trc:

  ORA: WARNING: db_recovery_file_dest_size of bytes is % used and has remaining bytes available

  Thu Feb ::

  Errors in file d:\oracle\product\\admin\orcl\udump\orcl_ora_trc:

  ORA: 警告: db_recovery_file_dest_size 字節 (共 字節) 已使用 % 尚有 字節可用

  Thu Feb ::

  ************************************************************************

  You have following choices to free up space from flash recovery area:

   Consider changing RMAN RETENTION POLICY If you are using Data Guard

  Thu Feb ::

  ************************************************************************

  then consider changing RMAN ARCHIVELOG DELETION POLICY

   Back up files to tertiary device such as tape using RMAN

  You have following choices to free up space from flash recovery area:

  BACKUP RECOVERY AREA command

   Add disk space and increase db_recovery_file_dest_size parameter to

   Consider changing RMAN RETENTION POLICY If you are using Data Guard

  reflect the new space

  then consider changing RMAN ARCHIVELOG DELETION POLICY

   Delete unnecessary files using RMAN DELETE command If an operating

  system command was used to delete files then use RMAN CROSSCHECK and

   Back up files to tertiary device such as tape using RMAN

  DELETE EXPIRED commands

  ************************************************************************

  BACKUP RECOVERY AREA command

  Thu Feb ::

  Errors in file d:\oracle\product\\admin\orcl\bdump\orcl_arc_trc:

  ORA: limit exceeded for recovery files

  ORA: cannot reclaim bytes disk space from limit

  從上面信息知道是flash recovery area閃回恢復空間中默認G的空間被歸檔日志占滿了沒有空間進行存放歸檔日志

  退出sqlplus進入rman

  SQL> exit

  從 Oracle Database g Enterprise Edition Release Production

  With the Partitioning OLAP and Data Mining options 斷開

  C:\Documents and Settings\mengzhaoliang>rman target/

  恢復管理器: Release Production on 星期四 ::

  Copyright (c) Oracle All rights reserved

  已連接到目標數據庫: ORCL (DBID= 未打開)

  查看歸檔日志

  RMAN> list archivelog all;

  使用目標數據庫控制文件替代恢復目錄

  已存檔的日志副本列表

  關鍵字     Thrd Seq     S 短時間     名稱

  

                   A D:\ORACLE\PRODUCT\\FLASH_RECOVERY_AREA\O

  RCL\ARCHIVELOG\__\O_MF___LZCQ_ARC

                   A D:\ORACLE\PRODUCT\\FLASH_RECOVERY_AREA\O

  RCL\ARCHIVELOG\__\O_MF___LWOH_ARC

                   A D:\ORACLE\PRODUCT\\FLASH_RECOVERY_AREA\O

  可以先把歸檔日志備份到其他的空間然後用rman刪除歸檔日志

  RMAN> delete archivelog all;

  釋放的通道: ORA_DISK_

  分配的通道: ORA_DISK_

  通道 ORA_DISK_: sid= devtype=DISK

  已存檔的日志副本列表

  關鍵字     Thrd Seq     S 短時間     名稱

  

                   A D:\ORACLE\PRODUCT\\FLASH_RECOVERY_AREA\O

  RCL\ARCHIVELOG\__\O_MF___LZCQ_ARC

  是否確定要刪除以上對象 (輸入 YES 或 NO)? yes

  已刪除的存檔日志

  存檔日志文件名 =D:\ORACLE\PRODUCT\\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\

  __\O_MF___LZCQ_ARC 記錄 ID= 時間戳 =

  退出rman進入sqlplus打開數據庫

  RMAN> exit

  恢復管理器完成

  C:\Documents and Settings\mengzhaoliang>sqlplus /as sysdba

  SQL*Plus: Release Production on 星期四 ::

  Copyright (c) Oracle All rights reserved

  連接到:

  Oracle Database g Enterprise Edition Release Production

  With the Partitioning OLAP and Data Mining options

  SQL> alter database open;

  數據庫已更改

  數據庫已經打開!


From:http://tw.wingwit.com/Article/program/Oracle/201311/18516.html
  • 上一篇文章:

  • 下一篇文章:
  • 推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.