Oracle Standby parameter check

Oracle Standby Parameter
Standby parameter check


set linesize 200
col name format a30
col value format a80
select NAME,nvl(VALUE,'Not Set') value from v$parameter where
name in (
'standby_file_management',
'log_file_name_convert',
'db_file_name_convert',
'fal_client',
'fal_server',
'log_archive_format',
'remote_login_passwordfile',
'log_archive_dest_state_n',
'log_archive_dest_n',
'control_files',
'log_archive_config',
'service_names',
'db_unique_name',
'db_name',
'db_unique_name','dg_broker_start') or name like 'log_archive_dest%'
/




NAME VALUE
------------------------------ --------------------------------------------------------------------------------
control_files /opt/oracle/oradata/db/control01.ctl, /opt/oracle/oradata/db/control02.ctl
, /opt/oracle/oradata/db/control03.ctl

db_file_name_convert Not Set
log_file_name_convert Not Set
log_archive_config Not Set
log_archive_dest Not Set
log_archive_dest_1 LOCATION=/opt/oracle/admin/db/arch/ MANDATORY
log_archive_dest_2 service=prod lgwr net_timeout=30
log_archive_dest_3 Not Set
log_archive_dest_4 Not Set
log_archive_dest_5 Not Set
log_archive_dest_6 Not Set
log_archive_dest_7 Not Set
log_archive_dest_8 Not Set
log_archive_dest_9 Not Set
log_archive_dest_10 Not Set
log_archive_dest_state_1 enable
log_archive_dest_state_2 enable
log_archive_dest_state_3 enable
log_archive_dest_state_4 enable
log_archive_dest_state_5 enable
log_archive_dest_state_6 enable
log_archive_dest_state_7 enable
log_archive_dest_state_8 enable
log_archive_dest_state_9 enable
log_archive_dest_state_10 enable
log_archive_format log%d_%t_%s.arc
fal_client STANDBY
fal_server Not Set
standby_file_management MANUAL
remote_login_passwordfile EXCLUSIVE
service_names db
db_name db
db_unique_name db
dg_broker_start FALSE

34 rows selected.