【Oracle】物理DataGuard最大性能模式部署
物理DATAGUARD最大性能模式配置过程
主库主机edbjr2p1
备库主机edbjr2p2
1.创建主库
[root@edbjr2p1 ~]# xhost +
access control disabled, clients can connect from any host
[root@edbjr2p1 ~]# su - Oracle
[oracle@edbjr2p1 ~]$ dbca
建库过程略。。。ORACLE_SID=ORCL
2.主库参数
[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 - Production
With the Partitioning, OLAP and Data Mining options
SYS@ORCL>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@ORCL>startup mount
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218968 bytes
Variable Size 88082024 bytes
Database Buffers 188743680 bytes
Redo Buffers 7168000 bytes
Database 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.ora
oracle@edbjr2p2's password:
initORCL.ora 100% 1178 1.2KB/s 00:00
[oracle@edbjr2p1 admin]$ scp $ORACLE_HOME/dbs/orapwORCL edbjr2p2:$ORACLE_HOME/dbs/orapwAUX1
oracle@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]$ ls
initAUX1.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