oracle adg介绍，adg搭建指南

[oracle@ptgbssdg ~]$ vi /u01/product/11.2.0/db_1/network/admin/listener.ora # listener.ora Network Configuration File: /u01/product/11.2.0/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = ptgbssdg)(PORT = 1521))    )  ) ADR_BASE_LISTENER = /u01 SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (GLOBAL_DBNAME = ptgbss)      (ORACLE_HOME = /u01/product/11.2.0/db_1)      (SID_NAME = ptgbssdg)    )  )

# tnsnames.ora Network Configuration File: /u01/product/11.2.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. 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=17448304640 ptgbssdg.__db_cache_size=16642998272 ptgbss.__java_pool_size=134217728 ptgbssdg.__java_pool_size=134217728 ptgbss.__large_pool_size=134217728 ptgbssdg.__large_pool_size=134217728 ptgbss.__oracle_base='/u01'#ORACLE_BASE set from environment ptgbssdg.__oracle_base='/u01'#ORACLE_BASE set from environment ptgbss.__pga_aggregate_target=3422552064 ptgbssdg.__pga_aggregate_target=3422552064 ptgbss.__sga_target=19327352832 ptgbssdg.__sga_target=19327352832 ptgbss.__shared_io_pool_size=0 ptgbssdg.__shared_io_pool_size=0 ptgbss.__shared_pool_size=1476395008 ptgbssdg.__shared_pool_size=2281701376 ptgbss.__streams_pool_size=0 ptgbssdg.__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'

sqlplus sys/oracle@ptgbss AS SYSDBA sqlplus sys/oracle@ptgbssdg AS SYSDBA

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;

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

select dest_id,error from v$archive_dest;

select * from v$archive_gap;