一、环境

OS：RHEL 5.3
DB：ORACLE 10.2.0.1.0
主库IP：169.154.0.11
备库IP：169.254.0.11

主库目录结构

/u01/oldyang/tempfiles
/u02/oldyang/controlfile02
/u03/oldyang/controlfile03
/u02/oldyang/redo01
/u02/oldyang/redo02
/u02/oldyang/oradata01
/u02/oldyang/oradata02
/u02/oldyang/oradata03
/u02/oldyang/oradata04
/u03/oldyang/archivelog
/u03/oldyang/backup

备库目录结构

/u01/youngyang/tempfiles
/u02/youngyang/controlfile02
/u03/youngyang/controlfile03
/u02/youngyang/redo01
/u02/youngyang/redo02
/u02/youngyang/oradata01
/u02/youngyang/oradata02
/u02/youngyang/oradata03
/u02/youngyang/oradata04
/u03/youngyang/archivelog
/u03/youngyang/backup

二、主库部分

1. 主库参数

#dataguard
db_unique_name=pri

*.log_archive_config='DG_CONFIG=(pri,std)'
*.log_archive_dest_1='LOCATION=/u03/oldyang/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=pri'
*.log_archive_dest_2='SERVICE=standby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=std'
*.log_archive_dest_state_1=ENABLE
*.log_archive_dest_state_2=ENABLE
*.FAL_SERVER=standby
*.FAL_CLIENT=primary
*.remote_login_passwordfile='EXCLUSIVE'
*.standby_file_management=AUTO

*.db_file_name_convert=('/u01/youngyang/tempfiles/','/u01/oldyang/tempfiles/',
'/u02/youngyang/oradata01/','/u02/oldyang/oradata01/',
'/u02/youngyang/oradata02/','/u02/oldyang/oradata02/',
'/u02/youngyang/oradata03/','/u02/oldyang/oradata03/',
'/u02/youngyang/oradata04/','/u02/oldyang/oradata04/')
*.log_file_name_convert=('/u02/youngyang/redo01/','/u02/oldyang/redo01/',
'/u02/youngyang/redo02/','/u02/oldyang/redo02/')
#dataguard

*.control_files='/u01/oldyang/controlfile01/control01.ctl',
'/u02/oldyang/controlfile02/control02.ctl',
'/u03/oldyang/controlfile03/control03.ctl'
*.__db_cache_size=83886080
*.__java_pool_size=4194304
*.__large_pool_size=4194304
*.__shared_pool_size=71303168
*.__streams_pool_size=0
*.audit_file_dest='/opt/oracle/admin/oldyang/adump'
*.background_dump_dest='/opt/oracle/admin/oldyang/bdump'
*.compatible='10.2.0.1.0'
*.core_dump_dest='/opt/oracle/admin/oldyang/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=8
*.db_name='oldyang'
*.db_recovery_file_dest='/u03/oldyang/backup'
*.db_recovery_file_dest_size=1073741824
*.dispatchers='(PROTOCOL=TCP) (SERVICE=oldyangXDB)'
*.job_queue_processes=10
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=50

2. vi tnsnames.ora

standby =
　　(DESCRIPTION =
　　　 (ADDRESS = (PROTOCOL = TCP)(HOST = 169.254.0.12)(PORT = 1521))
　　　(CONNECT_DATA =
　　　　(SERVICE_NAME = oldyang)
　　　)
　　 )

3. vi listener.ora

SID_LIST_LISTENER =
　　(SID_LIST =
　　　(SID_DESC =
　　　　(SID_NAME = PLSExtProc)
　　　　(ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
　　　　(PROGRAM = extproc)
　　)
　　(SID_DESC =
　　　(GOLBAL_DBNAME = yang_pri)
　　　(ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
　　　 (SID_NAME = oldyang)
　　)

)

LISTENER =
　　(DESCRIPTION_LIST =
　　　 (DESCRIPTION =
　　　　 (ADDRESS = (PROTOCOL = TCP)(HOST = 169.254.0.11)(PORT = 1521))
　　　　 (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
　　　 )
　)

三、备库部分

1.备库参数

#dataguard
*.db_unique_name=std

*.log_archive_config='DG_CONFIG=(pri,std)'
*.log_archive_dest_1='LOCATION=/u03/youngyang/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=std'
*.log_archive_dest_2='SERVICE=primary LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=pri'
*.log_archive_dest_state_1=ENABLE
*.log_archive_dest_state_2=ENABLE
*.FAL_SERVER=primary
*.FAL_CLIENT=standby
*.remote_login_passwordfile='EXCLUSIVE'
*.standby_file_management=AUTO

*.db_file_name_convert=('/u01/oldyang/tempfiles/','/u01/youngyang/tempfiles/',
'/u02/oldyang/oradata01/','/u02/youngyang/oradata01/',
'/u02/oldyang/oradata02/','/u02/youngyang/oradata02/',
'/u02/oldyang/oradata03/','/u02/youngyang/oradata03/',
'/u02/oldyang/oradata04/','/u02/youngyang/oradata04/')
*.log_file_name_convert=('/u02/oldyang/redo01/','/u02/youngyang/redo01/',
'/u02/oldyang/redo02/','/u02/youngyang/redo02/')
#dataguard

*.control_files='/u01/youngyang/controlfile01/control01.ctl',
'/u02/youngyang/controlfile02/control02.ctl',
'/u03/youngyang/controlfile03/control03.ctl'
*.__db_cache_size=83886080
*.__java_pool_size=4194304
*.__large_pool_size=4194304
*.__shared_pool_size=71303168
*.__streams_pool_size=0
*.audit_file_dest='/opt/oracle/admin/youngyang/adump'
*.background_dump_dest='/opt/oracle/admin/youngyang/bdump'
*.compatible='10.2.0.1.0'
*.core_dump_dest='/opt/oracle/admin/youngyang/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=8
*.db_name='oldyang'
*.db_recovery_file_dest='/u03/youngyang/backup'
*.db_recovery_file_dest_size=1073741824
*.dispatchers='(PROTOCOL=TCP) (SERVICE=oldyangXDB)'
*.job_queue_processes=10
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=50

2. vi tnsnames.ora

primary =
　 (DESCRIPTION =
　　 (ADDRESS = (PROTOCOL = TCP)(HOST = 169.254.0.11)(PORT = 1521))
　　(CONNECT_DATA =
　　　(SERVICE_NAME = oldyang)
　　)
　)

3. vi listener.ora

SID_LIST_LISTENER =
　(SID_LIST =
　　 (SID_DESC =
　　　 (SID_NAME = PLSExtProc)
　　　　(ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
　　　 (PROGRAM = extproc)
　　 )
　　(SID_DESC =
　　　(GOLBAL_DBNAME = yang_std)
　　　(ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
　　　(SID_NAME = oldyang)
　　)

　 )

LISTENER =
　(DESCRIPTION_LIST =
　　 (DESCRIPTION =
　　　(ADDRESS = (PROTOCOL = TCP)(HOST = 169.254.0.12)(PORT = 1521))
　　　(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
　　)
　)

4. 建立目录

mkdir /opt/oracle/admin/
mkdir /opt/oracle/admin/youngyang
mkdir /opt/oracle/admin/youngyang/adump
mkdir /opt/oracle/admin/youngyang/bdump
mkdir /opt/oracle/admin/youngyang/cdump
mkdir /opt/oracle/admin/youngyang/dpdump
mkdir /opt/oracle/admin/youngyang/pfile
mkdir /opt/oracle/admin/youngyang/scripts
mkdir /opt/oracle/admin/youngyang/udump

5. 建立口令文件

orapwd file=$ORACLE_HOME/dbs/orapwoldyang password=orcl entries=30