DR Parameters db_file_name_convert & log_file_name_convert

#################################################################################################################################################################################db_file_name_convert##################################################

Below 2 parameters needs to be set only on standby Database.

db_file_name_convert

log_file_name_convert

SQL> SHOW PARAMETER db_file_name_convert;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_file_name_convert                 string      /u10/oradata/, /u11/oradata/

pdb_file_name_convert                string

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE

--------- --------------------

MUSAIB     MOUNTED

SQL>

Example Scenario:

Production Database: Files might be located in /prod/data/.

Disaster Recovery (DR) Database: Files might need to be located in /dr/data/.

The db_file_name_convert will help Oracle understand the conversion from production to disaster recovery paths.

Example Command:

ALTER SYSTEM SET db_file_name_convert = '/prod/data/', '/dr/data/' SCOPE=BOTH;

This would set the file name conversion for your DR setup.

#################################################################################################################################################################################log_file_name_convert##################################################

The log_file_name_convert parameter in Oracle is used in a Data Guard or Standby Database configuration to handle redo log file name conversion during a restore or recovery operation from a primary (production) database to a standby (DR) database.

SQL> show parameter log_file_name_convert;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_file_name_convert                string      /u15/oradata/, /u10/oradata/,

                                                 /u16/oradata/, /u11/oradata/

SQL>

ALTER SYSTEM SET log_file_name_convert = '/u15/oradata/', '/u10/oradata/' SCOPE=BOTH;

ALTER SYSTEM SET log_file_name_convert = '/primary_path/', '/standby_path/' SCOPE=BOTH;

Multiple Path Mappings: You can define multiple source-to-target directory mappings as needed. For example, in your output:

ALTER SYSTEM SET log_file_name_convert = '/u15/oradata/', '/u10/oradata/', '/u16/oradata/', '/u11/oradata/' SCOPE=BOTH;

/u15/oradata/, /u10/oradata/, /u16/oradata/, /u11/oradata/

This means the primary database has log files in /u15/oradata/ and /u16/oradata/, and the corresponding standby directories are /u10/oradata/ and /u11/oradata/, respectively.

log_file_name_convert

------------------------------------------

/u15/oradata/, /u10/oradata/,

 /u16/oradata/, /u11/oradata/