oracle 11g rac ORA-01105: mount is incompatible with mounts by other instances

[oracle@node1 ~]$ export ORACLE_SID=shark1
[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 23 09:27:20 2013

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1.3495E+10 bytes
Fixed Size                  2218032 bytes
Variable Size            6912214992 bytes
Database Buffers         6509559808 bytes
Redo Buffers               71471104 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-01677: standby file name convert parameters differ from other instance

狗屎居然做DG修改的路径转换参数都空了 
SQL> show parameter db_file

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_multiblock_read_count        integer     128
db_file_name_convert                 string
db_files                             integer     200
SQL> shutdown immediate;
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> host
去看DBS下的PFILE
[oracle@node1 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/dbs/
[oracle@node1 dbs]$ ls
hc_DBUA0.dat  hc_posdb1.dat  init.ora  initposdb1.ora  orapwposdb1  snapcf_posdb1.f
[oracle@node1 dbs]$ cat initshark1.ora 
*.audit_file_dest='/u01/app/oracle/admin/posdb/adump'
*.audit_trail='db'

去节点2看看
 [oracle@node1 dbs]$ ll
total 21056
-rw-rw---- 1 oracle oinstall     1544 Jul 30 12:37 hc_DBUA0.dat
-rw-rw---- 1 oracle asmadmin     1544 Jul 30 12:47 hc_shark2.dat
-rw-r--r-- 1 oracle oinstall     2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall     1697 Aug 16 11:01 initshark2.ora
-rw-r----- 1 oracle oinstall     1536 Aug  8 12:25 orapwshark2
-rw-r----- 1 oracle asmadmin 21512192 Aug 21 14:35 snapcf_shark2.f

[oracle@node2 dbs]$ cat initshark2.ora 
SPFILE='+DATA/posdb/spfileshark.ora'


好吧 把内容考下 修改节点1的内容
[oracle@node1 dbs]$ mv initposdb1.ora  initposdb1_over.ora
[oracle@node1 dbs]$ vi initposdb1.ora
SPFILE='+DATA/posdb/spfileposdb.ora'

"initposdb1.ora" [New] 1L, 37C written
[oracle@node1 dbs]$ ll
total 21060
-rw-rw---- 1 oracle oinstall     1544 Jul 30 12:37 hc_DBUA0.dat
-rw-rw---- 1 oracle asmadmin     1544 Jul 30 12:47 hc_posdb1.dat
-rw-r--r-- 1 oracle oinstall     2851 May 15  2009 init.ora
-rw-r--r-- 1 oracle oinstall       37 Aug 23 09:56 initposdb1.ora
-rw-r----- 1 oracle oinstall     1697 Aug 16 11:01 initposdb1_over.ora
-rw-r----- 1 oracle oinstall     1536 Aug  8 12:25 orapwposdb1
-rw-r----- 1 oracle asmadmin 21512192 Aug 21 14:35 snapcf_posdb1.f
[oracle@node1 dbs]$ exit
exit

SQL> startup
ORACLE instance started.

Total System Global Area 1.3495E+10 bytes
Fixed Size                  2218032 bytes
Variable Size            6979323856 bytes
Database Buffers         6442450944 bytes
Redo Buffers               71471104 bytes
Database mounted.
Database opened.
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +DATA/posdb/spfileposdb.ora
SQL> show parameter db_file

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_multiblock_read_count        integer     128
db_file_name_convert                 string      +data/asm/datafile, +data/posd
                                                 b/datafile, +data/asm/tempfile
                                                 , +data/posdb/tempfile
db_files                             integer     200
SQL>

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值