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;