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

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

0

积分

1

好友

9

主题
1#
发表于 2014-3-18 18:48:36 | 查看: 6375| 回复: 4

是使用root用户安装的,执行的下面的命令
/u01/app/grid/OPatch/opatch auto /u01/soft/up -ocmrf /home/grid/ocm.rsp


日志如下
[grid@aqgldb1 ~]$ tail -f /u01/app/grid/cfgtoollogs/opatchauto2014-03-18_18-39-14.log
2014-03-18 18:39:35: Opening file /etc/oracle/ocr.loc
2014-03-18 18:39:35: Value (FALSE) is set for key=local_only
2014-03-18 18:39:35: Home type of /u01/app/grid is CRS
2014-03-18 18:39:35: Unlock crshome...
2014-03-18 18:39:35: crshome passed is
2014-03-18 18:39:35: Exclude file used is /u01/app/grid/OPatch/crs/installPatch.excl
2014-03-18 18:39:35: Home location in olr.loc is /u01/app/grid
2014-03-18 18:39:35: unlock crs home is /u01/app/grid
2014-03-18 18:39:35: Executing /u01/app/grid/bin/crsctl stop crs -f
2014-03-18 18:39:35: Executing cmd: /u01/app/grid/bin/crsctl stop crs -f
2014-03-18 18:41:34: Command output:
>  CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'aqgldb1'
>  CRS-2673: Attempting to stop 'ora.crsd' on 'aqgldb1'
>  CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'aqgldb1'
>  CRS-2673: Attempting to stop 'ora.DATA.dg' on 'aqgldb1'
>  CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'aqgldb1'
>  CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'aqgldb1' succeeded
>  CRS-2673: Attempting to stop 'ora.aqgldb1.vip' on 'aqgldb1'
>  CRS-2677: Stop of 'ora.aqgldb1.vip' on 'aqgldb1' succeeded
>  CRS-2672: Attempting to start 'ora.aqgldb1.vip' on 'aqgldb2'
>  CRS-2676: Start of 'ora.aqgldb1.vip' on 'aqgldb2' succeeded
>  CRS-2677: Stop of 'ora.DATA.dg' on 'aqgldb1' succeeded
>  CRS-2673: Attempting to stop 'ora.asm' on 'aqgldb1'
>  CRS-2677: Stop of 'ora.asm' on 'aqgldb1' succeeded
>  CRS-2673: Attempting to stop 'ora.ons' on 'aqgldb1'
>  CRS-2677: Stop of 'ora.ons' on 'aqgldb1' succeeded
>  CRS-2673: Attempting to stop 'ora.net1.network' on 'aqgldb1'
>  CRS-2677: Stop of 'ora.net1.network' on 'aqgldb1' succeeded
>  CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'aqgldb1' has completed
>  CRS-2677: Stop of 'ora.crsd' on 'aqgldb1' succeeded
>  CRS-2673: Attempting to stop 'ora.crf' on 'aqgldb1'
>  CRS-2673: Attempting to stop 'ora.ctssd' on 'aqgldb1'
>  CRS-2673: Attempting to stop 'ora.evmd' on 'aqgldb1'
>  CRS-2673: Attempting to stop 'ora.asm' on 'aqgldb1'
>  CRS-2673: Attempting to stop 'ora.mdnsd' on 'aqgldb1'
>  CRS-2677: Stop of 'ora.crf' on 'aqgldb1' succeeded
>  CRS-2677: Stop of 'ora.evmd' on 'aqgldb1' succeeded
>  CRS-2677: Stop of 'ora.mdnsd' on 'aqgldb1' succeeded
>  CRS-2677: Stop of 'ora.asm' on 'aqgldb1' succeeded
>  CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'aqgldb1'
>  CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'aqgldb1' succeeded
>  CRS-2677: Stop of 'ora.ctssd' on 'aqgldb1' succeeded
>  CRS-2673: Attempting to stop 'ora.cssd' on 'aqgldb1'
>  CRS-2677: Stop of 'ora.cssd' on 'aqgldb1' succeeded
>  CRS-2673: Attempting to stop 'ora.gipcd' on 'aqgldb1'
>  CRS-2677: Stop of 'ora.gipcd' on 'aqgldb1' succeeded
>  CRS-2673: Attempting to stop 'ora.gpnpd' on 'aqgldb1'
>  CRS-2677: Stop of 'ora.gpnpd' on 'aqgldb1' succeeded
>  CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'aqgldb1' has completed
>  CRS-4133: Oracle High Availability Services has been stopped.
>End Command output
2014-03-18 18:41:34: /u01/app/grid/bin/crsctl stop crs -f
2014-03-18 18:41:34: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:41:36: Command output:
>  CRS-4639: Could not contact Oracle High Availability Services
>  CRS-4000: Command Check failed, or completed with errors.
>End Command output
2014-03-18 18:41:36: Executing cmd: /u01/app/grid/bin/crsctl check has
2014-03-18 18:41:38: Command output:
>  CRS-4639: Could not contact Oracle High Availability Services
>End Command output
2014-03-18 18:41:38: The CRS home passed in is /u01/app/grid
2014-03-18 18:43:38: Waiting for complete CRS stack to stop
2014-03-18 18:43:38: CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'aqgldb1'
CRS-2673: Attempting to stop 'ora.crsd' on 'aqgldb1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'aqgldb1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'aqgldb1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'aqgldb1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'aqgldb1' succeeded
CRS-2673: Attempting to stop 'ora.aqgldb1.vip' on 'aqgldb1'
CRS-2677: Stop of 'ora.aqgldb1.vip' on 'aqgldb1' succeeded
CRS-2672: Attempting to start 'ora.aqgldb1.vip' on 'aqgldb2'
CRS-2676: Start of 'ora.aqgldb1.vip' on 'aqgldb2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'aqgldb1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'aqgldb1'
CRS-2677: Stop of 'ora.asm' on 'aqgldb1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'aqgldb1'
CRS-2677: Stop of 'ora.ons' on 'aqgldb1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'aqgldb1'
CRS-2677: Stop of 'ora.net1.network' on 'aqgldb1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'aqgldb1' has completed
CRS-2677: Stop of 'ora.crsd' on 'aqgldb1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'aqgldb1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'aqgldb1'
CRS-2673: Attempting to stop 'ora.evmd' on 'aqgldb1'
CRS-2673: Attempting to stop 'ora.asm' on 'aqgldb1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'aqgldb1'
CRS-2677: Stop of 'ora.crf' on 'aqgldb1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'aqgldb1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'aqgldb1' succeeded
CRS-2677: Stop of 'ora.asm' on 'aqgldb1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'aqgldb1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'aqgldb1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'aqgldb1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'aqgldb1'
CRS-2677: Stop of 'ora.cssd' on 'aqgldb1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'aqgldb1'
CRS-2677: Stop of 'ora.gipcd' on 'aqgldb1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'aqgldb1'
CRS-2677: Stop of 'ora.gpnpd' on 'aqgldb1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'aqgldb1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /u01/app/grid

2014-03-18 18:43:38: Invoking removeproc to clean oracle client procs
2014-03-18 18:43:38: Executing cmd: /sbin/fuser -k /u01/app/grid/bin/crsctl.bin
2014-03-18 18:43:38: fuser command output for /u01/app/grid/bin/crsctl.bin is
2014-03-18 18:43:38: Oracle user for /u01/app/grid is grid
2014-03-18 18:43:38: Opening file /etc/oracle/ocr.loc
2014-03-18 18:43:38: Value (FALSE) is set for key=local_only
2014-03-18 18:43:38: Running as user grid: /u01/app/grid/OPatch/opatch prereq CheckApplicable -ph /u01/soft/up/17592127 -oh /u01/app/grid
2014-03-18 18:43:38: s_run_as_user2: Running /bin/su grid -c ' /u01/app/grid/OPatch/opatch prereq CheckApplicable -ph /u01/soft/up/17592127 -oh /u01/app/grid '
2014-03-18 18:43:40: Removing file /tmp/file9RRAHI
2014-03-18 18:43:40: Successfully removed file: /tmp/file9RRAHI
2014-03-18 18:43:40: /bin/su successfully executed

2014-03-18 18:43:40: Error : The opatch Applicable check failed.  The patch /u01/soft/up/17592127 is not applicable to /u01/app/grid
2014-03-18 18:43:40: Running as user grid: /u01/app/grid/OPatch/opatch prereq CheckApplicable -ph /u01/soft/up/17540582 -oh /u01/app/grid
2#
发表于 2014-3-18 18:49:08
2014-03-18 18:43:40: s_run_as_user2: Running /bin/su grid -c ' /u01/app/grid/OPatch/opatch prereq CheckApplicable -ph /u01/soft/up/17540582 -oh /u01/app/grid '
2014-03-18 18:43:43: Removing file /tmp/fileG6dmqK
2014-03-18 18:43:43: Successfully removed file: /tmp/fileG6dmqK
2014-03-18 18:43:43: /bin/su successfully executed

