OracleDG archive setup verification problems-master database SQLgt; colstatusfora10SQLgt; coldestinationfora20SQLgt; col
Problems with Oracle DG archive setup verification-master database SQLgt; col status for a10 SQLgt; col destination for a20 SQLgt; col
Problems with Oracle DG archive setup Verification
Modify the listening files of the master and slave databases, and add SID_DESCEntry:
Also query V $ ARCHIVE_DEST or v $ archive_dest_status:
SQL> select status, destination, error from v $ archive_dest;
SQL> select error from v $ archive_dest_status;
The following error occurs:
ORA-16009: remote archive log destination must be a STANDBY database
Modify the log_archive_dest_2 parameter of the master and slave databases and add the valid_for = (online_logfiles, primary_role) option.
For more information about Oracle, see the Oracle topic page? Tid = 12
,
