tnsname,ora配置如下：
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools.
DG1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.219)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dg1) ) ) DG2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.230)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dg2) ) )
互相测试如下：
[oracle@dg-two ~]$ tnsping dg1 TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 15-APR-2014 23:49:55 Copyright (c) 1997, 2013, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.219)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = dg1))) OK (30 msec) [oracle@dg-two ~]$ [oracle@dg-one admin]$ tnsping dg2 TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 15-APR-2014 23:50:00 Copyright (c) 1997, 2013, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.230)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = dg2))) OK (20 msec) [oracle@dg-one admin]$
在备库创建临时参数文件：
[oracle@dg-two dbs]$ more initdg2.ora db_name=DG [oracle@dg-two dbs]$
主库查询：
SQL> select dbid,name from v$database;
DBID NAME
---------- ---------
1756848898 DG
2、copy主库密码文件到备库目录，且将备库启动到nomount状态：
[oracle@dg-two ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 16 00:05:21 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount; ORACLE instance started. Total System Global Area 217157632 bytes Fixed Size 2251816 bytes Variable Size 159384536 bytes Database Buffers 50331648 bytes Redo Buffers 5189632 bytes SQL>
3、在主库创建standby log file，当使用rman创建备库的时候，将在备库同步。
SQL> alter database add standby logfile '/u01/app/oracle/oradata/dg/std01.log' size 50m;
Database altered.
SQL> alter database add standby logfile '/u01/app/oracle/oradata/dg/std02.log' size 50m;
Database altered.
SQL> alter database add standby logfile '/u01/app/oracle/oradata/dg/std03.log' size 50m;
Database altered.
SQL> alter database add standby logfile '/u01/app/oracle/oradata/dg/std04.log' size 50m;
Database altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
1 1 10 52428800 512 1 NO CURRENT 1079725 15-APR-14 2.8147E+14
2 1 8 52428800 512 1 YES INACTIVE 1015435 15-APR-14 1045647 15-APR-14
3 1 9 52428800 512 1 YES INACTIVE 1045647 15-APR-14 1079725 15-APR-14
SQL> select * from v$standby_log;
GROUP# DBID THREAD# SEQUENCE# BYTES BLOCKSIZE USED ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME LAST_CHANGE# LAST_TIME
---------- ---------------------------------------- ---------- ---------- ---------- ---------- ---------- --- ---------- ------------- --------