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