Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Saturday, August 22, 2015

ORA-16009: invalid redo transport destination



Errors in file /u01/app/oracle/diag/rdbms/msft/msft/trace/msft_rfs_24730.trc:
ORA-16009: invalid redo transport destination


Incorrect Configuration for log_archive_dest_2 parameter:

change the VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
to
VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE)

Standby:

SQL> show parameter log_Archive_dest_2

NAME                    TYPE     VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2            string     service=orcl VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NA
                       ME=orcl

change it to:

SQL> alter system set log_archive_dest_2= 'service=orcl VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=orcl';

System altered.

On Primary:
NAME                    TYPE     VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2            string     service=msft VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NA
                       ME=msft

change it to:

SQL> alter system set log_archive_dest_2= 'service=msft VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=msft';

System altered.

1 comment:

Best Globle Trend said...

You have just discovered one of California's Best kept secrets: Best RV! missouri rv dealers