[20171211]检查dg配置参数.txt

[20171211]检查dg配置参数.txt

--//写一个脚本,用来检查dg配置参数.
col name    for a30
col value   for a120
col ses_mod for a10
col sys_mod for a10
col ins_mod for a10
col type format 99999
SELECT p.name,
       p.type,
       p.value,
       p.isses_modifiable      as SES_MOD,
       p.issys_modifiable      as SYS_MOD,
       p.isinstance_modifiable as INS_MOD
       FROM    v$parameter   p
WHERE
name IN
('remote_login_passwordfile'
,'standby_file_management'
,'log_archive_dest_1'
,'log_archive_dest_state_2'
,'log_archive_dest_2'
,'log_archive_dest_state_3'
,'log_archive_dest_3'
,'log_archive_config'
,'db_file_name_convert'
,'log_file_name_convert'
,'db_name'
,'db_unique_name'
,'log_archive_format'
,'remote_login_passwordfile'
,'fal_server'
,'fal_client'
,'log_archive_config' )
ORDER By name ;