datagaurd笔记

db_unique_name
fal_client
fal_server
log_archive_config='dg_config= (dda,ddb)'
log_archive_dest_2='SERVICE=ddb lgwr sync affirm VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ddb'

instance_name = $ORACLE_SID = Service_name(tnsping)
mount状态：创建standby controlfile 备份数据文件 standby logfile

dataguard维护
select database_role,LOG_MODE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
（1）在主库上查看主备库的SCN号
select 1 dest_id, current_scn from v$database
union all
select dest_id, applied_scn from v$archive_dest where target='STANDBY';
（2）在主库查看归档日志位置状态
select dest_id, dest_name, status, type, error, gap_status from v$archive_dest_status where status='VALID';

（3）查看主副库进程
select process,status from v$managed_standby;
select name,SEQUENCE#,APPLIED from v$archived_log order by sequence#;