Wednesday, 15 October 2014

v$archive_dest shows BAD PARAM in status column

Log files are not shipping and in v$archive_dest shows BAD PARAM when configuring Oracle Data Guard
SQL>select error,status from gv$archive_dest where dest_id=3;
BAD PARAM

Solution:
Modify FAL_SERVER and LOG_ARCHIVE_CONFIG,As per requirement.

FAL_SERVER=<standby services>
LOG_ARCHIVE_CONFIG= 'DG_CONFIG=(Primary services,standby services)'


No comments: