oracle rac ora-01105,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 instancesORA-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>