Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

316

积分

0

好友

0

主题
1#
发表于 2012-2-21 15:11:21 | 查看: 6061| 回复: 5
要打补丁,rac 两节点 CRS Inventory 信息不一致,怎么处理?

节点2:
opatch lsinventory -oh /home/oracle/crs
Invoking OPatch 10.2.0.5.1

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


Oracle Home       : /home/oracle/crs
Central Inventory : /home/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.5.1
OUI version       : 10.2.0.4.0
OUI location      : /home/oracle/crs/oui
Log file location : /home/oracle/crs/cfgtoollogs/opatch/opatch2012-02-21_15-06-05PM.log

Patch history file: /home/oracle/crs/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /home/oracle/crs/cfgtoollogs/opatch/lsinv/lsinventory2012-02-21_15-06-05PM.txt

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

Oracle Clusterware                                                   10.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.

节点1:
opatch lsinventory -oh /home/oracle/crs
Invoking OPatch 10.2.0.5.1

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


Oracle Home       : /home/oracle/crs
Central Inventory : /home/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.5.1
OUI version       : 10.2.0.4.0
OUI location      : /home/oracle/crs/oui
Log file location : /home/oracle/crs/cfgtoollogs/opatch/opatch2012-02-21_15-09-07PM.log

Patch history file: /home/oracle/crs/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /home/oracle/crs/cfgtoollogs/opatch/lsinv/lsinventory2012-02-21_15-09-07PM.txt

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

Oracle Clusterware                                                   10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3                            10.2.0.4.0
There are 2 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


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

OPatch succeeded.
2#
发表于 2012-2-21 15:24:02
节点1:
crsctl query crs softwareversion
CRS software version on node [node01] is [10.2.0.4.0]

crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.4.0]

节点2:
crsctl query crs softwareversion
CRS software version on node [node02] is [10.2.0.4.0]

crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.4.0]

回复 只看该作者 道具 举报

3#
发表于 2012-2-21 15:35:35
Oracle Universal Installer (OUI) FAQ [ID 458893.1]


You have lost the Central Inventory but have a valid Oracle home(s). What do you do?
•Oracle RDBMS 9.2.0.x..x and 10.1.0.x.x
==================
In Oracle 9.2 / 10.1 you can restore the Central Inventory from backup or you can clone the Oracle home(s) from an identical installation.

•Oracle RDBMS 10.2.0.x..x and above
===================================
Oracle Universal Installer allows you to set up the Central Inventory or register an existing ORACLE_HOME with the Central Inventory in case of Central Inventory corruption or loss. You need to execute the command with the -attachHome flag from $ORACLE_HOME/oui/bin.
For example:



cd $ORACLE_HOME/oui/bin
./runInstaller -silent -attachHome -invPtrLoc ./oraInst.loc ORACLE_HOME="<Oracle_Home_Location>" ORACLE_HOME_NAME="<Oracle_Home_Name>"

OR


cd $ORACLE_HOME/oui/bin
./runInstaller -silent -attachHome -invPtrLoc ./oraInst.loc ORACLE_HOME="<Oracle_Home_Location>" ORACLE_HOME_NAME="<Oracle_Home_Name>" CLUSTER_NODES="<node1,node2>" LOCAL_NODE="<node_name>"

•'-attachHome' flag simply attaches the OracleHome if central inventory pre-exists (OR) recreates the central inventory (if it does not pre-exist) and then attaches the OracleHome.

回复 只看该作者 道具 举报

4#
发表于 2012-2-21 16:58:16
You have lost the Oracle home (local)inventory (comps.xml). What can you do?

    Oracle recommends backing up the inventory when an Oracle Home is installed or removed.
    Ensure that you back up the comps.xml having the latest time stamp.
    When your Oracle Home inventory is corrupted or lost, you can restore from the backup or you can install the Oracle Home from an identical installation.
    Rebuilding the Oracle Home inventory is not possible
    NOTE : Manually editing comps.xml is not supported by Oracle.

回复 只看该作者 道具 举报

5#
发表于 2012-2-21 16:58:51
在可以确定的情况下,可以这样:

scp node02:/home/oracle/crs/inventory/ContentsXML/comps.xml .

回复 只看该作者 道具 举报

6#
发表于 2012-2-21 20:36:24
确实 如此 , 这个帖子不错

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-15 01:44 , Processed in 0.050169 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569