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

[oracle@node1 ~]$ export ORACLE_SID=shark1[oracle@node1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 23 09:27:20 2013Copyright (c) 1982, 2009, Oracle.  All rights reserved.Connected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 1.3495E+10 bytesFixed Size                  2218032 bytesVariable Size            6912214992 bytesDatabase Buffers         6509559808 bytesRedo Buffers               71471104 bytesORA-01105: mount is incompatible with mounts by other instancesORA-01677: standby file name convert parameters differ from other instance狗屎居然做DG修改的路径转换参数都空了 SQL> show parameter db_fileNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------db_file_multiblock_read_count        integer     128db_file_name_convert                 stringdb_files                             integer     200SQL> shutdown immediate;ORA-01507: database not mountedORACLE instance shut down.SQL> host

去看DBS下的PFILE

[oracle@node1 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/dbs/[oracle@node1 dbs]$ lshc_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]$ lltotal 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.oraSPFILE='+DATA/posdb/spfileposdb.ora'"initposdb1.ora" [New] 1L, 37C written[oracle@node1 dbs]$ lltotal 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]$ exitexitSQL> startupORACLE instance started.Total System Global Area 1.3495E+10 bytesFixed Size                  2218032 bytesVariable Size            6979323856 bytesDatabase Buffers         6442450944 bytesRedo Buffers               71471104 bytesDatabase mounted.Database opened.SQL> show parameter spfileNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------spfile                               string      +DATA/posdb/spfileposdb.oraSQL> show parameter db_fileNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------db_file_multiblock_read_count        integer     128db_file_name_convert                 string      +data/asm/datafile, +data/posd                                                 b/datafile, +data/asm/tempfile                                                 , +data/posdb/tempfiledb_files                             integer     200SQL>