oracle_10g_dataguard详细配置步骤.doc
5墨值下载
新手上路，在几经辗转多方查看网上各路大侠的资料下，终于搞定了
dataguard
的物理
standby
配置问题，以及主备库的
switchover
。下面就基于网络上一篇配置文档，写下了我
的配置过程，愿似我这般新手可以少走弯路。
环境：
OS:RHL4+ORACLE10G10.2.0.1
IP:192.168.186.247(primary) 192.168.186.248(standby)
两个
linux
系统的主机名都是
Redhat
，因为一个是另一个的复制。。。是在没有用
dbca
创
建数据库的情况下。
ORACLE_SID:orcl
ORACLE_HOME:/u01/app/oracle/product/10.2.0/db_1
一、配置
standby database
为
MAXIMIZE PERFORMANCE
模式
二、转换模式由
MAXIMIZE PERFORMANCE
到
MAXIMIZE PROTECTION
三、主库和备库的
switchover.
正式开始：
一、配置
standby database
为
MAXIMIZE PERFORMANCE
模式
1.
设置主库为
force logging
SQL> alter database force logging;
2.
设置主库为归档模式：
SQL> archive log list
（如果不是归档模式则执行下面操作）
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> archive log list
3.
检查主机是否有口令文件
,
如没有需建立
orapwd file='/u01/app/oracle/product/10.2.0/db_1/dbs/orawporcl' password=king entries=5
（这里的
password
要根据个人设置情况，我当时就是没注意，结果主库无法实现向备库传
说归档日志，搞了半天，相当之郁闷！）
4.
为主数据库添加
"
备用联机日志文件
"
SQL> alter database add standby logfile group 4
'/u01/app/oracle/oradata/orcl/redo04.log' size 50m;
SQL> alter database add standby logfile group 5
'/u01/app/oracle/oradata/orcl/redo05.log' size 50m;
SQL> alter database add standby logfile group 6
'/u01/app/oracle/oradata/orcl/redo06.log' size 50m;
SQL> alter database add standby logfile group 7
'/u01/app/oracle/oradata/orcl/redo07.log' size 50m;
5.
修改主库参数文件（红色粗体为添加部分）
SQL> create pfile='/u01/app/oracle/admin/orcl/pfile/init.ora' from spfile;
orcl.__db_cache_size=100663296
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=54525952
orcl.__streams_pool_size=0
*.audit_file_dest='/oracle/admin/orcl/adump'
*.background_dump_dest='/oracle/admin/orcl/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.
ctl','/u01/app/oracle/oradata/orcl/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/orcl/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=10
*.log_archive_format='%T%S%r.ARC'
*.log_archive_max_processes=3
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=167772160
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/orcl/udump'
#add below parameter for standy database
*.DB_UNIQUE_NAME='10gpri'
*.log_archive_config='DG_CONFIG=(10gpri,10gstandby)'
*.log_archive_dest_1='location=/u01/app/oracle/oradata/orcl/archive/
VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=10gpri'
*.log_archive_dest_2='SERVICE=10gstandby arch ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=10gstandby'
*.STANDBY_FILE_MANAGEMENT=AUTO
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.FAL_SERVER='10gstandby'
*.FAL_CLIENT='10gpri'
6.
主库用
PFILE
建立
SPFILE
[oracle@Redhat pfile]$ sqlplus '/ as sysdba'
SQL> create spfile from pfile='/u01/app/oracle/admin/orcl/pfile/init.ora';
7.
建立备用库的控制文件
SQL> alter database create standby controlfile as '/u01/app/oracle/tmp/standby_ctl01.ctl';
8.
配置主数据库
listener
及
tnsnames
[oracle@Redhat admin]$ cat listener.ora
测试通过的：
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Redhat)(PORT = 1521))
)
)
[oracle@Redhat admin]$ cat tnsnames.ora
10gpri =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.186.247)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
10gstandby =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.186.248)(PORT = 1521))
of 8
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
相关文档
评论