Thursday, March 17, 2016

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

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

sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Mon Aug 6 10:45:16 2012
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> startup

ORACLE instance started.

Total System Global Area 1302769664 bytes
Fixed Size 2159392 bytes
Variable Size 989859040 bytes
Database Buffers 301989888 bytes
Redo Buffers 8761344 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-19808: recovery destination parameter mismatch

Cause:

DB recovery destination was filled. Below errors were reported in alert.log file for the first instance:

Errors in file /appl/app/oracle/diag/rdbms/xleap/XLEAP1/trace/XLEAP1_mmon_25819.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 4096000 bytes is 100.00% used, and has 0 remaining bytes available.

Solution:

1. Clear the db_recovery_file_dest

OR

2. Increase the size of db_recovery_file_dest_size. Issued below statement on running instance to increase the size:

alter system set db_recovery_file_dest_size= <new-size> scope=both sid='*'

Reference Metalink Doc ID 1481209.1

No comments:

Post a Comment