2014-03-18 18:43:43: Status of Applicable  check  for /u01/app/grid is 1
2014-03-18 18:43:43: Error:Patch Applicable check failed for /u01/app/grid
2014-03-18 18:43:43: Executing cmd: /bin/rpm -q sles-release
2014-03-18 18:43:43: Command output:
>  package sles-release is not installed
>End Command output
2014-03-18 18:43:43: init file = /u01/app/grid/crs/init/init.ohasd
2014-03-18 18:43:43: Copying file /u01/app/grid/crs/init/init.ohasd to /etc/init.d directory
2014-03-18 18:43:43: Setting init.ohasd permission in /etc/init.d directory
2014-03-18 18:43:43: init file = /u01/app/grid/crs/init/ohasd
2014-03-18 18:43:43: Copying file /u01/app/grid/crs/init/ohasd to /etc/init.d directory
2014-03-18 18:43:43: Setting ohasd permission in /etc/init.d directory
2014-03-18 18:43:43: Executing cmd: /bin/rpm -q sles-release
2014-03-18 18:43:43: Command output:
>  package sles-release is not installed
>End Command output
2014-03-18 18:43:43: Removing "/etc/rc.d/rc3.d/S96ohasd"
2014-03-18 18:43:43: Removing file /etc/rc.d/rc3.d/S96ohasd
2014-03-18 18:43:43: Successfully removed file: /etc/rc.d/rc3.d/S96ohasd
2014-03-18 18:43:43: Creating a link "/etc/rc.d/rc3.d/S96ohasd" pointing to /etc/init.d/ohasd
2014-03-18 18:43:43: Removing "/etc/rc.d/rc5.d/S96ohasd"
2014-03-18 18:43:43: Removing file /etc/rc.d/rc5.d/S96ohasd
2014-03-18 18:43:43: Successfully removed file: /etc/rc.d/rc5.d/S96ohasd
2014-03-18 18:43:43: Creating a link "/etc/rc.d/rc5.d/S96ohasd" pointing to /etc/init.d/ohasd
2014-03-18 18:43:43: Removing "/etc/rc.d/rc0.d/K15ohasd"
2014-03-18 18:43:43: Removing file /etc/rc.d/rc0.d/K15ohasd
2014-03-18 18:43:43: Successfully removed file: /etc/rc.d/rc0.d/K15ohasd
2014-03-18 18:43:43: Creating a link "/etc/rc.d/rc0.d/K15ohasd" pointing to /etc/init.d/ohasd
2014-03-18 18:43:43: Removing "/etc/rc.d/rc1.d/K15ohasd"
2014-03-18 18:43:43: Removing file /etc/rc.d/rc1.d/K15ohasd
2014-03-18 18:43:43: Successfully removed file: /etc/rc.d/rc1.d/K15ohasd
2014-03-18 18:43:43: Creating a link "/etc/rc.d/rc1.d/K15ohasd" pointing to /etc/init.d/ohasd
2014-03-18 18:43:43: Removing "/etc/rc.d/rc2.d/K15ohasd"
2014-03-18 18:43:43: Removing file /etc/rc.d/rc2.d/K15ohasd
2014-03-18 18:43:43: Successfully removed file: /etc/rc.d/rc2.d/K15ohasd
2014-03-18 18:43:43: Creating a link "/etc/rc.d/rc2.d/K15ohasd" pointing to /etc/init.d/ohasd
2014-03-18 18:43:43: Removing "/etc/rc.d/rc3.d/K15ohasd"
2014-03-18 18:43:43: Removing file /etc/rc.d/rc3.d/K15ohasd
2014-03-18 18:43:43: Successfully removed file: /etc/rc.d/rc3.d/K15ohasd
2014-03-18 18:43:43: Creating a link "/etc/rc.d/rc3.d/K15ohasd" pointing to /etc/init.d/ohasd
2014-03-18 18:43:43: Removing "/etc/rc.d/rc4.d/K15ohasd"
2014-03-18 18:43:43: Removing file /etc/rc.d/rc4.d/K15ohasd
2014-03-18 18:43:43: Successfully removed file: /etc/rc.d/rc4.d/K15ohasd
2014-03-18 18:43:43: Creating a link "/etc/rc.d/rc4.d/K15ohasd" pointing to /etc/init.d/ohasd
2014-03-18 18:43:43: Removing "/etc/rc.d/rc6.d/K15ohasd"
2014-03-18 18:43:43: Removing file /etc/rc.d/rc6.d/K15ohasd
2014-03-18 18:43:43: Successfully removed file: /etc/rc.d/rc6.d/K15ohasd
2014-03-18 18:43:43: Creating a link "/etc/rc.d/rc6.d/K15ohasd" pointing to /etc/init.d/ohasd
2014-03-18 18:43:43: The file ohasd has been successfully linked to the RC directories
2014-03-18 18:43:43: Starting Oracle Clusterware
2014-03-18 18:43:43: Executing /u01/app/grid/bin/crsctl start crs
2014-03-18 18:43:43: Executing cmd: /u01/app/grid/bin/crsctl start crs
2014-03-18 18:43:50: Command output:
>  CRS-4123: Oracle High Availability Services has been started.
>End Command output
2014-03-18 18:43:50: Executing cmd: /u01/app/grid/bin/crsctl check crs
2014-03-18 18:43:50: Command output:
>  CRS-4638: Oracle High Availability Services is online
>  CRS-4535: Cannot communicate with Cluster Ready Services
>  CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
>  CRS-4534: Cannot communicate with Event Manager
>End Command output
2014-03-18 18:43:50: Running /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:43:50: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:43:50: Checking the status of cluster
2014-03-18 18:43:55: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:43:55: Checking the status of cluster
2014-03-18 18:44:00: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:44:00: Checking the status of cluster
2014-03-18 18:44:05: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:44:05: Checking the status of cluster
2014-03-18 18:44:10: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:44:10: Checking the status of cluster
2014-03-18 18:44:15: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:44:16: Checking the status of cluster
2014-03-18 18:44:21: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:44:21: Checking the status of cluster
2014-03-18 18:44:26: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:44:26: Checking the status of cluster
2014-03-18 18:44:31: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:44:31: Checking the status of cluster
2014-03-18 18:44:36: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:44:36: Checking the status of cluster
2014-03-18 18:44:41: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:44:41: Checking the status of cluster
2014-03-18 18:44:46: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:44:47: Checking the status of cluster
2014-03-18 18:44:52: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:44:52: Checking the status of cluster
2014-03-18 18:44:57: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:44:57: Checking the status of cluster
2014-03-18 18:45:02: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:45:02: Checking the status of cluster
2014-03-18 18:45:07: Executing cmd: /u01/app/grid/bin/crsctl check cluster -n aqgldb1
2014-03-18 18:45:07: Oracle CRS stack installed and running
2014-03-18 18:45:07: CRS-4123: Oracle High Availability Services has been started.

