Home > Administration > ORA-19808: recovery destination parameter mismatch

ORA-19808: recovery destination parameter mismatch

Today, I modify the recovery file destination size as the following

SQL> alter system set db_recovery_file_dest_size=20G scope=spfile sid=’*’;

System altered.

Then, I restart the instance one-by-one, we got the following error

SQL> startup
ORACLE instance started.

Total System Global Area  835354624 bytes
Fixed Size                  2107104 bytes
Variable Size             759175456 bytes
Database Buffers           71303168 bytes
Redo Buffers                2768896 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-19808: recovery destination parameter mismatch

After that I checked with Oracle,  I find that there are two restrictions to this parameter.

The first restriction is that we can’t change the parameter by setting sid=<instance name>

SQL> alter system set db_recovery_file_dest_size=30G scope=spfile sid=’gsqsprd2′;
alter system set db_recovery_file_dest_size=30G scope=spfile sid=’gsqsprd2′
*
ERROR at line 1:
ORA-32020: SID=* clause needed to modify this parameter

The second restriction is that the value of parameters DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE must be same in all instances.

ORA-19808: recovery destination parameter mismatch
Cause: The value of parameters DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE must be same in all instances. instance. All databases must have same recovery destination parameters.
Action: Check DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE values in all instances.

Therefore, avoiding the restart instance error, please don’t change the DB_RECOVERY_FILE_DEST_SIZE as the following

SQL> alter system set db_recovery_file_dest_size=20G scope=spfile sid=’*’;

You should change it immediately and make it effectiveness.

SQL> alter system set db_recovery_file_dest_size=20G scope=both;

Advertisements
Categories: Administration
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: