Oracle10g如何释放flash_recovery_area,解决ORA-19815错误
来源:互联网 发布:实时经济数据 编辑:程序博客网 时间:2024/05/16 05:27
今早备份Oracle10g数据库的时候,出现以下错误:
这时候实际上flash_recovery_area已经手工释放空间,甚至切换到一个全新的磁盘,仍然无法解决。
连接数据库查询:
发现仍然记录了227个文件,USED空间并未释放。
使用rman登录数据库进行crosscheck:
此时空间得以释放:
Oracle指出,我们可以通过执行以下命令:
将闪回区的内容备份到第三方介质,也同样可以解决这个问题。
是以为记。
转自:http://www.eygle.com/archives/2005/03/oracle10gecieif.html
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.*************************************************************You have the following choices to free up space fromflash recovery area:1. Consider changing your RMAN retention policy. If you are using dataguard, then consider changing your RMAN archivelog deletion policy.2. Backup files to tertiary device such as tape using the RMAN command BACKUP RECOVERY AREA.3. Add disk space and increase the db_recovery_file_dest_size parameter to reflect the new space.4. Delete unncessary files using the RMAN DELETE command. If an OS command was used to delete files, then use RMAN CROSSCHECK and DELETE EXPIRED commands.*************************************************************
这时候实际上flash_recovery_area已经手工释放空间,甚至切换到一个全新的磁盘,仍然无法解决。
连接数据库查询:
$ sqlplus "/ as sysdba"SQL*Plus: Release 10.1.0.2.0 - Production on Mon Mar 28 11:45:30 2005Copyright (c) 1982, 2004, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsSYS AS SYSDBA on 28-MAR-05 >set liesize 120SP2-0158: unknown SET option "liesize"SYS AS SYSDBA on 28-MAR-05 >set linesize 120SYS AS SYSDBA on 28-MAR-05 >SELECT substr(name, 1, 30) name, space_limit AS quota, 2 space_used AS used, 3 space_reclaimable AS reclaimable, 4 number_of_files AS files 5 FROM v$recovery_file_dest ;NAME QUOTA USED RECLAIMABLE FILES---------------------------------- ---------- ---------- ----------- ----------/data5/flash_recovery_area 2147483648 2144863232 0 227
发现仍然记录了227个文件,USED空间并未释放。
使用rman登录数据库进行crosscheck:
$ rman target /Recovery Manager: Release 10.1.0.2.0 - 64bit ProductionCopyright (c) 1995, 2004, Oracle. All rights reserved.connected to target database: EYGLE (DBID=1337390772)RMAN> crosscheck archivelog all;using target database controlfile instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=144 devtype=DISKvalidation failed for archived logarchive log filename=/opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_05_17/o1_mf_1_790_0bjq36ps_.arc recid=1 stamp=526401126validation failed for archived logarchive log filename=/opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_05_17/o1_mf_1_791_0bkbcy7x_.arc recid=2 stamp=526420862validation failed for archived logarchive log filename=/opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_05_17/o1_mf_1_792_0bkkds4d_.arc recid=3 stamp=526428057.......archive log filename=/opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_07_16/o1_mf_1_1014_0hh3zsrp_.arc recid=225 stamp=531678074validation failed for archived logarchive log filename=/opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_07_16/o1_mf_1_1015_0hh40qyp_.arc recid=226 stamp=531678104validation failed for archived logarchive log filename=/opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_07_16/o1_mf_1_1016_0hh41jqq_.arc recid=227 stamp=531678129Crosschecked 227 objectsRMAN> delete expired archivelog all;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=144 devtype=DISKList of Archived Log CopiesKey Thrd Seq S Low Time Name------- ---- ------- - --------- ----1 1 790 X 17-MAY-04 /opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_05_17/o1_mf_1_790_0bjq36ps_.arc2 1 791 X 17-MAY-04 /opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_05_17/o1_mf_1_791_0bkbcy7x_.arc3 1 792 X 17-MAY-04 /opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_05_17/o1_mf_1_792_0bkkds4d_.arc.......225 1 1014 X 16-JUL-04 /opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_07_16/o1_mf_1_1014_0hh3zsrp_.arc226 1 1015 X 16-JUL-04 /opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_07_16/o1_mf_1_1015_0hh40qyp_.arc227 1 1016 X 16-JUL-04 /opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_07_16/o1_mf_1_1016_0hh41jqq_.arcDo you really want to delete the above objects (enter YES or NO)? YESdeleted archive logarchive log filename=/opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_05_17/o1_mf_1_790_0bjq36ps_.arc recid=1 stamp=526401126deleted archive logarchive log filename=/opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_05_17/o1_mf_1_791_0bkbcy7x_.arc recid=2 stamp=526420862deleted archive log......archive log filename=/opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_07_16/o1_mf_1_1014_0hh3zsrp_.arc recid=225 stamp=531678074deleted archive logarchive log filename=/opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_07_16/o1_mf_1_1015_0hh40qyp_.arc recid=226 stamp=531678104deleted archive logarchive log filename=/opt/oracle/flash_recovery_area/EYGLE/archivelog/2004_07_16/o1_mf_1_1016_0hh41jqq_.arc recid=227 stamp=531678129Deleted 227 EXPIRED objectsRMAN> exitRecovery Manager complete.
此时空间得以释放:
$ sqlplus "/ as sysdba"SQL*Plus: Release 10.1.0.2.0 - Production on Mon Mar 28 12:02:19 2005Copyright (c) 1982, 2004, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsSYS AS SYSDBA on 28-MAR-05 >SELECT substr(name, 1, 30) name, space_limit AS quota, 2 space_used AS used, 3 space_reclaimable AS reclaimable, 4 number_of_files AS files 5 FROM v$recovery_file_dest ;NAME QUOTA USED RECLAIMABLE FILES---------------------------------------- ---------- ---------- ----------- ----------/data5/flash_recovery_area 2147483648 9959424 0 1SYS AS SYSDBA on 28-MAR-05 >
Oracle指出,我们可以通过执行以下命令:
RMAN> backup recovery area;
将闪回区的内容备份到第三方介质,也同样可以解决这个问题。
是以为记。
转自:http://www.eygle.com/archives/2005/03/oracle10gecieif.html
- Oracle10g如何释放flash_recovery_area,解决ORA-19815错误
- Oracle10g如何释放flash_recovery_area,解决ORA-19815错误
- Oracle10g如何释放flash_recovery_area,解决ORA-19815错误
- Oracle10g如何释放flash_recovery_area,解决ORA-19815错误
- 如何在Oracle中释放flash_recovery_area(温柔的方法)
- 如何在Oracle中释放flash_recovery_area(粗鲁的方法)
- ora-00257:归档程序错误,在释放之前仅限于内部链接如何解决
- 如何解决ORA-04031 错误
- 如何解决ORA-04031 错误
- 如何解决ORA-04031 错误
- 如何解决ORA-04031 错误
- 如何解决ORA-04031 错误
- 如何解决ora-01092错误
- 如何解决ORA-04031 错误
- 如何解决ORA-04031错误
- oracle10g 如何解决 ORA-28595:Extproc 代理:DLL 路径无效
- 手动释放归档空间解决ORA-00257错误
- Oracle10g的ORA-3136错误
- invokeLater和invokeAndWait
- Ruby on Rails
- 模版文件 config.h
- Principal Solutions Engineer
- SELinux 模式设置
- Oracle10g如何释放flash_recovery_area,解决ORA-19815错误
- JNI的入门
- Ruby
- Principal Program Manager
- UITableView
- 获取本机ipv4网卡地址
- Android编译中GCC版本问题
- Principal Software Engineer
- Android BaseExpandableListAdapter 例子