Oracle physical Dataguard Maximum Performance mode deployment

Physical Dataguard Maximum Performance mode configuration process

Main Library Host EDBJR2P1

Repository Host EDBJR2P2

1. Create the main library

[Root@edbjr2p1 ~]# Xhost +

Access control disabled, clients can connect to any host

[Root@edbjr2p1 ~]# Su-oracle

[Oracle@edbjr2p1 ~]$ DBCA

The process of building a library is slightly ... Oracle_sid=orcl

2. Main Library parameters

[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, +, 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>

Create a directory to store the archive

[Oracle@edbjr2p1 admin]$ Mkdir/home/oracle/orcl_arclog

Continue changing parameters

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.

Transfer pfile files and password files

[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. Modify the transmitted Pfile file in the standby library

[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