primary主库
IP:192.168.50.4/24
dbname:ora10g
数据库版本：10g R2
操作系统版本：rhel6.0 64位
standby物理备库
IP：192.168.50.230/24
dbname:ora10g
数据库版本：10g R2
操作系统版本：rhel5.4 64位
一：配置Oracle网络，主库和备库两边都需要配置
[oracle@rhel6 ~]$ vi /u01/app/oracle/network/admin/tnsnames.ora
PRIMARY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.50.4)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora10g.766.com)
)
)
STANDBY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.50.230)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora10g.766.com)
)
)
二：主库端配置，修改初始化参数，生成备库的控制文件
SQL> alter database force logging;
Database altered.
SQL> select force_logging from v$database;
FORCE_LOG
---------
YES
SQL> create pfile='/home/oracle/initora10g.ora' from spfile;
File created.
文件末尾处添加
log_archive_dest_1='LOCATION=/u01/arch/'
log_archive_dest_state_1=enable
log_archive_dest_2='SERVICE=standby'
log_archive_dest_state_2=enable
log_archive_format='%t_%s_%r.arc'
log_archive_max_processes=2
fal_server=standby
fal_client=primary
db_unique_name=ora10g
SQL> alter database create standby controlfile as '/u01/app/oradata/ora10g/standby.ctl';
Database altered.
关闭主库
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
三：备库端配置
[oracle@localhost ~]$ scp -rvp 192.168.50.4:/u01/app/oradata/ora10g /u01/app/oradata
[oracle@localhost ~]$ scp 192.168.50.4:/home/oracle/initora10g.ora /u01/app/oracle/dbs/
修改参数内容如下：
log_archive_dest_1='LOCATION=/u01/arch/'
log_archive_dest_state_1=enable
log_archive_dest_2='SERVICE=primary'
log_archive_dest_state_2=enable
log_archive_format='%t_%s_%r.arc'
log_archive_max_processes=2
fal_server=primary
fal_client=standby
db_unique_name=ora10g
创建相关目录和文件
[oracle@localhost ~]$ mkdir /u01/arch/
[oracle@localhost ~]$ mkdir -p /u01/app/admin/ora10g/{adump,bdump,cdump,udump}
[oracle@localhost ~]$ cd /u01/app/oradata/ora10g/
[oracle@localhost ora10g]$ mv standby.ctl control01.ctl
[oracle@localhost ora10g]$ cp control01.ctl control02.ctl
[oracle@localhost ora10g]$ cp control01.ctl control03.ctl
[oracle@localhost ~]$ orapwd file=$ORACLE_HOME/dbs/orapwora10g password=123456 entries=5
四：测试
启动主库：
Connected to an idle instance.
SQL> create spfile from pfile='/home/oracle/initora10g.ora';
File created.
SQL> startup
SQL> select name,database_role from v$database;
NAME DATABASE_ROLE
--------------------------- ------------------
ORA10G PRIMARY
启动备库：
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 4 16:49:39 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> create spfile from pfile;
File created.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 629145600 bytes
Fixed Size 2022824 bytes
Variable Size 180355672 bytes
Database Buffers 440401920 bytes
Redo Buffers 6365184 bytes
SQL> select name,database_role from v$database;