五、备库环境准备
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
来源:( http://blog.sina.com.cn/s/blog_5ded2e5b0100f44a.html) - Oracle10g RAC环境下DataGuard备库搭建实例-2-eygle_伊帆_新浪博客[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`
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/90618/viewspace-665294/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/90618/viewspace-665294/