一:Oracle DataGuard环境概述OS: CentOS5 + ORACLE10G 10.2.0.4.0IP:192.168.100.208(primary) 192.168.8.201(standby)ORACLE_SI
一:oracle dataguard环境概述
os: centos5 + oracle10g 10.2.0.4.0
ip:192.168.100.208(primary) 192.168.8.201(standby)
oracle_sid:jscn
oracle_home:/oracle/ora10/product
二,主数据库做准备
1.修改primary dba 为归档模式
sql> alter system set log_archive_dest_1='location=/oraarch/' scope=spfile;
sql> startup mount;
sql> alter database archivelog;
sql> alter database open;
2.将 primary 数据库置为 force logging 模式
sql> alter database force logging;
3.检查主机是否有口令文件,如没有需建立
orapwd file='/oracle/ora10/product/dbs/orapwjscn' password=sys
4.为主数据库添加"备用联机日志文件"
sql> alter database add standby logfile group 4 ('/oracle/ora10/oradata/jscn/redo04.log') size 50m;
sql> alter database add standby logfile group 5 ('/oracle/ora10/oradata/jscn/redo05.log') size 50m;
sql> alter database add standby logfile group 6 ('/oracle/ora10/oradata/jscn/redo06.log') size 50m;
sql> alter database add standby logfile group 7 ('/oracle/ora10/oradata/jscn/redo07.log') size 50m;
5.修改主库参数文件
sql> create pfile='/home/oracle/init_pr.ora' from spfile;
[oracle@10-208 jscn]$ vim /home/oracle/init_pr.ora
*********************************分割线开始***************************************
jscn.__db_cache_size=515899392
jscn.__java_pool_size=4194304
jscn.__large_pool_size=4194304
jscn.__shared_pool_size=536870912
jscn.__streams_pool_size=0
*.audit_file_dest='/oracle/ora10/admin/jscn/adump'
*.background_dump_dest='/oracle/ora10/admin/jscn/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/oracle/ora10/oradata/jscn/control01.ctl','/oracle/ora10/oradata/jscn/control02.ctl','/oracle/ora10/oradata/jscn/control03.ctl'
*.core_dump_dest='/oracle/ora10/admin/jscn/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=8
*.db_name='jscn'
*.db_recovery_file_dest='/oracle/ora10/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(protocol=tcp) (service=jscnxdb)'
*.job_queue_processes=10
#*.log_archive_dest_1='location=/oraarch/'
*.open_cursors=300
*.pga_aggregate_target=2684354560
*.processes=1500
*.remote_login_passwordfile='exclusive'
*.sessions=1655
*.sga_max_size=1073741824
*.sga_target=1073741824
*.undo_management='auto'
*.undo_tablespace='undotbs1'
*.user_dump_dest='/oracle/ora10/admin/jscn/udump'
###add below parameter for standy database
*.db_unique_name='10gpri'
*.log_archive_config='dg_config=(10gpri,10gstandby)'
*.log_archive_dest_1='location=/oraarch/ valid_for=(all_logfiles,all_roles) db_unique_name=10gpri'
*.log_archive_dest_2='service=10gstandby lgwr 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@host160 pfile]$ sqlplus / as sysdba
sql> create spfile from pfile='/home/oracle/init_pr.ora';
7.生成数据库备份
[oracle@10-208 ~]$ mkdir /oracle/rmanback/
rman> backup database format='/oracle/rmanback/%d_%s.dbf' plus archivelog;
8.建立备用库的控制文件
sql> alter database create standby controlfile as '/oracle/rmanback/standby_ctl01.ctl';
9.配置主数据库listener及tnsnames
[oracle@10-208 admin]$ vim listener.ora
sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = plsextproc)
(oracle_home = /oracle/ora10/product)
(program = extproc)
)
)
listener =
(description_list =
(description =
(address = (protocol = tcp)(host = 10-208)(port = 1521))
(address = (protocol = ipc)(key = extproc0))
)
)
[oracle@10-208 admin]$ cat tnsnames.ora
10gpri =
(description =
(address_list =
(address = (protocol = tcp)(host = 192.168.100.208)(port = 1521))
)
(connect_data =
(service_name = 10gpri)
)
)
10gstandby =
(description =
(address_list =
(address = (protocol = tcp)(host = 192.168.8.201)(port = 1521))
)
(connect_data =
(service_name = 10gstandby)
)
)
