【Oracle】物理DataGuard最大性能模式部署

物理DATAGUARD最大性能模式配置过程主库主机edbjr2p1备库主机edbjr2p21.创建主库[root@edbjr2p1 ~]# xhost +access control disabled, clients can connect from any host[root@edbjr2p1 ~]# su - Oracle[oracle@edbjr2p1 ~]$ dbca建库过程略。。。ORACLE_SID=ORCL2.主库参数[oracle@edbjr2p1 ~]$ export ORACLE_SID=ORCL[oracle@edbjr2p1 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 31 09:20:03 2013 Copyright （c） 1982, 2005, Oracle. All rights reserved. Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options SYS@ORCL>shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SYS@ORCL>startup mountORACLE instance started. Total System Global Area 285212672 bytesFixed Size 1218968 bytesVariable Size 88082024 bytesDatabase Buffers 188743680 bytesRedo Buffers 7168000 bytesDatabase mounted.SYS@ORCL>select status from v$instance; STATUS------------MOUNTED SYS@ORCL>alter database force logging; Database altered. SYS@ORCL>select log_mode from v$database; LOG_MODE------------NOARCHIVELOG SYS@ORCL>SYS@ORCL>alter database archivelog; Database altered. SYS@ORCL>alter system set log_archive_config="dg_config=（orcl,aux1）"; System altered. SYS@ORCL>alter system set log_archive_dest_10="location=/home/oracle/orcl_arclog valid_for=（online_logfiles,all_roles） db_unique_name=orcl"; System altered. SYS@ORCL> 创建目录用于存放归档[oracle@edbjr2p1 admin]$ mkdir /home/oracle/orcl_arclog 继续更改参数SYS@ORCL>alter system set log_archive_dest_1="service=aux1 valid_for=（online_logfiles,primary_role） db_unique_name=aux1"; System altered. SYS@ORCL>alter system set log_archive_max_processes=4; System altered. SYS@ORCL>create pfile from spfile; File created. 传输pfile文件和密码文件[oracle@edbjr2p1 admin]$ scp $ORACLE_HOME/dbs/initORCL.ora edbjr2p2:$ORACLE_HOME/dbs/initAUX1.oraoracle@edbjr2p2"s password:initORCL.ora 100% 1178 1.2KB/s 00:00 [oracle@edbjr2p1 admin]$ scp $ORACLE_HOME/dbs/orapwORCL edbjr2p2:$ORACLE_HOME/dbs/orapwAUX1oracle@edbjr2p2"s password:orapwORCL 100% 1536 1.5KB/s 00:00 [oracle@edbjr2p1 admin]$ 3.在备库中修改传输过来的pfile文件[root@edbjr2p2 ~]# su - oracle[oracle@edbjr2p2 ~]$ cd $ORACLE_HOME/dbs[oracle@edbjr2p2 dbs]$ lsinitAUX1.ora initdw.ora init.ora orapwAUX1[oracle@edbjr2p2 dbs]$ vi initAUX1.ora以下是在文件中修改的*.audit_file_dest="/u01/app/oracle/admin/AUX1/adump"*.background_dump_dest="/u01/app/oracle/admin/AUX1/bdump"*.control_files="/u01/app/oracle/oradata/AUX1/control01.ctl","/u01/app/oracle/oradata/AUX1/control02.ctl","/u01/app/oracle/oradata/AUX1/control03.ctl"*.core_dump_dest="/u01/app/oracle/admin/AUX1/cdump"*.log_archive_dest_10="location=/home/oracle/aux1_arclog valid_for=（online_logfiles,all_roles） db_unique_name=aux1"*.user_dump_dest="/u01/app/oracle/admin/AUX1/udump"以下是在文件中添加的*.db_unique_name="AUX1"*.standby_archive_dest="/home/oracle/aux1_stdlog"*.db_file_name_convert=（"/u01/app/oracle/oradata/ORCL/","/u01/app/oracle/oradata/AUX1/"）*.log_file_name_convert=（"/u01/app/oracle/oradata/ORCL/","/u01/app/oracle/oradata/AUX1/"）*.standby_file_management="auto" 在备库中创建目录[oracle@edbjr2p2 dbs]$ mkdir -p $ORACLE_BASE/admin/AUX1/{a,b,c,u}dump[oracle@edbjr2p2 dbs]$ mkdir /home/oracle/aux1_arclog[oracle@edbjr2p2 dbs]$ mkdir /home/oracle/aux1_stdlog[oracle@edbjr2p2 dbs]$ mkdir $ORACLE_BASE/oradata/AUX1

DataGuard相关参数【Oracle】v$session和v$process的使用相关资讯 DataGuard

DataGuard如何传送Redo到Standby （05月04日）
RAC环境下DataGuard到单机（04月08日）
Oracle 11G R2 DataGuard日常维护（02月20日）

MRP0- Background Media Recovery （04月16日）
DataGuard环境中的密码维护（03月17日）
Oracle 11G R2利用RMAN搭建（02月20日）

本文评论查看全部评论（0）