How to check Oracle Data Guard parameters

Single query for every Data Guard-relevant parameter — the ones that decide where redo goes, how gaps are resolved, and how file names translate between primary and standby. Run on both sides and diff the output when troubleshooting shipping problems.

SET LINESIZE 500 PAGES 0
COL value FORMAT a80
COL name  FORMAT a50

SELECT name, value
FROM   v$parameter
WHERE  name IN ('db_name', 'db_unique_name',
                'log_archive_config',
                'log_archive_dest_1', 'log_archive_dest_2', 'log_archive_dest_3',
                'log_archive_dest_state_1', 'log_archive_dest_state_2', 'log_archive_dest_state_3',
                'remote_login_passwordfile',
                'log_archive_format',
                'log_archive_max_processes',
                'fal_server', 'fal_client',
                'db_file_name_convert',
                'log_file_name_convert',
                'standby_file_management')
ORDER BY name;