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:
[[email protected] ~]$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
[[email protected] ~]$
二、解決方法
将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.
轉載于:https://blog.51cto.com/tiany/1385374