RAC To Single Instance Physical Standby
RAC To Single Instance Physical Standby
RAC To Single Instance Physical Standby
Oracle 11g new feature of active database duplication could also be used for creating standby databases in data guard configurations.
This blog uses the same RAC configuration used for active database duplication to create a single instance physical standby
database.
olsnodes -n
rac4 1
rac5 2
Data files and logfiles are in two ASM diskgroups called +DATA and +FLASH.
Physical standby database will have it's files in the local file system and will be referred to as stdby through out the blog.
1. Instance Oracle Enterprise Edition software on the host where physical standby will reside. In addition to this also create the
necessary directory structures such as adump ($ORACLE_BASE/admin/sid name/adump) and directories for controlfiles, datafiles
and onlinelogs, though the configuration uses OMF once the setup is completed, these directories are required in the beginning to
complete the setup. (not required if instead of OMF, some other directory path is referenced). For this configuration following
cd /data/oradata
mkdir STDBY
cd STDBY
mkdir controlfile datafile onlinelog
cd cd /data/flash_recovery
mkdir STDBY
cd STDBY
mkdir onlinelog
STDBYTNS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = standby-host)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = stdby)
)
)
PRIMARYTNS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-host)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac11g2)
)
)
In this case only one instance will be used to fetch archive log gaps and to send redo when the switch over happens. In a RAC
standby multiple instances can receive but there can only be one applier.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = stdby)
(SID_NAME = stdby)
(ORACLE_HOME = /opt/app/oracle/product/11.2.0/ent)
)
)
6. Create standby log files for each thread on primary. These should be same size as the online redo log files
or
There should be at least one more redo log group per thread than the online redo logs.
6. Add Data Guard related initialization parameters to primary. These include, information about the instances involved in the data
guard configuration, redo transport parameters such SYNC,ASYNC, AFFIRM, NOAFFIRM, fetch archive log client and server values
7. Copy the password file to standby host's ORACLE_HOME/dbs and rename the file. Assuming password file is copied to the
standby host
mv orapwrac11g22 orapwstdby
*.db_name='stdby'
9. Start the standby instance using the above mentioned pfile in nomount mode
10. On the primary using rman connect to primary db as target and standby as the auxiliary and run the active duplication command
to create the standby. Some of the RAC only parameters has been reset while others have been set to reflect the standby database
This will start the duplication and creation of the physical standby
If any parameter setting has some configuration mismatches and still referrers to ASM for files then the duplication process will
terminate with
11. Once successfully completed start redo apply on the standby with
or