[Oracle] physical volume uard maximum performance mode deployment

During the configuration of the maximum performance mode of the physical worker uard, the master database host edbjr2p1 slave Database Host edbjr2p21. create the master database [root @ edbjr2p1 ~] # Xhost + accesscontrol

During the configuration process of the maximum performance mode of the physical worker uard, the master database host edbjr2p1 slave Database Host edbjr2p2 1. Create the master database [root @ edbjr2p1 ~] # Xhost + access control

Configuration process of maximum performance mode of physical volume uard

Master Database Host edbjr2p1

Slave Database Host edbjr2p2

1. Create a master database

[Root @ edbjr2p1 ~] # Xhost +

Access control disabled, clients can connect from any host

[Root @ edbjr2p1 ~] # Su-Oracle

[Oracle @ edbjr2p1 ~] $ Dbca

The database creation process is omitted... ORACLE_SID = ORCL

2. master database 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,200 5, Oracle. All rights reserved.

Connected:

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 archives

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

Change 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 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

[Oracle @ edbjr2p1 admin] $ scp $ ORACLE_HOME/dbs/orapwORCL edbjr2p2: $ ORACLE_HOME/dbs/orapwAUX1

Oracle @ edbjr2p2's password:

OrapwORCL 100% 1536 1.5KB/s

[Oracle @ edbjr2p1 admin] $

3. Modify the transmitted pfile in the standby Database

[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

The following are modified in the file:

*. 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/aux?arclog valid_for = (online_logfiles, all_roles) db_unique_name = aux1'

*. User_dump_dest = '/u01/app/oracle/admin/AUX1/udump'

The following are

*. 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'

Create a directory in the slave Database

[Oracle @ edbjr2p2 dbs] $ mkdir-p $ ORACLE_BASE/admin/AUX1/{a, B, c, u} dump

[Oracle @ edbjr2p2 dbs] $ mkdir/home/oracle/auxw.arclog

[Oracle @ edbjr2p2 dbs] $ mkdir/home/oracle/aux1_stdlog

[Oracle @ edbjr2p2 dbs] $ mkdir $ ORACLE_BASE/oradata/AUX1

,