Oracle Study之--Oracle 11g RAC置归档路径错误案例


系统环境:


操作系统: RedHat EL55

集群:     Oracle 11g GI

Oracle:   Oracle 11gR2


一、错误现象

在设置归档路径时出现以下错误:


SQL> alter system set log_archive_dest_1='LOCATION=+ARC1';              

alter system set log_archive_dest_1='LOCATION=+ARC1'

*

ERROR at line 1:

ORA-17510: Attempt to do i/o beyond file size


SQL> alter system set log_archive_dest_1='LOCATION=/u01/arch1';

alter system set log_archive_dest_1='LOCATION=/u01/arch1'

*

ERROR at line 1:

ORA-17510: Attempt to do i/o beyond file size


查看Oracle online error:


[oracle@bjsrv ~]$oerr ora 17510

17510, 00000, "Attempt to do i/o beyond file size"

// *Cause:  The i/o request points to a block beyond End Of File

// *Action: check additional error messages and call Oracle Support Services

[oracle@bjsrv ~]$


二、解决方法


将spfile 生成pfile


SQL> create  pfile='/home/oracle/initprod.bak' from  spfile;


修改pfile 文件,添加以下参数:


log_archive_dest_1='location=+arc1'


通过pfile 启动instnace:


SQL> startup force nomount pfile='/home/oracle/initprod.bak';

ORACLE instance started.


Total System Global Area  418484224 bytes

Fixed Size                  1336932 bytes

Variable Size             369101212 bytes

Database Buffers           41943040 bytes

Redo Buffers                6103040 bytes


查看归档日志:


SQL> show parameter log


log_archive_dest_1      string      location=+arc1


再通过pfile 生成spfile:


SQL> create spfile='+DG1/prod/spfileprod.ora' from pfile='/home/oracle/initprod.bak';


File created.


重新通过spfile启动instance:


设置归档路径,没有出现错误:


SQL> alter system set log_archive_dest_2='location=+rcy1';


System altered.


SQL> alter system set log_archive_dest_2='';


System altered.