http://hi.baidu.com/taojia/blog/item/7d5656b5af5165c637d3ca55.html
ORA-00257: archiver error. Connect internal
only, until freed.
Oracle 10g數據庫物理空間管理方式與以前Oracle發生了變化，對歸檔日志所在的Flash_Recovery_Area空間進行了另外限制
Flash_Recovery_Area空間缺省安裝時比較小，只有2GB，容易用完
解決過程
根據數據庫目前可用存儲空間情況、FLASH_RECOVERY_AREA空間為2GB的實際情況，把FLASH_RECOVERY_AREA的空間修改為20GB()。
SQL> alter system set
DB_RECOVERY_FILE_DEST_SIZE=20g;
系統已更改。
(其實問題的本質是歸檔日志的使用已經達到了spfile等啟動參數文件中指定的最大值。oracle 10g中歸檔日志默認的存放地是閃回目錄，即%ORACLE_BASE%/flash_recovery_area的相應實例名下面，這個位置的大小在參數文件中有個限制，解決空間不足的問題可以通過兩種方式來實現，一個修改這個大小限制，還有一個就是修改歸檔日志存放位置。)
如果不要這些archivelog的話，可以刪除一些
rman>DELETE NOPROMPT ARCHIVELOG UNTIL
TIME 'SYSDATE-3'; 直接運行這條
這樣會只保留三天的歸檔
sql> select * from
v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------------------
-------------------------------------
----------------------------------------------------- -------------------------------
CONTROLFILE 0
0
0
ONLINELOG 0
0
0
ARCHIVELOG 6.11
0 3
BACKUPPIECE 0
0
0
IMAGECOPY 0
0 0
FLASHBACKLOG 0
0
0
還可參考：http://www.eygle.com/archives/2004/12/rman_crosscheck.html
Rman Crosscheck刪除失效歸檔
當手工刪除了歸檔日志以后，Rman備份會檢測到日志缺失，從而無法進一步繼續執行。
所以此時需要手工執行crosscheck過程，之后Rman備份可以恢復正常。
1.Crosscheck日志
$
rman target /
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: AVATAR2 (DBID=2480694409)
RMAN> crosscheck archivelog all;
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=25 devtype=DISK
validation failed for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2714.dbf
recid=2702 stamp=545107659
validation failed for archived log
archive log
filename=/opt/oracle/oradata/avatar2/archive/1_2715.dbf recid=2703
stamp=545108268
...........
validation failed for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2985.dbf
recid=2973 stamp=545399327
validation
succeeded for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2986.dbf
recid=2974 stamp=545400820
validation succeeded for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2987.dbf
recid=2975 stamp=545401757
validation succeeded for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2988.dbf
recid=2976 stamp=545402716
validation succeeded for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2989.dbf
recid=2977 stamp=545403661
validation succeeded for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2990.dbf
recid=2978 stamp=545404946
validation succeeded for archived log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2991.dbf
recid=2979 stamp=545406220
Crosschecked 278 objects
RMAN>
2.使用delete expired
archivelog all 命令刪除所有過期歸檔日志:
RMAN> delete expired archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=12 devtype=DISK
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
376
1 2714 X 23-NOV-04
=/opt/oracle/oradata/avatar2/archive/1_2714.dbf
.....
3.簡要介紹一下report obsolete命令
使用report obsolete命令報告過期備份
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 125 01-NOV-04
Backup Piece 125 01-NOV-04 /data1/oracle/orabak/full_1_541045804
Backup Set 131 04-NOV-04
Backup Piece 131 04-NOV-04
/data1/oracle/orabak/full_AVATAR2_20041104_131
....
Backup Set 173 06-DEC-04
Backup Piece 173 06-DEC-04
/data1/oracle/orabak/full_AVATAR2_20041206_173
Backup Set 179 11-DEC-04
Backup Piece 179 11-DEC-04 /data1/oracle/orabak/arch544588206.arc
.....
Backup Piece 189 17-DEC-04
/data1/oracle/orabak/arch545106606.arc
Backup Set 190 17-DEC-04
Backup Piece 190 17-DEC-04 /data1/oracle/orabak/arch545106665.arc
Backup Set 191 20-DEC-04
Backup Piece 191 20-DEC-04
/data1/oracle/orabak/arch_AVATAR2_20041220_194
Archive Log 2973 20-DEC-04
/opt/oracle/oradata/avatar2/archive/1_2985.dbf
Archive Log 2971 20-DEC-04
/opt/oracle/oradata/avatar2/archive/1_2984.dbf
.....
Archive Log 2705 17-DEC-04
/opt/oracle/oradata/avatar2/archive/1_2717.dbf
Archive Log 2704 17-DEC-04
/opt/oracle/oradata/avatar2/archive/1_2716.dbf
Archive Log 2703 17-DEC-04
/opt/oracle/oradata/avatar2/archive/1_2715.dbf
Archive Log 2702 17-DEC-04 /opt/oracle/oradata/avatar2/archive/1_2714.dbf
4.使用delete obsolete命令刪除過期備份:
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 125 01-NOV-04
Backup Piece 125 01-NOV-04 /data1/oracle/orabak/full_1_541045804
....
Archive Log 2704 17-DEC-04
/opt/oracle/oradata/avatar2/archive/1_2716.dbf
Archive Log 2703 17-DEC-04
/opt/oracle/oradata/avatar2/archive/1_2715.dbf
Archive
Log 2702 17-DEC-04
/opt/oracle/oradata/avatar2/archive/1_2714.dbf
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/data1/oracle/orabak/full_AVATAR2_20041206_173
recid=173 stamp=544156241
.....
deleted archive log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2715.dbf
recid=2703 stamp=545108268
deleted archive log
archive log filename=/opt/oracle/oradata/avatar2/archive/1_2714.dbf
recid=2702 stamp=545107659
Deleted 286 objects
RMAN> crosscheck archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=19 devtype=DISK
specification does not match any archive log in the recovery catalog
-The End-
posted on 2010-04-21 17:36
SIMONE 閱讀(1710)
評論(0) 編輯 收藏 所屬分類:
oracle