Search This Blog

ORA-01105:mount is incompatible with mounts by other instances

ORA-01105: mount is incompatible with mounts by other instances
ORA-19808: recovery destination parameter mismatch

node1
$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fri Apr 10 01:36:11 2015

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1.3262E+10 bytes
Fixed Size                  2232128 bytes
Variable Size            6207570112 bytes
Database Buffers         7046430720 bytes
Redo Buffers                5398528 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-19808: recovery destination parameter mismatch

node1

SQL> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +DATAFRA
db_recovery_file_dest_size           big integer 1600G
recovery_parallelism                 integer     0

node2

SQL> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +DATAFRA
db_recovery_file_dest_size           big integer 1500G
recovery_parallelism                 integer     0

SQL> alter system set db_recovery_file_dest_size=1600G;  <<====== node 2

node1

SQL> shutdown
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1.3262E+10 bytes
Fixed Size                  2232128 bytes
Variable Size            6207570112 bytes
Database Buffers         7046430720 bytes
Redo Buffers                5398528 bytes
Database mounted.

Database opened.

No comments:

Post a Comment

Launch your Online Business with a $5.99 .COM!