How to resolve ORA error like ORA-16058 during oracle datagaurd setup .
Execute below steps on primary database
SQL> alter system set log_archive_dest_state_2='DEFER';
SQL> alter system set log_archive_dest_state_2='ENABLE';
SQL> select dest_id, status, destination, error from v$archive_dest where dest_id<=2;
DEST_ID STATUS DESTINATION ERROR
---------- --------- ------------------------------ -----------------------------------------------------------------
1 VALID USE_DB_RECOVERY_FILE_DEST
2 VALID ddb_dr
SQL>
No comments:
Post a Comment