11.0.3.0 RAC 创建dg备库控制文件报RMAN-03002: RMAN-10038错。
Oracle RAC主库做了全备,还原控制文件: ? 查看/u01/app/oracle/diag/rdbms/phydb/phydb/trace/alertSID.log发现如下告警,感觉ASM磁盘无法正常读写。 Errors in file /u01/app/oracle/diag/rdbms/phydb/phydb/trace/phydb_rbal_6693.trc: ? ? 检查第一个告警文件/u01/app/oracle/diag/rdbms/phydb/phydb/trace/phydb_rbal_6693.trc ? Trace file /u01/app/oracle/diag/rdbms/phydb/phydb/trace/phydb_rbal_6693.trcOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning,Automatic Storage Management,OLAP,Data Mining and Real Application Testing options ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1 System name:?Linux Node name:?dg.localdomain Release:?2.6.18-194.el5 Version:?#1 SMP Mon Mar 29 22:10:29 EDT 2010 Machine:?x86_64 VM name:?VMWare Version: 6 Instance name: phydb Redo thread mounted by this instance: 0 <none> Oracle process number: 15 Unix process pid: 6693,image: [email?protected] (RBAL) ? *** 2018-11-14 18:24:14.953 *** SESSION ID:(190.1) 2018-11-14 18:24:14.953 *** CLIENT ID:() 2018-11-14 18:24:14.953 *** SERVICE NAME:() 2018-11-14 18:24:14.953 *** MODULE NAME:() 2018-11-14 18:24:14.953 *** ACTION NAME:() 2018-11-14 18:24:14.953 ? ERROR: asm_version error. err: driver/agent not installed rc:2 ORA-15183: ASMLIB initialization error [driver/agent not installed] ORA-15183: ASMLIB initialization error [driver/agent not installed] kgxgnxgd: error: status 16 ? 确定ASM磁盘无法读写。 ? 但是/usr/sbin/oracleasm checkdisks 与asmcmd/asmca检查磁盘挂载正常。 ? 百度发现文章 https://blog.csdn.net/lqx0405/article/details/44777125: ? 查看Oracle 可执行文件: [[email?protected] asm]# ls -l /u01/app/oracle/product/11.2.0/db_1/bin/oracle -r-sr-s--x 1 oracle oinstall 173515905 Apr 17 15:07? /u01/app/oracle/product/11.2.0/db_1/bin/oracle???? 发现文件的所属的group错误,Oracle 后台进程启动时会执行此文件,而如果属于oinstall组,则无权访问ASM磁盘驱动,从而无法访问ASM disk。 正常属性应该是: [[email?protected] ~]$ ls -l /u01/app/oracle/product/11.2.0/db_1/bin/oracle -r-sr-s--x 1 oracle asmadmin 173515905 Dec 28 18:17 /u01/app/oracle/product/11.2.0/db_1/bin/oracle 修改属性: [[email?protected] ~]# chown oracle:asmadmin /u01/app/oracle/product/11.2.0/db_1/bin/oracle [[email?protected] asm]# ls -l /u01/app/oracle/product/11.2.0/db_1/bin/oracle -r-xr-x--x 1 oracle asmadmin 173515905 Apr 17 15:07 /u01/app/oracle/product/11.2.0/db_1/bin/oracle [[email?protected] asm]# chmod 6551? /u01/app/oracle/product/11.2.0/db_1/bin/oracle [[email?protected] asm]# ls -l /u01/app/oracle/product/11.2.0/db_1/bin/oracle -r-sr-s--x 1 oracle asmadmin 173515905 Apr 17 15:07 /u01/app/oracle/product/11.2.0/db_1/bin/oracle --------------------- 作者:客居天涯 来源:CSDN 原文:https://blog.csdn.net/lqx0405/article/details/44777125 版权声明:本文为博主原创文章,转载请附上博文链接! ? 备份原有oracle文件后 修改 ?继续还原 ?? RMAN>? restore standby controlfile from ‘/rman_backup/standby_1lti7cn9_1_1.ctl‘;? Starting restore at 2018/11/14 21:02:26using channel ORA_DISK_1 ? channel ORA_DISK_1: restoring control filechannel ORA_DISK_1: restore complete,elapsed time: 00:00:07 output file name=+FLASH/cont.ctl Finished restore at 2018/11/14 21:02:33 还原成功 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |