advertisements
_____________________________________________________________________________________________________________________
Error Description
For RAC database one instance is
running and when I try to start the second instance I am getting following errors
[oracle@node1 script]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 20 12:07:53
2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 3305111552 bytes
Fixed Size
2929744 bytes
Variable Size
3238005680 bytes
Database Buffers
50331648 bytes
Redo Buffers 13844480 bytes
ORA-01105: mount is
incompatible with mounts by other instances
ORA-19808: recovery
destination parameter mismatch
Solution Description
See below the value for the
db_recovery_file_dest_size is just 10. There is no G/M/K mentioned. That is the
reason for the error. There might be chances of mismatch in values on both
nodes. To fix this we have to make these values in sync.
SQL> show parameter db_recovery_file_dest_size
NAME
TYPE VALUE
------------------------------ ------------ ------------------------------
db_recovery_file_dest_size
big integer 10
Do the following commands from
the node which is running.
SQL> select name , open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
PRODDB READ WRITE
Specify the correct value in G/M
and use scope=both which will make the changes in the memory of running
instance. So you don’t need to bounce the database on both nodes.
SQL> alter system set db_recovery_file_dest_size=10g scope=both;
System altered.
SQL> show parameter db_recovery_file_dest_size
NAME
TYPE VALUE
------------------------------ ------------ ------------------------------
db_recovery_file_dest_size
big integer 10G
Now connect to the database instance which in nomount state(here
node1) and open it.
[oracle@node1 script]$ sqlplus / as sysdba
SQL> alter database mount;
Database altered.
SQL> alter database open;
Database altered.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment