{"id":2461,"date":"2017-10-12T11:11:32","date_gmt":"2017-10-12T08:11:32","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2461"},"modified":"2019-10-23T16:33:57","modified_gmt":"2019-10-23T13:33:57","slug":"oracle-12c-r2-12-2-0-1-real-time-apply-data-guard-installation-on-oracle-linux-7-3","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-12-2-0-1-real-time-apply-data-guard-installation-on-oracle-linux-7-3\/","title":{"rendered":"Oracle 12c R2 (12.2.0.1) Real Time Apply Data Guard Installation on Oracle Linux 7.3"},"content":{"rendered":"

Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Data Guard maintains these standby databases as copies of the production database.Then, if the production database becomes unavailable because of a planned or an unplanned outage, Oracle Data Guard can switch any standby database to the production role, minimizing the downtime associated with the outage. Oracle Data Guard can be used with traditional backup, restoration, and cluster techniques to provide a high level of data protection and data availability.<\/p>\n

With Oracle Data Guard, administrators can optionally improve production database performance by offloading resource-intensive backup and reporting operations to standby systems.<\/p>\n

Types of standby databases are Physical standby database, Logical standby database and Snapshot standby database.<\/p>\n

I will demonstrate Physical standby database as working real time apply at this document. Most used type is Physical standby database type. You can investigate other types of standby database from Oracle docs.<\/p>\n

\"\"<\/p>\n

I used Oracle RAC database as primary side and I used single instance database with asm file system as secondary side (Data Guard).<\/p>\n

Firstly, you have to adjust system parameters of operating system on secondary side and create asm disks. After, you can start to install of grid infrastructure. You can create disk groups for DATA and FRA disk groups after install grid. After grid installation, you can install Oracle Data Guard database on grid infrastructure and ASM disks as software only. Finally you can restore and recover standby database from primary side and you can start synchronization apply after add standby redo log.\u00a0I divide the stages of installation five steps.<\/p>\n

You can find primary side (Oracle 12c RAC) installation steps here<\/a>. I will use this infrastructure as primary side.<\/p>\n

First Step : Configure Operation System on Secondery Side<\/h3>\n

1. Upgrade Packages<\/strong><\/p>\n

yum upgrade<\/p>\n

yum install oracleasm-support<\/p><\/blockquote>\n

<\/p>\n

2. Selinux Disable<\/strong><\/p>\n

You can do disabled or permissive<\/p>\n

vi \/etc\/selinux\/config<\/p>\n

SELINUX=disabled<\/p><\/blockquote>\n

3. Firewall Close and Disable<\/strong><\/p>\n

You can open after installation,but you have to give permission to necessary ports and services.<\/p>\n

systemctl stop firewalld.service<\/p>\n

systemctl disable firewalld.service<\/p><\/blockquote>\n

4. Create Users<\/strong><\/p>\n

groupadd \u2013g 501 oinstall<\/p>\n

groupadd \u2013g 502 dba<\/p>\n

groupadd \u2013g 503 oper<\/p>\n

groupadd \u2013g 504 asmadmin<\/p>\n

groupadd \u2013g 505 asmdba<\/p>\n

groupadd \u2013g 506 asmoper<\/p>\n

useradd \u2013u 502 \u2013g oinstall \u2013G dba,asmdba,oper oracle<\/p>\n

passwd oracle<\/p>\n

useradd \u2013u 501 \u2013g oinstall \u2013G asmadmin,asmoper,asmdba grid<\/p>\n

passwd grid<\/p>\n<\/blockquote>\n

5. Configure Bash Profile of Users<\/strong><\/p>\n

Oracle User<\/b><\/p>\n

vi .bash_profile<\/p>\n

# Oracle Settings<\/p>\n

export TMP=\/tmp<\/p>\n

export TMPDIR=$TMP<\/p>\n

export ORACLE_HOSTNAME=test12cdg.yourdomain<\/p>\n

export ORACLE_UNQNAME=TDG<\/p>\n

export ORACLE_BASE=\/oracle\/db\/12.2.0.1<\/p>\n

export DB_HOME=$ORACLE_BASE\/db_home<\/p>\n

export ORACLE_HOME=$DB_HOME<\/p>\n

export ORACLE_SID=TDG<\/p>\n

export ORACLE_TERM=xterm<\/p>\n

export BASE_PATH=\/usr\/sbin:$PATH<\/p>\n

export PATH=$ORACLE_HOME\/bin:$BASE_PATH<\/p>\n

export LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib<\/p>\n

export CLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib<\/p>\n

alias sql=’sqlplus \/ as sysdba’<\/p>\n

PATH=$PATH:$HOME\/.local\/bin:$HOME\/bin<\/p>\n

export PATH<\/p>\n

 <\/p>\n

Grid User<\/b><\/p>\n

# Oracle Settings<\/p>\n

export TMP=\/tmp<\/p>\n

export TMPDIR=$TMP<\/p>\n

export ORACLE_HOSTNAME=test12cdg.yourdomain<\/p>\n

export ORACLE_UNQNAME=TDG<\/p>\n

export ORACLE_BASE=\/oracle\/gridbase\/12.2.0.1<\/p>\n

export GRID_BASE=\/oracle\/gridbase\/12.2.0.1<\/p>\n

export GRID_HOME=\/oracle\/grid\/12.2.0.1\/grid_home<\/p>\n

export ORACLE_HOME=\/oracle\/grid\/12.2.0.1\/grid_home<\/p>\n

export ORACLE_SID=+ASM<\/p>\n

export ORACLE_TERM=xterm<\/p>\n

export BASE_PATH=\/usr\/sbin:$PATH<\/p>\n

export PATH=$ORACLE_HOME\/bin:$BASE_PATH<\/p>\n

export LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib<\/p>\n

export CLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib<\/p>\n

alias sql=’sqlplus \/ as sysasm’<\/p>\n

PATH=$PATH:$HOME\/.local\/bin:$HOME\/bin<\/p>\n

export PATH<\/p><\/blockquote>\n

6. Create Directories<\/strong><\/p>\n

mkdir -p \/oracle\/grid\/12.2.0.1\/grid_home<\/p>\n

mkdir -p \/oracle\/grid\/12.2.0.1\/log<\/p>\n

mkdir -p \/oracle\/gridbase\/12.2.0.1\/<\/p>\n

mkdir -p \/oracle\/db\/12.2.0.1\/db_home<\/p>\n

chown -R oracle.oinstall \/oracle\/<\/p>\n

chown -R grid.oinstall \/oracle\/grid*<\/p>\n

chmod -R 775 \/oracle\/<\/p><\/blockquote>\n

7. Configure ASM Disks<\/strong><\/p>\n

*Your disk name can be different from I used. I configured sdc, sdd,sde disks for asm on my test suite. These sd* disks can be different on your system.<\/p>\n

with root user.<\/p>\n

oracleasm configure -i<\/p>\n

Answers of Questions;<\/p>\n

grid<\/p>\n

asmadmin<\/p>\n

y<\/p>\n

y<\/p>\n

After finish configuration you can make init with below command.<\/p>\n

oracleasm init<\/p>\n

Create partition.<\/p>\n

fdisk \/dev\/sdc<\/p>\n

fdisk \/dev\/sdd<\/p>\n

fdisk \/dev\/sde<\/p>\n

oracleasm createdisk DATA1 \/dev\/sdc1<\/p>\n

oracleasm createdisk FRA1 \/dev\/sdd1<\/p>\n

oracleasm createdisk GRID1 \/dev\/sde1<\/p>\n

You can use scandisks and listdisks to control.<\/p>\n

oracleasm scandisks<\/p>\n

oracleasm listdisks<\/p><\/blockquote>\n

 <\/p>\n

8. Configure Passwordless SSH Connection<\/strong><\/p>\n

You have to configure ssh passwordless connection. Oracle and Grid user of primary and secondary side have to connect each other passwordless.<\/p>\n

You can find how to do this step here<\/a>.<\/p><\/blockquote>\n

9. Chrony NTP Configuration<\/strong><\/p>\n

Chrony plugin came with Oracle Linux 7 version for ntp sync. You can write your ntp server information in \/etc\/chrony.conf file.<\/p>\n

vi \/etc\/chrony.conf<\/p>\n

server ntp.yourdomain<\/p>\n

systemctl restart chronyd.service<\/p>\n

systemctl enable chronyd.service<\/p><\/blockquote>\n

10. Configure Hosts File<\/strong><\/p>\n

You can write your domain name info instead of yourdomain text. Also, you can give IP addresses as your IP structure. You have to write IP and domain information to \/etc\/hosts file if you do not use dns server.<\/p>\n

You have to add “40.50.60.100 tdg tdg.yourdomain” line on primary side.\u00a040.50.60.100 IP address is our data guard server IP address.<\/p>\n

vi \/etc\/hosts<\/p>\n

20.10.4.141 ractest12c01 ractest12c01.yourdomain<\/p>\n

20.10.4.142 ractest12c02 ractest12c02.yourdomain<\/p>\n

20.10.4.143 ractest12c01-vip ractest12c01-vip.yourdomain<\/p>\n

20.10.4.144 ractest12c02-vip ractest12c02-vip.yourdomain<\/p>\n

20.10.4.145 ractest12c-scan ractest12c-scan.yourdomain<\/p>\n

20.10.4.146 ractest12c-scan ractest12c-scan.yourdomain<\/p>\n

20.10.4.147 ractest12c-scan ractest12c-scan.yourdomain<\/p>\n

40.50.60.100 test12cdg test12cdg.yourdomain<\/p><\/blockquote>\n

11. DNS Register (optional)<\/strong><\/p>\n

You can configure dns information of nodes in \/etc\/resolf.conf file.<\/p><\/blockquote>\n

12. Preinstallation Package Intallation<\/strong><\/p>\n

yum install oracle-database-server-12cR2-preinstall<\/p>\n

reboot<\/p><\/blockquote>\n

Second Step : Install Grid Infrastructure<\/h3>\n

You have to copy your grid installation files to grid_home. I recommend that you copy grid zip file to grid home and change owner of zip file, and unzip with grid user.<\/p>\n

Copy and Unzip Grid Files<\/strong><\/p>\n

cp linuxx64_12201_grid_home.zip \/oracle\/grid\/12.2.0.1\/grid_home<\/p>\n

chown grid.oinsall linuxx64_12201_grid_home.zip<\/p>\n

su – grid<\/p>\n

unzip linuxx64_12201_grid_home.zip<\/p><\/blockquote>\n

Display Config and Start Grid Installation<\/strong><\/p>\n

su –<\/p>\n

export DISPLAY=:0.0<\/p>\n

xhost +<\/p>\n

su – grid<\/p>\n

export DISPLAY=:0.0<\/p>\n

xhost +<\/p>\n

cd \/$GRID_HOME\/<\/p>\n

.\/grid_Setup.sh<\/p><\/blockquote>\n

\"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\"<\/p>\n

Fix & Check Again button creates fix scripts to resolve warnings. You have to run this scripts to resolve warnings.<\/p>\n

\"\" \"\" \"\"<\/p>\n

You have to run this scripts respectively. The run can be a bit long. You can click OK, after run scripts. If you do not get an error, you can continue.<\/p>\n

\"\" \"\" \"\"<\/p>\n

You can check your grid status with crs_stat -t<\/strong> and crsctl stat res -t<\/strong> commands with grid user.<\/p>\n

Third Step : Create ASM Disk Group For DATA and FRA<\/h3>\n

Display Config and Start ASMCA<\/strong><\/p>\n

su –<\/p>\n

export DISPLAY=:0.0<\/p>\n

xhost +<\/p>\n

su – grid<\/p>\n

export DISPLAY=:0.0<\/p>\n

xhost +<\/p>\n

asmca<\/p><\/blockquote>\n

\"\" \"\" \"\" \"\"<\/p>\n

Fourth Step : Install Database as Software Only<\/h3>\n

You can unzip database file under \/tmp\/ and you have to give permission oracle user.<\/p>\n

chown oracle.oinstall -R \/tmp\/database\/<\/p>\n

Display Config and Start Database Installation<\/strong><\/p>\n

su –<\/p>\n

export DISPLAY=:0.0<\/p>\n

xhost +<\/p>\n

su – oracle<\/p>\n

export DISPLAY=:0.0<\/p>\n

xhost +<\/p>\n

cd \/tmp\/database\/<\/p>\n

.\/runInstaller<\/p><\/blockquote>\n

\"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\"<\/p>\n

Fifth Step : Restore Database And Synchronize<\/h3>\n

Now, we have to configure primary and secondary side to data transport for data guard.<\/p>\n

1. Listener Configuration<\/strong><\/p>\n

I use different port to connect of primary side and secondary side.<\/p>\n

Primary Side Rac Node 1<\/strong><\/p>\n

su – oracle<\/p>\n

cd $ORACLE_HOME\/network\/admin<\/p>\n

vi listener.ora<\/p>\n

listener_dr_for_arch_test =<\/p>\n

(ADDRESS_LIST =<\/p>\n

(ADDRESS= (PROTOCOL= TCP)(Host= ractest12c01-vip.sm.gov.tr)(Port= 1545))<\/p>\n

)<\/p>\n

 <\/p>\n

SID_LIST_listener_dr_for_arch_test =<\/p>\n

(SID_LIST =<\/p>\n

(SID_DESC =<\/p>\n

(ORACLE_HOME= \/oracle\/db\/12.2.0.1\/db_home)<\/p>\n

(SID_NAME = RACTEST1)<\/p>\n

)<\/p>\n

)<\/p>\n

 <\/p>\n

Start Listener<\/strong><\/p>\n

lsnrctl start listener_dr_for_arch_test<\/p>\n

 <\/p>\n

Primary Side Rac Node 2<\/strong><\/p>\n

su – oracle<\/p>\n

cd $ORACLE_HOME\/network\/admin<\/p>\n

vi listener.ora<\/p>\n

listener_dr_for_arch_test =<\/p>\n

(ADDRESS_LIST =<\/p>\n

(ADDRESS= (PROTOCOL= TCP)(Host= ractest12c02-vip.sm.gov.tr)(Port= 1545))<\/p>\n

)<\/p>\n

SID_LIST_listener_dr_for_arch_test =<\/p>\n

(SID_LIST =<\/p>\n

(SID_DESC =<\/p>\n

(ORACLE_HOME= \/oracle\/db\/12.2.0.1\/db_home)<\/p>\n

(SID_NAME = RACTEST2)<\/p>\n

)<\/p>\n

)<\/p>\n

 <\/p>\n

Start Listener<\/strong><\/p>\n

lsnrctl start listener_dr_for_arch_test<\/p>\n

 <\/p>\n

Secondary Side<\/strong><\/p>\n

su – oracle<\/p>\n

cd $ORACLE_HOME\/network\/admin<\/p>\n

vi listener.ora<\/p>\n

listener_dr_for_arch_test =<\/p>\n

(ADDRESS_LIST =<\/p>\n

(ADDRESS= (PROTOCOL= TCP)(Host = test12cdg.sm.gov.tr)(Port= 1545))<\/p>\n

)<\/p>\n

 <\/p>\n

SID_LIST_listener_dr_for_arch_test =<\/p>\n

(SID_LIST =<\/p>\n

(SID_DESC =<\/p>\n

(ORACLE_HOME= \/oracle\/db\/12.2.0.1\/db_home)<\/p>\n

(SID_NAME = TDG)<\/p>\n

)<\/p>\n

)<\/p>\n

 <\/p>\n

Start Listener<\/strong><\/p>\n

lsnrctl start listener_dr_for_arch_test<\/p>\n

 <\/p><\/blockquote>\n

2. Tnsnames Configuration<\/strong><\/p>\n

Primary Side Rac Node 1<\/strong><\/p>\n

su – oracle<\/p>\n

vi tnsnames.ora<\/p>\n

RACTEST =<\/p>\n

(DESCRIPTION =<\/p>\n

(ADDRESS = (PROTOCOL = TCP)(HOST = ractest12c-scan)(PORT = 1521))<\/p>\n

(CONNECT_DATA =<\/p>\n

(SERVER = DEDICATED)<\/p>\n

(SERVICE_NAME = RACTEST)<\/p>\n

)<\/p>\n

)<\/p>\n

 <\/p>\n

RACTEST1 =<\/p>\n

(DESCRIPTION =<\/p>\n

(ADDRESS = (PROTOCOL = TCP)(HOST = ractest12c01-vip)(PORT = 1521))<\/p>\n

(CONNECT_DATA =<\/p>\n

(SERVER = DEDICATED)<\/p>\n

(SERVICE_NAME = RACTEST)<\/p>\n

)<\/p>\n

)
\nRACTEST2 =<\/p>\n

(DESCRIPTION =<\/p>\n

(ADDRESS = (PROTOCOL = TCP)(HOST = ractest12c02-vip)(PORT = 1521))<\/p>\n

(CONNECT_DATA =<\/p>\n

(SERVER = DEDICATED)<\/p>\n

(SERVICE_NAME = RACTEST)<\/p>\n

)<\/p>\n

)<\/p>\n

 <\/p>\n

DG_TEST =<\/p>\n

(DESCRIPTION =<\/p>\n

(ADDRESS = (PROTOCOL = TCP)(HOST = test12cdg.sm.gov.tr)(PORT = 1545))<\/p>\n

(CONNECT_DATA =<\/p>\n

(SERVER = DEDICATED)<\/p>\n

(SERVICE_NAME = TDG)<\/p>\n

)<\/p>\n

)<\/p>\n

 <\/p>\n

PRI_TEST =<\/p>\n

(DESCRIPTION =<\/p>\n

(ADDRESS = (PROTOCOL = TCP)(HOST = ractest12c01-vip.sm.gov.tr)(PORT = 1545))<\/p>\n

(CONNECT_DATA =<\/p>\n

(SERVER = DEDICATED)<\/p>\n

(SERVICE_NAME = RACTEST)<\/p>\n

)<\/p>\n

)<\/p><\/blockquote>\n

Primary Side Rac Node 2<\/strong><\/p>\n

su – oracle<\/p>\n

vi tnsnames.ora<\/p>\n

RACTEST =<\/p>\n

(DESCRIPTION =<\/p>\n

(ADDRESS = (PROTOCOL = TCP)(HOST = ractest12c-scan)(PORT = 1521))<\/p>\n

(CONNECT_DATA =<\/p>\n

(SERVER = DEDICATED)<\/p>\n

(SERVICE_NAME = RACTEST)<\/p>\n

)<\/p>\n

)<\/p>\n

 <\/p>\n

RACTEST1 =<\/p>\n

(DESCRIPTION =<\/p>\n

(ADDRESS = (PROTOCOL = TCP)(HOST = ractest12c01-vip)(PORT = 1521))<\/p>\n

(CONNECT_DATA =<\/p>\n

(SERVER = DEDICATED)<\/p>\n

(SERVICE_NAME = RACTEST)<\/p>\n

)<\/p>\n

)<\/p>\n

RACTEST2 =<\/p>\n

(DESCRIPTION =<\/p>\n

(ADDRESS = (PROTOCOL = TCP)(HOST = ractest12c02-vip)(PORT = 1521))<\/p>\n

(CONNECT_DATA =<\/p>\n

(SERVER = DEDICATED)<\/p>\n

(SERVICE_NAME = RACTEST)<\/p>\n

)<\/p>\n

)<\/p>\n

DG_TEST =<\/p>\n

(DESCRIPTION =<\/p>\n

(ADDRESS = (PROTOCOL = TCP)(HOST = test12cdg.sm.gov.tr)(PORT = 1545))<\/p>\n

(CONNECT_DATA =<\/p>\n

(SERVER = DEDICATED)<\/p>\n

(SERVICE_NAME = TDG)<\/p>\n

)<\/p>\n

)<\/p>\n

PRI_TEST =<\/p>\n

(DESCRIPTION =<\/p>\n

(ADDRESS = (PROTOCOL = TCP)(HOST = ractest12c01-vip.sm.gov.tr)(PORT = 1545))<\/p>\n

(CONNECT_DATA =<\/p>\n

(SERVER = DEDICATED)<\/p>\n

(SERVICE_NAME = RACTEST)<\/p>\n

)<\/p>\n

)<\/p>\n

Secondary Side<\/strong><\/p>\n

su – oracle<\/p>\n

cd $ORACLE_HOME\/network\/admin<\/p>\n

vi tnsnames.ora<\/p>\n

RACTEST =<\/p>\n

(DESCRIPTION =<\/p>\n

(ADDRESS = (PROTOCOL = TCP)(HOST = ractest12c-scan.sm.gov.tr)(PORT = 1521))<\/p>\n

(CONNECT_DATA =<\/p>\n

(SERVER = DEDICATED)<\/p>\n

(SERVICE_NAME = RACTEST)<\/p>\n

)<\/p>\n

)<\/p>\n

PRI_TEST =<\/p>\n

(DESCRIPTION =<\/p>\n

(ADDRESS = (PROTOCOL = TCP)(HOST = ractest12c01-vip.sm.gov.tr)(PORT = 1545))<\/p>\n

(CONNECT_DATA =<\/p>\n

(SERVER = DEDICATED)<\/p>\n

(SID=RACTEST1)<\/p>\n

)<\/p>\n

)<\/p>\n

DG_TEST =<\/p>\n

(DESCRIPTION =<\/p>\n

(ADDRESS = (PROTOCOL = TCP)(HOST = test12cdg.sm.gov.tr)(PORT = 1545))<\/p>\n

(CONNECT_DATA =<\/p>\n

(SERVER = DEDICATED)<\/p>\n

(SERVICE_NAME = TDG)<\/p>\n

)<\/p>\n

)<\/p><\/blockquote>\n

3. Archivelog Mode<\/strong><\/p>\n

Primary has to be archivelog mode.<\/p>\n

You can check current status of archivelog mode with below query.<\/p>\n

select log_mode from gv$database;<\/p>\n

If write\u00a0NOARCHIVELOG, you have to do below operation to do ARCHIVELOG mode.<\/p>\n

srvctl stop database -d RACTEST<\/p>\n

sqlplus \/ as sysdba<\/p>\n

startup mount;
\nalter database archivelog;
\nalter database force logging;
\nalter database open;<\/p><\/blockquote>\n

4. Force Logging<\/strong><\/p>\n

You have to do force logging to log every thing.<\/p>\n

alter database force logging;<\/p><\/blockquote>\n

5. Configure Parameters<\/strong><\/p>\n

You have to configure parameter to data guard.<\/p>\n

Primary Side<\/strong><\/p>\n

sqlplus \/ as sysdba<\/p>\n

alter system set log_archive_format=’%t_%s_%r.arc’ scope=spfile sid=’*’;
\nalter system set remote_login_passwordfile=EXCLUSIVE scope=spfile sid=’*’;<\/p>\n

alter system set log_archive_dest_1=’location=+FRA\/RACTEST\/ARCHIVELOG’ scope=both sid=’*’;<\/p>\n

DB Name can be max 8 characters<\/p>\n

alter system set log_archive_config=’DG_CONFIG=(RACTEST,TDG)’ scope=both sid=’*’;<\/p>\n

alter system set log_archive_dest_2=’SERVICE=DG_TEST LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=TDG’ scope=both sid=’*’;<\/p>\n

alter system set standby_file_management=AUTO scope=both sid=’*’;<\/p>\n

alter system set log_archive_dest_state_2=enable scope=both sid=’*’;<\/p>\n

alter system set fal_client= PRI_TEST scope=both sid=’*’;<\/p>\n

alter system set fal_server= DG_TEST scope=both sid=’*’;<\/p>\n

exit;<\/p>\n

srvctl stop database -d RACTEST
\nsrvctl start database -d RACTEST<\/p><\/blockquote>\n

5. Take Backup<\/strong><\/p>\n

Take backup from primary side and move to secondary side. I used \/backup directory to take backup and use secondary side backup directory. Backup dir has to be the same on primary side and secondary side.<\/p>\n

rman target \/<\/p>\n

delete archivelog all;<\/p>\n

run {
\nALLOCATE CHANNEL d1 TYPE DISK FORMAT ‘\/backup\/backup_pri_%d_s%s_p%p_%T’ ;
\nbackup as compressed backupset database plus archivelog;
\nbackup current controlfile for standby format ‘\/backup\/controlfile_standby.ctl’ ;
\nrelease channel d1;
\n}<\/p>\n

exit;<\/p>\n

sqlplus \/ as sysdba<\/p>\n

create pfile=’\/backup\/pfile.ora’ from spfile;<\/p>\n

exit;<\/p>\n

Move backup files<\/strong><\/p>\n

cd \/backup\/<\/p>\n

scp backup* oracle@test12cdg:\/backup\/<\/p>\n

scp controlfile_standby.ctl\u00a0oracle@test12cdg:\/backup\/<\/p>\n

scp file.ora\u00a0oracle@test12cdg:\/backup\/<\/p><\/blockquote>\n

6. Configure Pfile to Data Guard on Secondary Side<\/strong><\/p>\n

You have to configure pfile.ora file to data guard for secondary side. You can see configured pfile.ora at below.<\/p>\n

vi pfile.ora<\/p>\n

*.__data_transfer_cache_size=0
\n*.__db_cache_size=3657433088
\n*.__inmemory_ext_roarea=0
\n*.__inmemory_ext_rwarea=0
\n*.__java_pool_size=16777216
\n*.__large_pool_size=83886080
\n*.__oracle_base=’\/oracle\/db\/12.2.0.1’#ORACLE_BASE set from environment
\n*.__pga_aggregate_target=1660944384
\n*.__sga_target=4982833152
\n*.__shared_io_pool_size=251658240
\n*.__shared_pool_size=956301312
\n*.__streams_pool_size=0
\n*.audit_file_dest=’\/oracle\/db\/12.2.0.1\/admin\/TDG\/adump’
\n*.audit_trail=’db’
\n*.cluster_database=false
\n*.compatible=’12.2.0′
\n*.control_files=’+DATA\/TDG\/CONTROLFILE\/current.262.950370543′,’+DATA\/TDG\/CONTROLFILE\/current.261.950370543′
\n*.db_block_size=8192
\n*.db_create_file_dest=’+DATA’
\n*.db_name=’RACTEST’
\n*.db_unique_name=’TDG’
\n*.db_recovery_file_dest=’+FRA’
\n*.db_recovery_file_dest_size=214748364800
\n*.diagnostic_dest=’\/oracle\/db\/12.2.0.1′
\n*.dispatchers='(PROTOCOL=TCP) (SERVICE=TDGXDB)’
\n*.fal_client=’DG_TEST’
\n*.fal_server=’PRI_TEST’
\n*.local_listener=’-oraagent-dummy-‘
\n*.log_archive_config=’DG_CONFIG=(RACTEST,TDG)’
\n*.log_archive_dest_1=’location=+FRA\/TDG\/ARCHIVELOG’
\n*.log_archive_dest_2=’SERVICE=PRI_TEST LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=RACTEST’
\n*.log_archive_dest_state_2=’DEFER’
\n*.log_archive_format=’%t_%s_%r.arc’
\n*.db_file_name_convert=’+DATA\/RACTEST\/DATAFILE’,’+DATA\/TDG\/DATAFILE’,’+FRA\/RACTEST\/DATAFILE’,’+FRA\/TDG\/DATAFILE’
\n*.log_file_name_convert=’+DATA\/RACTEST\/ONLINELOG’,’+DATA\/TDG\/ONLINELOG’,’+FRA\/RACTEST\/ONLINELOG’,’+FRA\/TDG\/ONLINELOG’
\n*.nls_language=’AMERICAN’
\n*.nls_territory=’AMERICA’
\n*.open_cursors=300
\n*.pga_aggregate_target=1579m
\n*.processes=640
\n*.remote_login_passwordfile=’EXCLUSIVE’
\n*.sga_target=4737m
\n*.standby_file_management=’AUTO’
\n*.undo_tablespace=’UNDOTBS1′<\/p><\/blockquote>\n

7. Create Spfile from Pfile<\/strong><\/p>\n

You can create spfile from pfile.ora at secondary side.<\/p>\n

sqlplus \/ as sysdba<\/p>\n

create spfile from pfile=\u2019\/backup\/pfile.ora\u2019;<\/p>\n

startup nomount;<\/p><\/blockquote>\n

8. Restore Database<\/strong><\/p>\n

Method 1<\/strong><\/p>\n

Secondary side<\/strong><\/p>\n

rman target \/<\/p>\n

restore standby controlfile from ‘\/backup\/controlfile_standby.ctl’;<\/p>\n

alter database mount standby database;<\/p>\n

restore database;<\/p>\n

Method 2<\/strong><\/p>\n

Secondary side<\/strong><\/p>\n

rman target sys@PRI_TEST auxiliary sys@DG_TEST<\/p>\n

target database Password:<\/p>\n

connected to target database: RACTEST (DBID=1915123103)<\/p>\n

auxiliary database Password:<\/p>\n

connected to auxiliary database: RACTEST (not mounted)<\/p>\n

duplicate target database for standby from active database dorecover nofilenamecheck;<\/p><\/blockquote>\n

9. Check Error Logs<\/strong><\/p>\n

After restore operation, if you see error logs like below, you have to do switch operation like below.<\/p>\n

tail -100f \/oracle\/db\/12.2.0.1\/diag\/rdbms\/tdg\/TDG\/trace\/alert_TDG.log<\/p>\n

Error example:<\/strong><\/p>\n

WARNING: The converted filename ‘+DATA\/TDG\/datafile\/users.260.950370491’
\nis an ASM fully qualified filename.
\nChanging the filename to ‘+DATA\/MUST_RENAME_THIS_DATAFILE_7.4294967295.4294967295’.
\nPlease rename it accordingly.<\/p>\n

Solution:<\/strong><\/p>\n

sqlplus \/ as sysdba<\/p>\n

alter system set standby_file_management=MANUAL;<\/p>\n

exit;<\/p>\n

You have to check datafile number from alert log, and you have to check datafiles.<\/p>\n

rman target \/<\/p>\n

run{
\nset newname for datafile 1 to ‘+DATA\/TDG\/DATAFILE\/SYSTEM.293.953893449’;
\nset newname for datafile 3 to ‘+DATA\/TDG\/DATAFILE\/SYSAUX.292.953893449’;
\nset newname for datafile 4 to ‘+DATA\/TDG\/DATAFILE\/UNDOTBS1.267.953893449’;
\nset newname for datafile 5 to ‘+DATA\/TDG\/DATAFILE\/UNDOTBS2.291.953893449’;
\nset newname for datafile 7 to ‘+DATA\/TDG\/DATAFILE\/USERS.294.953893451’;
\nswitch datafile all;
\n}<\/p>\n

exit;<\/p>\n

sqlplus \/ as sysdba<\/p>\n

alter system set standby_file_management=AUTO;<\/p>\n

shutdown immediate;<\/p>\n

startup mount;<\/p><\/blockquote>\n

10. Add Standby Log File<\/strong><\/p>\n

You have to add standby log file both on primary side and secondary side to real time apply\u00a0synchronization.<\/p>\n

You have to add one more number standby log than normal logfile.<\/p>\n

You can see log file with below query.<\/p>\n

Primary side<\/strong><\/p>\n

select * from gv$logfile;<\/p>\n

If you see 4 logfile (default number), you can add 5 standby logfile and size has to be the same. You can see size with bwlow query.<\/p>\n

select * from gv$log;<\/p>\n

Also, you read this article <\/a>to see how to add and drop standby log files.<\/p>\n

Primary side<\/strong><\/p>\n

alter database add standby logfile size 200M;<\/p>\n

alter database add standby logfile size 200M;<\/p>\n

alter database add standby logfile size 200M;<\/p>\n

alter database add standby logfile size 200M;<\/p>\n

alter database add standby logfile size 200M;<\/p>\n

Secondary side<\/strong><\/p>\n

alter database add standby logfile size 200M;<\/p>\n

alter database add standby logfile size 200M;<\/p>\n

alter database add standby logfile size 200M;<\/p>\n

alter database add standby logfile size 200M;<\/p>\n

alter database add standby logfile size 200M;<\/p><\/blockquote>\n

11. Start\u00a0Synchronization<\/strong><\/p>\n

Secondary side<\/strong><\/p>\n

sqlplus \/ as sysdba<\/p>\n

alter database open read only;<\/p>\n

alter database recover managed standby database using current logfile disconnect from session;<\/p><\/blockquote>\n

12. Check Synchronization<\/strong><\/p>\n

Secondary side<\/strong><\/p>\n

Check alert log<\/p>\n

tail -100f \/oracle\/db\/12.2.0.1\/diag\/rdbms\/tdg\/TDG\/trace\/alert_TDG.log<\/p>\n

Check query<\/p>\n

sqlplus \/ as sysdba<\/p>\n

select open_mode, database_role, protection_mode from gv$database;<\/p>\n

READ ONLY WITH APPLY | PHYSICAL STANDBY | MAXIMUM PERFORMANCE<\/p>\n

Primary side<\/strong><\/p>\n

select * from v$dataguard_status order by timestamp desc<\/p>\n

alter system set log_archive_dest_state_2 = ENABLE<\/p>\n

select * from gv$archive_dest_status where dest_id in (1,2)<\/p>\n

SELECT a.name,a.resetlogs_id, DECODE (a.thread#, 1, ‘RAC NODE1’, ‘RAC NODE2’) HOST, b.last_seq son_olusan,
\na.applied_seq son_uygulanan, TO_CHAR (a.uygulanan_son_zaman, ‘dd\/mm\/yyyy hh24:mi:ss’) son_uygulama_zamani
\nFROM (SELECT name,resetlogs_id, thread#, MAX (sequence#) applied_seq, MAX (next_time) uygulanan_son_zaman
\nFROM gv$archived_log
\nWHERE applied = ‘YES’ and name in (‘DG_TEST’) and resetlogs_id=(select max(resetlogs_id) from gv$archived_log)
\nGROUP BY name,resetlogs_id, thread# ) a,
\n(SELECT name,resetlogs_id, thread#, MAX (sequence#) last_seq
\nFROM gv$archived_log where name in (‘DG_TEST’) and resetlogs_id=(select max(resetlogs_id) from gv$archived_log)
\nGROUP BY name,resetlogs_id, thread# ) b
\nWHERE a.thread# = b.thread#
\nand a.name = b.name;<\/p><\/blockquote>\n

13. Post Installation<\/strong><\/p>\n

Secondary side<\/strong><\/p>\n

If you have grid user to manage listener, you have to give permission on $ORACLE_HOME\/bin\/oracle executable file. You have to give chmod 6751 permission. This provides that grid user can execute oracle file like oracle user. Oracle open process on OS when you connect to database. If you connect from remote with using listener, listener owner (grid) will want to open new process on OS but grid user cannot open process with using $ORACLE_HOME\/bin\/oracle file due to do not have permission. So you have to give 6751 permission to use $ORACLE_HOME\/bin\/oracle file.<\/p>\n

[root@tdg bin] cd $ORACLE_HOME\/bin\/<\/p>\n

[root@tdg bin] chmod 6751 oracle<\/p>\n

 <\/p><\/blockquote>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Data Guard maintains these standby databases as copies of…<\/p>\n","protected":false},"author":37,"featured_media":2464,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9,20],"tags":[107,32,49,36],"class_list":["post-2461","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administration","category-oracle-backup-and-recovery","tag-oracle-12c","tag-oracle-administration","tag-oracle-backup-and-restore","tag-oracle-data-guard"],"jetpack_featured_media_url":"http:\/\/www.fatihacar.com\/blog\/resimler\/oracle12c_data_guard_infrastructure.jpg","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-DH","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=2461"}],"version-history":[{"count":13,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2461\/revisions"}],"predecessor-version":[{"id":2520,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2461\/revisions\/2520"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media\/2464"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2461"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}