ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 11.2.0.1.0 ASM 不能resize 文件

11.2.0.1.0 ASM 不能resize 文件

原创 Linux操作系统 作者:xchui702 时间:2011-09-13 17:25:36 0 删除 编辑

Oracle RDBMS 版本已经升级11.2.0.1.1的PSU, 但是Grid infrastructure 没有此对应的PSU,还是11.2.0.1.0版本。

如此在resize 文件时候报错:

SQL> alter database datafile 37 resize 110M;
alter database datafile 37 resize 110M
*
ERROR at line 1:
ORA-01237: cannot extend datafile 37
ORA-01110: data file 37: '+DATADG1/cddwh01/datafile/vip_stage.326.747253621'
ORA-17505: ksfdrsz:1 Failed to resize file to size 14080 blocks
ORA-15061: ASM operation not supported [41]

查看官方资料如下:

The reason for ORA-15061 is that fix for 8898852 is included in PSU which is installed in RDBMS home. However, ASM home (11.2) is unpatched.

The fix for 8898852 is important as it avoids a potential database corruption when ASM/RDBMS compatible parameters are advanced to >=11.1.

The Grid Infrastructure PSU for Solaris Sparc is not available. Patch.8898852 must be applied to the Grid Infrastructure home separately for this platform. Patch.8898852  is included in the merge patch. 9355126 for Grid home.

决定给GI home打补丁8898852  :

chndsora9:/ora/u01/oracle/product/11.2/grid/OPatch\> ./opatch lsinventory
Invoking OPatch 11.2.0.1.5

Oracle Interim Patch Installer version 11.2.0.1.5
Copyright (c) 2010, Oracle Corporation.  All rights reserved.


Oracle Home       : /ora/u01/oracle/product/11.2/grid
Central Inventory : /ora/u01/oracle/oraInventory
   from           : /var/opt/oracle/oraInst.loc
OPatch version    : 11.2.0.1.5
OUI version       : 11.2.0.1.0
OUI location      : /ora/u01/oracle/product/11.2/grid/oui
Log file location : /ora/u01/oracle/product/11.2/grid/cfgtoollogs/opatch/opatch2011-09-13_16-52-49PM.log

Patch history file: /ora/u01/oracle/product/11.2/grid/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /ora/u01/oracle/product/11.2/grid/cfgtoollogs/opatch/lsinv/lsinventory2011-09-13_16-52-49PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Grid Infrastructure                                           11.2.0.1.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


--------------------------------------------------------------------------------

OPatch succeeded.
chndsora9:/ora/u01/oracle/product/11.2/grid/OPatch\> cd /ora/u01/Oracle11gR2/8898852
chndsora9:/ora/u01/Oracle11gR2/8898852\> /ora/u01/oracle/product/11.2/grid/OPatch/opatch apply
Invoking OPatch 11.2.0.1.5

Oracle Interim Patch Installer version 11.2.0.1.5
Copyright (c) 2010, Oracle Corporation.  All rights reserved.


Oracle Home       : /ora/u01/oracle/product/11.2/grid
Central Inventory : /ora/u01/oracle/oraInventory
   from           : /var/opt/oracle/oraInst.loc
OPatch version    : 11.2.0.1.5
OUI version       : 11.2.0.1.0
OUI location      : /ora/u01/oracle/product/11.2/grid/oui
Log file location : /ora/u01/oracle/product/11.2/grid/cfgtoollogs/opatch/opatch2011-09-13_16-53-48PM.log

Patch history file: /ora/u01/oracle/product/11.2/grid/cfgtoollogs/opatch/opatch_history.txt

ApplySession applying interim patch '8898852' to OH '/ora/u01/oracle/product/11.2/grid'

Running prerequisite checks...
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: 
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.


Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/ora/u01/oracle/product/11.2/grid')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8898852' for restore. This might take a while...
Backing up files affected by the patch '8898852' for rollback. This might take a while...

Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/ora/u01/oracle/product/11.2/grid/lib/libserver11.a"  with "lib/libserver11.a/kfds.o"
Updating archive file "/ora/u01/oracle/product/11.2/grid/lib/libserver11.a"  with "lib/libserver11.a/kff.o"
Updating archive file "/ora/u01/oracle/product/11.2/grid/lib/libserver11.a"  with "lib/libserver11.a/kfio.o"
Updating archive file "/ora/u01/oracle/product/11.2/grid/lib/libserver11.a"  with "lib/libserver11.a/kfio0.o"
Updating archive file "/ora/u01/oracle/product/11.2/grid/lib/libserver11.a"  with "lib/libserver11.a/kfn.o"
Updating archive file "/ora/u01/oracle/product/11.2/grid/lib/libserver11.a"  with "lib/libserver11.a/kfnc.o"
Updating archive file "/ora/u01/oracle/product/11.2/grid/lib/libserver11.a"  with "lib/libserver11.a/kfns.o"
Updating archive file "/ora/u01/oracle/product/11.2/grid/lib/libserver11.a"  with "lib/libserver11.a/ksfd.o"
Running make for target ioracle
ApplySession adding interim patch '8898852' to inventory

Verifying the update...
Inventory check OK: Patch ID 8898852 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8898852 are present in Oracle Home.

The local system has been patched and can be restarted.


OPatch succeeded.
chndsora9:/ora/u01/Oracle11gR2/8898852\> /ora/u01/oracle/product/11.2/grid/OPatch/opatch lsinventory
Invoking OPatch 11.2.0.1.5

Oracle Interim Patch Installer version 11.2.0.1.5
Copyright (c) 2010, Oracle Corporation.  All rights reserved.


Oracle Home       : /ora/u01/oracle/product/11.2/grid
Central Inventory : /ora/u01/oracle/oraInventory
   from           : /var/opt/oracle/oraInst.loc
OPatch version    : 11.2.0.1.5
OUI version       : 11.2.0.1.0
OUI location      : /ora/u01/oracle/product/11.2/grid/oui
Log file location : /ora/u01/oracle/product/11.2/grid/cfgtoollogs/opatch/opatch2011-09-13_16-57-00PM.log

Patch history file: /ora/u01/oracle/product/11.2/grid/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /ora/u01/oracle/product/11.2/grid/cfgtoollogs/opatch/lsinv/lsinventory2011-09-13_16-57-00PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Grid Infrastructure                                           11.2.0.1.0
There are 1 products installed in this Oracle Home.


Interim patches (1) :

Patch  8898852      : applied on Tue Sep 13 16:56:22 CST 2011
Unique Patch ID:  12572687
   Created on 10 May 2010, 09:19:54 hrs UTC
   Bugs fixed:
     8898852

 

--------------------------------------------------------------------------------

OPatch succeeded.
chndsora9:/ora/u01/Oracle11gR2/8898852\> sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 13 16:57:11 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01031: insufficient privileges
SQL> conn / as sysasm
Connected to an idle instance.
SQL> startup
ASM instance started

Total System Global Area  284008448 bytes
Fixed Size                  2147392 bytes
Variable Size             256695232 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted

重新对RDBMS 的数据文件做 resize, 就能正确执行了:

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1069252608 bytes
Fixed Size                  2154936 bytes
Variable Size             817897032 bytes
Database Buffers          243269632 bytes
Redo Buffers                5931008 bytes
Database mounted.
Database opened.
SQL> alter database datafile 37 resize 110M;

Database altered.

SQL>

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/674865/viewspace-707357/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 索引的使用
请登录后发表评论 登录
全部评论

注册时间:2011-05-16

  • 博文量
    38
  • 访问量
    117710