Check Data Guard Parameters

SELECT db_param.NAME,
        db_param.VALUE,
        db_db.db_unique_name,
        db_db.database_role
   FROM v$parameter db_param, v$database db_db
  WHERE db_param.NAME IN ('db_file_name_convert',
                          'db_name',
                          'db_unique_name',
                          'fal_client',
                          'fal_server',
                          'local_listener',
                          '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',
                          'log_file_name_convert',
                          'standby_archive_dest',
                          'standby_file_management',
                          'remote_login_passwordfile',
                          'log_archive_format')
  ORDER BY db_param.NAME;