STACK TRACE:------------
SUPPORTING INFORMATION:-----------------------
Uploaded all the relevant info to the bug 24 HOUR CONTACT INFORMATION FOR P1
BUGS:----------------------------------------
DIAL-IN INFORMATION:--------------------
IMPACT DATE:------------
Bug 9357097 ORA-1148 Failure to refresh file size offlines datafile producing ORA-372 ORA-376
Symptoms:
Related To:
1 Error May Occur
2 ORA-1148 / ORA-372 / ORA-376
Range of versions believed to be affected <-- 12.1下的版本都有可能命中
Versions BELOW 12.1
Versions confirmed as being affected
11.2.0.1
11.1.0.7
10.2.0.5
10.2.0.4
Platforms affected
Generic (all / most platforms affected)
Fixed:
This issue is fixed in <-- 12.1.0.1 11.2.0.2中已修复
12.1.0.1 (Base Release)
11.2.0.2 (Server Patch Set)
DBWR can offline the datafile with message "Automatic datafile offline due to media error"
if file size refresh fails with error ORA-1148.
error ORA-372 or ORA-376 requiring media recovery.
解决方法：
临时解决方法是将手动将文件online，
Oracle并没有提供专门的补丁，需要升级到对应版本才能彻底解决（11.2.0.2）。
诊断时在ASM实例中执行了以下脚本。
SPOOL ASM_FIRST
SET MARKUP HTML ON
set echo on
set pagesize 200
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
select 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , sysdate " " from dual;
select 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " from v$session where program like '%SMON%';
select * from v$asm_diskgroup;
SELECT * FROM V$ASM_DISK ORDER BY GROUP_NUMBER,DISK_NUMBER;
SELECT * FROM V$ASM_CLIENT;
select * from V$ASM_ATTRIBUTE;
select * from gv$asm_operation;
select * from v$version;
show parameter asm
show parameter cluster
show parameter instance_type
show parameter instance_name
show parameter spfile
show sga
spool off
exit