LOG_FILE_NAME_CONVERT parameter is used in ORACLE Data Guard setup that to in standby databases. LOG_FILE_NAME_CONVERT parameter are used to update the location of redo log files in standby database. These parameter are used when you are using different directory structure in standby database compare to primary database redo log file location.

Step for Physical Standby

These are the STEPS to FOLLOW:

• Enable FORCED logging
• Create a password file
• Configure a standby redo log
• Enable archiving
• SET up the primary database initialization parameters
• Configure the listener and tnsnames to support the database on both nodes
• col name format a20
• col thread# format 999
• col sequence# format 999
• col first_change# format 999999
• col next_change# format 999999

SELECT thread#, sequence# AS “SEQ#”, name, first_change# AS “FIRSTSCN”,

next_change# AS “NEXTSCN”,archived, deleted,completion_time AS “TIME”

FROM v$archived_log

V$ log_history

LOG_FILE_NAME_CONVERT parameter is used in Oracle Data Guard setup that to in standby databases. LOG_FILE_NAME_CONVERT parameter are used to update the location of redo log files in standby database. These parameter are used when you are using different directory structure in standby database compare to primary database redo log file location.

Step for Physical Standby

These are the steps to follow:

SELECT thread#, sequence# AS “SEQ#”, name, first_change# AS “FIRSTSCN”,

next_change# AS “NEXTSCN”,archived, deleted,completion_time AS “TIME”

FROM v$archived_log

V$ log_history