Oracle ADG搭建指南！

▼▼▼
[oracle@localhost ~]$ telnet 172.25.18.252 1521Trying 172.25.18.252...Connected to 172.25.18.252.Escape character is '^]'.^C^CConnection closed by foreign host.[oracle@localhost ~]$

▼▼▼
PTGBSS =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.18.251)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = ptgbss)    )  )PTGBSSDG =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.18.252)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = ptgbssdg)    (UR=A)    )  )

▼▼▼
alter database add standby logfile thread 1 group 10 '/u01/oradata/ptgbss/redo10.log' size 1024M;alter database add standby logfile thread 1 group 11 '/u01/oradata/ptgbss/redo11.log' size 1024M;alter database add standby logfile thread 1 group 12 '/u01/oradata/ptgbss/redo12.log' size 1024M;alter database add standby logfile thread 1 group 13 '/u01/oradata/ptgbss/redo13.log' size 1024M;alter database add standby logfile thread 1 group 14 '/u01/oradata/ptgbss/redo14.log' size 1024M;alter database add standby logfile thread 1 group 15 '/u01/oradata/ptgbss/redo15.log' size 1024M;alter database add standby logfile thread 1 group 16 '/u01/oradata/ptgbss/redo16.log' size 1024M;alter database add standby logfile thread 1 group 17 '/u01/oradata/ptgbss/redo17.log' size 1024M;alter database add standby logfile thread 1 group 18 '/u01/oradata/ptgbss/redo18.log' size 1024M;alter database add standby logfile thread 1 group 19 '/u01/oradata/ptgbss/redo19.log' size 1024M;

▼▼▼
alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(ptgbss,ptgbssdg)' scope=both ;alter system set LOG_ARCHIVE_DEST_1='LOCATION=/data/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ptgbss' scope=both;alter system set LOG_ARCHIVE_DEST_2='SERVICE=ptgbssdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ptgbssdg' scope=both;alter system set LOG_ARCHIVE_DEST_STATE_1=ENABLE scope=both;alter system set LOG_ARCHIVE_DEST_STATE_2=ENABLE scope=both;alter system set FAL_SERVER=ptgbssdg scope=both;alter system set FAL_CLIENT=ptgbss scope=both;alter system set standby_file_management=auto;alter system set db_file_name_convert='/data/ptgbssdg','/data/ptgbss' scope=spfile;alter system set log_file_name_convert='/u01/oradata/ptgbssdg','/u01/oradata/ptgbss' scope=spfile;

▼▼▼
[oracle@localhost dbs]$ scp u01/product/11.2.0/db_1/dbs/initptgbss.ora 172.25.18.252:/u01/product/11.2.0/db_1/dbs[oracle@localhost dbs]$ scp u01/product/11.2.0/db_1/dbs/orapwptgbss 172.25.18.252:/u01/product/11.2.0/db_1/dbs

▼▼▼
LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = ptgbssdg)(PORT = 1521))    )  )ADR_BASE_LISTENER = u01SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (GLOBAL_DBNAME = ptgbss)      (ORACLE_HOME = u01/product/11.2.0/db_1)      (SID_NAME = ptgbssdg)    )  )

▼▼▼
PTGBSS =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.18.251)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = ptgbss)    )  )PTGBSSDG =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.18.252)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = ptgbssdg)    )  )

▼▼▼
ptgbss.__db_cache_size=17448304640ptgbssdg.__db_cache_size=16642998272ptgbss.__java_pool_size=134217728ptgbssdg.__java_pool_size=134217728ptgbss.__large_pool_size=134217728ptgbssdg.__large_pool_size=134217728ptgbss.__oracle_base='/u01'#ORACLE_BASE set from environmentptgbssdg.__oracle_base='/u01'#ORACLE_BASE set from environmentptgbss.__pga_aggregate_target=3422552064ptgbssdg.__pga_aggregate_target=3422552064ptgbss.__sga_target=19327352832ptgbssdg.__sga_target=19327352832ptgbss.__shared_io_pool_size=0ptgbssdg.__shared_io_pool_size=0ptgbss.__shared_pool_size=1476395008ptgbssdg.__shared_pool_size=2281701376ptgbss.__streams_pool_size=0ptgbssdg.__streams_pool_size=0*.audit_file_dest='/u01/admin/ptgbss/adump' --此处修改*.audit_trail='db'*.compatible='11.2.0.4.0'*.control_files='/u01/oradata/ptgbssdg/control01.ctl','/u01/fast_recovery_area/ptgbssdg/control02.ctl' --此处修改存放控制文件路径*.db_block_size=8192*.db_domain=''*.db_file_name_convert='/data/ptgbss','/data/ptgbssdg' --此处修改*.db_name='ptgbss' --此处修改*.db_recovery_file_dest='/u01/fast_recovery_area' --此处修改对应的路径*.db_recovery_file_dest_size=4385144832*.db_unique_name='ptgbssdg' --此处修改*.diagnostic_dest='/u01'*.dispatchers='(PROTOCOL=TCP) (SERVICE=ptgbssXDB)'*.fal_client='PTGBSSDG' --此处修改*.fal_server='PTGBSS'  --此处修改*.log_archive_config='DG_CONFIG=(ptgbssdg,ptgbss)' --此处修改*.log_archive_dest_1='location=/data/arch' --此处修改*.log_archive_dest_2='SERVICE=ptgbssdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ptgbssdg' --此处修改*.log_archive_dest_state_1='ENABLE'  --修改此处参数*.log_archive_dest_state_2='ENABLE'  --修改此处参数*.log_file_name_convert='/u01/oradata/ptgbss','/u01/oradata/ptgbssdg'  --此处修改对应路径*.open_cursors=300*.pga_aggregate_target=3365928960*.processes=150*.remote_login_passwordfile='EXCLUSIVE'*.sga_max_size=19327352832*.sga_target=19327352832*.standby_file_management='AUTO'*.undo_tablespace='UNDOTBS1'

▼▼▼
rman target sys/oracle@ptgbss auxiliary sys/oracle@ptgbssdgrun{allocate channel cl1 type disk;allocate channel cl2 type disk;allocate channel cl3 type disk;allocate auxiliary channel c1 type disk;allocate auxiliary channel c2 type disk;allocate auxiliary channel c3 type disk;duplicate target database for standby from active database nofilenamecheck;release channel c1;release channel c2;release channel c3;}

▼▼▼
alter database open;alter database recover managed standby database using current logfile disconnect from session;select sequence#,thread#,applied from v$archived_log;

▼▼▼
col name for a50select name,SEQUENCE#,APPLIED from v$archived_log order by sequence#;

▼▼▼
select max(sequence#) from v$archived_log where applied='YES';select thread#,max(sequence#) from v$archived_log where applied='YES' group by thread#;