in Oracle

12cR1 RAC Posts — 8a : Setting up SingleInstance DG Standby for RAC

This is the first of a small series of subposts on setting up SingleInstance DataGuard Standby for my 12cR1 RAC environment.

Primary Database : 12cR1 MultiTenant RAC : 2 nodes, database on ASM
Standby Database : 12cR1 MultiTenant SingleInstance : 1 node, database on FileSystem

The “difficulties” are :
a. The Primary Database is MultiTenant with 1 PDB besides the SEED
b. The Primary Database is on ASM but the Standby is to be built on FileSystem
c. The Primary is a 2-node Cluster while the Standby is a SingleInstance installatin

This post is on the initial setup.

RAC Nodes
collabn1.racattack 192.168.78.51
collabn2.racattack 192.168.78.52

SingleInstance Node
oem132.racattack 192.168.78.100

Database Changes :
SQL> alter database force logging;
Database altered.
SQL> alter database flashback on;
Database altered.
SQL>
SQL> alter database add standby logfile size 50M;
Database altered.
SQL> alter database add standby logfile size 50M;
Database altered.
SQL> alter database add standby logfile size 50M;
Database altered.
SQL> alter database add standby logfile size 50M;
Database altered.
SQL> alter database add standby logfile size 50M;
Database altered.
SQL>
SQL>select group# , status, type, member from v$logfile order by 1;
Listener on Standby Server :
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oem132.racattack)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER=
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1)
(SID_NAME = STBY)
)
(SID_DESC =
(GLOBAL_NAME = STBY_DGMGRL)
(ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1)
(SID_NAME = STBY)
)
)

tnsnames.ora on first RAC Node :
STBY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oem132)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = STBY)
)
)

STBY_DGB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oem132)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = STBY_DGMGRL)
)
)

STBY Instance Parameter File :
compatible=12.1.0.2.0
db_name=RAC
db_unique_name=STBY
enable_pluggable_database=TRUE
sga_target=800M
db_file_name_convert=’+DATA/RAC’,’/u01/app/oracle/oradata/STBY’,’+FRA/RAC’,’/u01/app/oracle/fast_recovery_area/STBY’
log_file_name_convert=’+DATA/RAC’,’/u01/app/oracle/oradata/STBY’,’+FRA/RAC’,’/u01/app/oracle/fast_recovery_area/STBY’
db_create_file_dest=’/u01/app/oracle/oradata’
db_recovery_file_dest=’/u01/app/oracle/fast_recovery_area’
db_recovery_file_dest_size=16G
remote_login_passwordfile=EXCLUSIVE

Copying the Password File :
ASMCMD> pwcopy +DATA/RAC/PASSWORD/pwdrac.277.931824933 /var/tmp/RACPasswordFile
copying +DATA/RAC/PASSWORD/pwdrac.277.931824933 -> /var/tmp/RACPasswordFile
ASMCMD> exit
scp /var/tmp/RACPasswordFile oracle@oem132:/u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwSTBY

to be continued in post 8b on the filesystem directories for the STBY instance and the execution of the DUPLICATE DATABASE command.