2014-03-18 18:45:07: ERROR: Prereq checkApplicable failed. Refer log file for more details.

回复 只看该作者 道具 举报

3#
发表于 2014-3-18 18:53:36
[grid@aqgldb1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory

Oracle 中间补丁程序安装程序版本 11.2.0.3.6
版权所有 (c) 2013, Oracle Corporation。保留所有权利。


Oracle Home       : /u01/app/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/grid/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.3.0
Log file location : /u01/app/grid/cfgtoollogs/opatch/opatch2014-03-18_18-53-24下午_1.log

Lsinventory Output file location : /u01/app/grid/cfgtoollogs/opatch/lsinv/lsinventory2014-03-18_18-53-24下午.txt

--------------------------------------------------------------------------------
已安装的顶级产品 (1):

Oracle Grid Infrastructure                                           11.2.0.3.0
此 Oracle 主目录中已安装 1 个产品。


此 Oracle 主目录中未安装任何中间补丁程序。


包含多个节点的 RAC 系统
  Local node = aqgldb1
  Remote node = aqgldb2

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

OPatch succeeded.
[grid@aqgldb1 ~]$

回复 只看该作者 道具 举报

4#
发表于 2014-3-18 18:54:31
[root@aqgldb1 \u5997\u5c84\u6f70]# /u01/app/grid/OPatch/opatch auto /u01/soft/up -ocmrf /home/grid/ocm.rsp
Executing /u01/app/grid/perl/bin/perl /u01/app/grid/OPatch/crs/patch11203.pl -patchdir /u01/soft -patchn up -ocmrf /home/grid/ocm.rsp -paramfile /u01/app/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/grid/cfgtoollogs/opatchauto2014-03-18_18-39-14.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/grid/cfgtoollogs/opatchauto2014-03-18_18-39-14.report.log

2014-03-18 18:39:14: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/grid/crs/install/crsconfig_params

Stopping CRS...
Stopped CRS successfully

Error : The opatch Applicable check failed.  The patch /u01/soft/up/17592127 is not applicable to /u01/app/grid
Error:Patch Applicable check failed for /u01/app/grid

Starting CRS...
ERROR: Prereq checkApplicable failed. Refer log file for more details.


opatch auto failed.
You have new mail in /var/spool/mail/root

回复 只看该作者 道具 举报

5#
发表于 2014-3-19 12:03:16
你安装步骤不正确,请参考1494646.1

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-5-17 18:40 , Processed in 0.047663 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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