五、备库环境准备

5.1、在备库添加指向主库的tnsnames

在备库的tnsnames.ora添加如下内容：

primary =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 200.200.200.11)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 200.200.200.22)(PORT = 1521))

(LOAD_BALANCE = yes)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = primary)

(FAILOVER_MODE =

(TYPE = SELECT)

  (METHOD = BASIC)

  (RETRIES = 180)

(DELAY = 5)

 )

)

)

5.2、在备库创建相关目录

包括adump,bdump,cdump,udump及数据文件目录等。

5.3、拷贝主库的密码文件到备库上

--拷贝rac1的密码文件到备库的$ORACLE_HOME/dbs下，并把该密码文件修改为orapwd。这里我的sid就用 rac1，所以，不用改名。

[oracle@rac1 dbs]$ scp orapwrac1 172.25.0.35:`pwd`

5.4、配置备库的监听

[oracle@standby admin]$ more listener.ora

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = standby)

(ORACLE_HOME = /opt/oracle/product/10.2/database)

(SID_NAME = rac1)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1521))

)

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

)

启动备库监听：lsnrctl start

5.5、设置备库参数文件

从主库rac1上根据spfile创建一个pfile文件，并传到备库上

SQL> create pfile from spfile;

SQL> exit

[oracle@rac1 ~]$ cd $ORACLE_HOME/dbs

[oracle@rac1 dbs]$ scp initrac1.ora 172.25.0.35:`pwd`  ==复制到stancby数据库==

  在备库上修改参数文件：

Ø   删除所有非"*"打头的参数设置及rac相关参数

Ø 设置dataguard参数

修改后参数如下：

[oracle@standby dbs]$ more initrac1.ora

*.audit_file_dest='/opt/oracle/admin/rac/adump'

*.background_dump_dest='/opt/oracle/admin/rac/bdump'

*.compatible='10.2.0.3'

*.control_files='/soft/oradata/rac/control01.ctl','/soft/oradata/rac/control02.ctl','/soft/oradata/rac/control03.ctl'

*.core_dump_dest='/opt/oracle/admin/rac/cdump'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_file_name_convert='/DEV/RAW/','/SOFT/ORADATA/RAC/'

*.db_name='rac'

*.db_unique_name='STANDBY'

*.fal_client='STANDBY'

*.fal_server='PRIMARY'

*.standby_file_management='AUTO' 

*.job_queue_processes=10

*.log_archive_config='DG_CONFIG=(primary,standby)'

*.log_archive_dest_1='LOCATION= /soft/oradata/archivelog/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standby'

*.log_archive_dest_2='SERVICE=primary LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=primary'

*.log_archive_dest_state_1='ENABLE'

*.log_archive_dest_state_2='ENABLE'

*.log_archive_format='%t_%s_%r.arc'

*.log_archive_max_processes=4

*.log_file_name_convert='/DEV/RAW/','/SOFT/ORADATA/RAC/'

*.open_cursors=300

*.pga_aggregate_target=16777216

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_max_size=157286400

*.sga_target=157286400

*.undo_management='AUTO'

undo_tablespace='UNDOTBS1'

*.user_dump_dest='/opt/oracle/admin/rac/udump'

以上 有些参数非必须设置的，但是为了switchover更方便，建议都修改上。

Undo表空间保留其中一个就可以。

路径转换相关参数要设置对，否则会报错。

5.6、把备库启动到nomount状态

[oracle@standby ~]$ sqlplus "/as sysdba"

SQL> startup nomount

5.7、从主库拷贝备份到备库上

之前备份的所有文件都拷贝到备库上，路径要和主库备份路径保持一致。如果不一致，linux下可以用ln的方式解决。

注意：两个节点都有归档的备份，要把这些备份都拷贝到备库上。==重要==

RAC1：

[oracle@rac1 backup]$ scp * 172.25.0.35:`pwd`

RAC2：

[oracle@rac2 backup]$ scp * 172.25.0.35:`pwd`