時(shí)間：2015/6/28來源：IT貓撲網(wǎng)作者：網(wǎng)管聯(lián)盟我要評(píng)論(0)
1、數(shù)據(jù)庫不能啟動(dòng)
SQL> startup
oracle 例程已經(jīng)啟動(dòng)。
Total System Global Area 289406976 bytes
Fixed Size 1248576 bytes
Variable Size 83886784 bytes
Database Buffers 197132288 bytes
Redo Buffers 7139328 bytes
數(shù)據(jù)庫裝載完畢。
ORA-16038: 日志 2 序列號(hào) 44 無法歸檔
ORA-19809: 超出了恢復(fù)文件數(shù)的限制
ORA-00312: 聯(lián)機(jī)日志 2 線程 1:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'
2、查看$ORACLE_HOME\admin\SID\bdump\alert_SID.log日志
Thu Feb 19 09:45:33 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc1_660.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 99.95% used, and has 1129472 remaining bytes available.
Thu Feb 19 09:45:33 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_4708.trc:
ORA-19815: 警告: db_recovery_file_dest_size 字節(jié) (共 2147483648 字節(jié)) 已使用 99.95%, 尚有 1129472 字節(jié)可用。
Thu Feb 19 09:45:33 2009
************************************************************************
You have following choices to free up space from Flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
Thu Feb 19 09:45:33 2009
************************************************************************
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. 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.
3. Add disk space and increase db_recovery_file_dest_size parameter to
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
reflect the new space.
then consider changing RMAN ARCHIVELOG DELETION POLICY.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
2. Back up files to tertiary device such as tape using RMAN
DELETE EXPIRED commands.
************************************************************************
BACKUP RECOVERY AREA command.
Thu Feb 19 09:45:34 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc1_660.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 44217856 bytes disk space from 2147483648 limit
從上面信息知道是flash recovery area閃回恢復(fù)空間中默認(rèn)2G的空間被歸檔日志占滿了，沒有空間進(jìn)行存放歸檔日志。
#p#副標(biāo)題#e#
3、退出sqlplus,進(jìn)入rman
SQL> exit
從 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 斷開
C:\Documents and Settings\mengzhaoliang>rman target/
恢復(fù)管理器: Release 10.2.0.1.0 - Production on 星期四 2月 19 09:57:48 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
已連接到目標(biāo)數(shù)據(jù)庫: ORCL (DBID=1193443472, 未打開)
4、查看歸檔日志
RMAN> list archivelog all;
使用目標(biāo)數(shù)據(jù)庫控制文件替代恢復(fù)目錄
已存檔的日志副本列表
關(guān)鍵字 Thrd Seq S 短時(shí)間 名稱
------- ---- ------- - ---------- ----
40 1 1 A 17-11月-08 D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\O
RCL\ARCHIVELOG\2008_11_18\O1_MF_1_1_4L44Z9CQ_.ARC
41 1 2 A 18-11月-08 D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\O
RCL\ARCHIVELOG\2008_11_18\O1_MF_1_2_4L4W4O0H_.ARC
42 1 3 A 18-11月-08 D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\O
5、可以先把歸檔日志備份到其他的空間，然后用rman刪除歸檔日志；
RMAN> delete archivelog all;
釋放的通道: ORA_DISK_1
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: sid=151 devtype=DISK
已存檔的日志副本列表
關(guān)鍵字 Thrd Seq S 短時(shí)間 名稱
------- ---- ------- - ---------- ----
40 1 1 A 17-11月-08 D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\O
RCL\ARCHIVELOG\2008_11_18\O1_MF_1_1_4L44Z9CQ_.ARC
是否確定要?jiǎng)h除以上對(duì)象 (輸入 YES 或 NO)? yes
已刪除的存檔日志
存檔日志文件名 =D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\200
_11_18\O1_MF_1_1_4L44Z9CQ_.ARC 記錄 ID=40 時(shí)間戳 =671101294
6、退出rman，進(jìn)入sqlplus,打開數(shù)據(jù)庫
RMAN> exit
恢復(fù)管理器完成。
C:\Documents and Settings\mengzhaoliang>sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 2月 19 10:03:02 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
連接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> alter database open;
數(shù)據(jù)庫已更改。
數(shù)據(jù)庫已經(jīng)打開！
關(guān)鍵詞標(biāo)簽：Oracle,數(shù)據(jù)庫,歸檔日
相關(guān)閱讀
熱門文章
Oracle中使用alter table來增加,刪除,修改列
oracle中使用SQL語句修改字段類型-oracle修
使用低權(quán)限Oracle數(shù)據(jù)庫賬戶得到管理員權(quán)限
Oracle對(duì)user的訪問控制
人氣排行 ORACLE SQL 判斷字符串是否為數(shù)字的語句Oracle中使用alter table來增加,刪除,修改列的語法ORACLE和SQL語法區(qū)別歸納(1)oracle grant 授權(quán)語句如何加速Oracle大批量數(shù)據(jù)處理Oracle刪除表的幾種方法ORACLE修改IP地址后如何能夠使用Oracle 10g創(chuàng)建表空間和用戶并指定權(quán)限