RMAN DataGaurd and Broker Configuration
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 1 of 26
RMAN DataGaurd and Broker Configuration RMAN Data Guard Config and Broker Config. Hai, in this article I will demonstrate how to configure Datagaurd with RMAN, and also configure Broker for this Datagaurd Setup. This is single command based Datagaurd Configuration
Assumptions: Node Primary DB Standby DB
IP Address 192.168.1.11 192.168.1.12
DB Name, SID, Listener DELL DELL
db_unique_name, TNS Names DELL_LIVE DELL_STBY
Port 1529 1528
RAC 1 (Primary) Machine Database DELL is installed RAC 2 (Machine) Installed only Oracle Software Mandatory requirements: 1. 2. 3. 4. 5. 6. 7.
Oracle database Version should be min 11gR2 (Duplicate Command will not work for 11gR1) PRAMETER file should be in SPFILE DBNAME, SID,TNS should be defined in Uppercase (Case sensitive) Password file(orapwDELL) should be on both locations with same password All directory available with valid permissions Auxiliary database should connect as “not mounted” Enable “Flashback” for "STANDBY" after executing "DUPLICATE" command.
Directory and env. File for PRIMARY and STANDBY
RAC-1 PRIMARY
RAC-2 STANDBY
mkdir -p /u01/app/oracle/DELL/arch/ mkdir -p /u01/app/oracle/flash_recovery_area/
mkdir -p /u01/app/oracle/DELL/arch/ mkdir -p /u01/app/oracle/flash_recovery_area/
chown –R oracle:oinstall /u01 chmod –R 775 /u01
chown –R oracle:oinstall /u01 chmod –R 775 /u01
[root@rac1 ~]# su - oracle [oracle@rac1 ~]$ vi dell.env export ORACLE_SID=DELL export ORACLE_HOME=/u01/app/oracle/product/11 .2.0/dbhome_1 export PATH=$ORACLE_HOME/bin:$PATH export TNS_ADMIN=$ORACLE_HOME/network/admin LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib/ usr/lib; export LD_LIBRARY_PATH
[root@rac2 ~]# su - oracle [oracle@rac2 ~]$ vi dell.env export ORACLE_SID=DELL export ORACLE_HOME=/u01/app/oracle/product/11 .2.0/dbhome_1 export PATH=$ORACLE_HOME/bin:$PATH export TNS_ADMIN=$ORACLE_HOME/network/admin LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib/ usr/lib; export LD_LIBRARY_PATH
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 2 of 26
RMAN DataGaurd and Broker Configuration
PARAMTER, Listener, tnsnames,sqlnet.ora files for PRIMARY and STANDBY RAC-1 PRIMARY
RAC-2 STANDBY
Create pfile from spfile and then add below parameters for PRIMARY
Create New Pfile using vi-editor and add the below parameters for STANDBY
[oracle@rac1 dbs]$ vi initDELL.ora #--paste the parameters in notepad without option Word Wrap and then copy to your pfile #--addnl prameter for PRIMARY *.db_flashback_retention_target=4320 *.db_recovery_file_dest_size=429496729 60 *.db_recovery_file_dest='/u01/app/orac le/flash_recovery_area' *.db_unique_name='DELL_LIVE' *.global_names=TRUE *.local_listener='DELL' *.log_archive_dest_state_1='ENABLE' *.log_archive_dest_state_2='ENABLE' # *.log_archive_dest_1='location="/u01/a pp/oracle/DELL/arch"','valid_for=(ALL_ LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=DELL_LIVE' # *.log_archive_dest_2='service="DELL_ST BY"','ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="DELL_STBY" net_timeout=30','valid_for=(online_log file,all_roles)' # ###----DG Broker Parameters----### *.log_archive_trace=0 *.log_archive_format='arch%s%t%r.arc' *.standby_file_management=auto *.archive_lag_target=0 *.log_archive_max_processes=30 *.log_archive_min_succeed_dest=1 *.db_file_name_convert='DELL_STBY','DE LL_LIVE' *.log_file_name_convert='DELL_STBY','D ELL_LIVE' *.dg_broker_config_file1='/u01/app/ora cle/product/11.2.0/dbhome_1/dbs/dr1.da t'
[oracle@rac2 dbs]$ vi initDELL.ora #--paste the parameters in notepad without option Word Wrap and then copy to your pfile #--addnl parameters for STANDBY *.db_name='DELL' *.db_unique_name='DELL_STBY' *.db_recovery_file_dest_size=429496729 60 *.db_recovery_file_dest='/u01/app/orac le/flash_recovery_area' *.global_names=TRUE *.local_listener='DELL' *.log_archive_dest_state_1='ENABLE' *.log_archive_dest_state_2='ENABLE' *.diagnostic_dest='/u01/app/oracle' *.memory_target=730857472 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE ' *.undo_tablespace='UNDOTBS1' # *.log_archive_dest_1='location="/u01/a pp/oracle/DELL/arch"','valid_for=(ALL_ LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=DELL_STBY' # *.log_archive_dest_2='' # ###----DG Broker Parameters----### *.log_archive_trace=0 *.log_archive_format='arch%s%t%r.arc' *.standby_file_management='AUTO' *.archive_lag_target=0 *.log_archive_max_processes=30 *.log_archive_min_succeed_dest=1 *.db_file_name_convert='DELL_LIVE','DE LL_STBY' *.log_file_name_convert='DELL_LIVE','D ELL_STBY' *.dg_broker_config_file1='/u01/app/ora cle/product/11.2.0/dbhome_1/dbs/dr1.da
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 3 of 26
RMAN DataGaurd and Broker Configuration *.dg_broker_config_file2='/u01/app/ora cle/product/11.2.0/dbhome_1/dbs/dr2.da t' *.dg_broker_start=TRUE *.log_archive_config='dg_config=(DELL_ LIVE,DELL_STBY)' *.fal_client='DELL_LIVE' *.fal_server='DELL_STBY'
t' *.dg_broker_config_file2='/u01/app/ora cle/product/11.2.0/dbhome_1/dbs/dr2.da t' *.dg_broker_start=TRUE *.log_archive_config='dg_config=(DELL_ LIVE,DELL_STBY)' *.fal_client='DELL_STBY' *.fal_server='DELL_LIVE'
[oracle@rac1 admin]$ cat listener.ora DELL = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1529)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1529)) ) )
[oracle@rac2 admin]$ cat listener.ora DELL = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1528)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1528)) ) )
SID_LIST_DELL = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = DELL_LIVE) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_ 1) (SID_NAME = DELL) ) (SID_DESC = (GLOBAL_DBNAME = DELL_LIVE_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_ 1) (SID_NAME = DELL) ) )
SID_LIST_DELL = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = DELL_STBY) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_ 1) (SID_NAME = DELL) ) (SID_DESC = (GLOBAL_DBNAME = DELL_STBY_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_ 1) (SID_NAME = DELL) ) )
INBOUND_CONNECT_TIMEOUT_DELL = 100
INBOUND_CONNECT_TIMEOUT_DELL = 100
[oracle@rac1 admin]$ cat tnsnames.ora DELL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1529)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = DELL) ) )
[oracle@rac2 admin]$ cat tnsnames.ora DELL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1528)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = DELL) ) )
DELL_LIVE =
DELL_LIVE =
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 4 of 26
RMAN DataGaurd and Broker Configuration (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1529)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DELL_LIVE) (SID = DELL) (UR=A) ) )
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1529)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DELL_LIVE) (SID= DELL) (UR=A) ) )
DELL_STBY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1528)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DELL_STBY) (SID = DELL) (UR=A) ) )
DELL_STBY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1528)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DELL_STBY) (SID= DELL) (UR=A) ) )
DELL_LIVE_DGMGRL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1529)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DELL_LIVE_DGMGRL) (INSTANCE_NAME = DELL) ) )
DELL_LIVE_DGMGRL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1529)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DELL_LIVE_DGMGRL) (INSTANCE_NAME=DELL) ) )
DELL_STBY_DGMGRL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1528)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DELL_STBY_DGMGRL) (INSTANCE_NAME = DELL) ) )
DELL_STBY_DGMGRL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1528)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DELL_STBY_DGMGRL) (INSTANCE_NAME=DELL) ) )
[oracle@rac1 admin]$ pwd /u01/app/oracle/product/11.2.0/dbhome_ 1/network/admin [oracle@rac1 admin]$ cat sqlnet.ora NAMES.DIRECTORY_PATH=(TNSNAMES,
[oracle@rac2 admin]$ pwd /u01/app/oracle/product/11.2.0/dbhome_ 1/network/admin [oracle@rac2 admin]$ cat sqlnet.ora NAMES.DIRECTORY_PATH=(TNSNAMES,
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 5 of 26
RMAN DataGaurd and Broker Configuration ONAMES, HOSTNAME) SQLNET.EXPIRE_TIME= 10 SQLNET.INBOUND_CONNECT_TIMEOUT =60
ONAMES, HOSTNAME) SQLNET.EXPIRE_TIME= 10 SQLNET.INBOUND_CONNECT_TIMEOUT =60
Now install DELL database using dbca At step no 5. Provide Same Administrative Password as sys for password file At step no 6. (2) Use Common location /u01/app/oracle At step no 7. Disable flash recovery, Archive in GUI
PRIMARY DB (192.168.1.11) [oracle@rac1 [oracle@rac1 total 24 -rw-rw---- 1 -rw-rw---- 1 -rw-r--r-- 1 -rw-r----- 1 -rw-r----- 1 -rw-r----- 1
DELL]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs/ dbs]$ ll oracle oracle oracle oracle oracle oracle
oinstall oinstall oinstall oinstall oinstall oinstall
1544 1544 2851 24 1536 2560
Feb 2 19:49 hc_DBUA0.dat Feb 2 19:50 hc_DELL.dat May 15 2009 init.ora Feb 2 19:52 lkDELL Feb 2 19:53 orapwDELL Feb 2 19:55 spfileDELL.ora
[oracle@rac1 dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed Mar 8 08:48:54 2017 Copyright (c) 1982, 2011, Oracle.
All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> SQL> show parameter pfile; NAME TYPE VALUE --------------------------------- ----------- -----------------------------spfile string /u01/app/oracle/product/11.2.0 /dbhome_1/dbs/spfileDELL.ora
Create Pfile & add Parameters & enable features PRIMARY DB (192.168.1.11) http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 6 of 26
RMAN DataGaurd and Broker Configuration SQL> create pfile from spfile; File created. SQL> shut immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@rac1 dbs]$ ll total 28 -rw-rw---- 1 oracle oinstall 1544 Feb 2 19:49 hc_DBUA0.dat -rw-rw---- 1 oracle oinstall 1544 Feb 2 19:50 hc_DELL.dat -rw-r--r-- 1 oracle oinstall 807 Feb 2 19:57 initDELL.ora -rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora -rw-r----- 1 oracle oinstall 24 Feb 2 19:52 lkDELL -rw-r----- 1 oracle oinstall 1536 Feb 2 19:53 orapwDELL -rw-r----- 1 oracle oinstall 2560 Feb 2 19:55 spfileDELL.ora [oracle@rac1 dbs]$ [oracle@rac1 dbs]$ mv spfileDELL.ora bkp_spfileDELL.ora [oracle@rac1 total 28 -rw-r----- 1 -rw-rw---- 1 -rw-rw---- 1 -rw-r--r-- 1 -rw-r--r-- 1 -rw-r----- 1 -rw-r----- 1 [oracle@rac1 [oracle@rac1
dbs]$ ll oracle oinstall 2560 Feb 2 oracle oinstall 1544 Feb 2 oracle oinstall 1544 Feb 2 oracle oinstall 807 Feb 2 oracle oinstall 2851 May 15 oracle oinstall 24 Feb 2 oracle oinstall 1536 Feb 2 dbs]$ dbs]$ orapwd file=orapwDELL
[oracle@rac1 dbs]$ vi initDELL.ora
19:55 19:49 19:50 19:57 2009 19:52 19:53
bkp_spfileDELL.ora hc_DBUA0.dat hc_DELL.dat initDELL.ora init.ora lkDELL orapwDELL
password=sys force=y
( Copy the above given PRIMARY
init parameters)
Enable the following features for Database DELL 1. Archive log 3. Force logging
2. Flashback database 4. Adding standby redo logs
PRIMARY DB (192.168.1.11) [oracle@rac1 dbs]$ sqlplus / as sysdba Connected to an idle instance. SQL> startup mount Database mounted. SQL> SQL> show parameter spfile; NAME TYPE VALUE ---------------------------------- ----------- -----------------------------spfile string
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 7 of 26
RMAN DataGaurd and Broker Configuration SQL>
Checkout our given parameters are loaded or not SQL> show parameter fal; NAME TYPE VALUE ---------------------------------- ----------- -----------------------------fal_client string DELL_LIVE fal_server string DELL_STBY
1. Enable archive log SQL> archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/DELL/arch Oldest online log sequence 1 Current log sequence 2 SQL> alter database archivelog; Database altered. SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/app/oracle/DELL/arch Oldest online log sequence 1 Next log sequence to archive 2 Current log sequence 2 SQL>
2. Enable flashback and force logging. SQL> select LOG_MODE,FLASHBACK_ON,FORCE_LOGGING from v$database; LOG_MODE FLASHBACK_ON FOR ------------ ---- -------------- --ARCHIVELOG NO NO SQL> alter database flashback on; Database altered. SQL> alter database force logging; Database altered. SQL> select LOG_MODE,FLASHBACK_ON,FORCE_LOGGING from v$database; LOG_MODE FLASHBACK_ON FOR ------------ ------------------ ---
ARCHIVELOG
YES
YES
SQL>
3. Add standby log files as per your requirements SQL> col MEMBER for a40 SQL> SELECT * FROM V$LOGFILE;
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 8 of 26
RMAN DataGaurd and Broker Configuration GROUP# STATUS ---------- ------3 2 1
TYPE ------ONLINE ONLINE ONLINE
MEMBER IS_ ---------------------------------------- --/u01/app/oracle/ DELL /redo03.log NO /u01/app/oracle/ DELL /redo02.log NO /u01/app/oracle/ DELL /redo01.log NO
SQL> select bytes from v$standby_log; no rows selected SQL> alter database add standby logfile '/u01/app/oracle/DELL/stbyredo04.log' size 50M; Database altered. SQL> alter database add standby logfile '/u01/app/oracle/DELL/stbyredo05.log' size 50M; Database altered. SQL> alter database add standby logfile '/u01/app/oracle/DELL/stbyredo06.log' size 50M; Database altered. SQL> col MEMBER for a40 SQL> SELECT * FROM V$LOGFILE; GROUP# STATUS ---------- ------3 2 1 4 5 6
TYPE ------ONLINE ONLINE ONLINE STANDBY STANDBY STANDBY
MEMBER ---------------------------------------/u01/app/oracle/DELL/redo03.log /u01/app/oracle/DELL/redo02.log /u01/app/oracle/DELL/redo01.log /u01/app/oracle/DELL/stbyredo04.log /u01/app/oracle/DELL/stbyredo05.log /u01/app/oracle/DELL/stbyredo06.log
IS_ --NO NO NO NO NO NO
6 rows selected. SQL> SQL> SQL> select bytes from v$standby_log; BYTES ---------52428800 52428800 52428800 SQL>
All the features required for datagaurd are enabled Now start the database with SPFILE. SQL> select status from v$instance; STATUS -----------MOUNTED SQL>SQL> alter database open; Database altered.
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 9 of 26
RMAN DataGaurd and Broker Configuration SQL> show parameter spfile; NAME TYPE VALUE ---------------------------------- ----------- -----------------------------spfile string
Database is using Pfile. So, create spfile from pfile and start SQL> create spfile from pfile; File created. SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down.
Now start the database with SPFILE SQL> SQL> startup Database mounted. Database opened. SQL> show parameter spfile; NAME TYPE VALUE ---------------------------------- ----------- -----------------------------spfile string /u01/app/oracle/product/11.2.0 /dbhome_1/dbs/spfileDELL.ora SQL> SQL>
Configure Listener, tns, sqlnet on PRIME & STBY PRIMARY DB (192.168.1.11) [oracle@rac1 dbs]$ cd $TNS_ADMIN [oracle@rac1 admin]$ vi listener.ora
( Copy the above given Primary
listener parameter) [oracle@rac1 admin]$ vi tnsnames.ora
( Copy the above given Primary
tns parameter) [oracle@rac1 admin]$ vi sqlnet.ora
( Copy the above given Primary
sqlnet parameter) [oracle@rac1 admin]$ lsnrctl start dell LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 07-MAR-2017 13:11:33 Copyright (c) 1991, 2011, Oracle.
All rights reserved.
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.3.0 - Production System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 10 of 26
RMAN DataGaurd and Broker Configuration Log messages written to /u01/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/rac1/dell/alert/log. xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.11)(PORT=1529))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1529))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.11)(PORT=1529))) STATUS of the LISTENER -----------------------Alias dell Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production Start Date 07-MAR-2017 13:11:34 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/rac1/dell/alert/log. xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.11)(PORT=1529))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1529))) Services Summary... Service "DELL_LIVE" has 1 instance(s). Instance "DELL", status UNKNOWN, has 1 handler(s) for this service... Service "DELL_LIVE_DGMGRL" has 1 instance(s). Instance "DELL", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully [oracle@rac1 admin]$
Services with name DELL_LIVE and DELL_LIVE_DGMRL started for Listener [oracle@rac1 [oracle@rac1 [oracle@rac1 [oracle@rac1 [oracle@rac1
admin]$ admin]$ tnsping dell admin]$ tnsping dell_live admin]$ tnsping dell_live_dgmgrl admin]$ tnsping dell_stby
STANDBY DB (192.168.1.12) [oracle@rac2 DELL]$ cd $TNS_ADMIN [oracle@rac2 admin]$ vi listener.ora
( Copy the above given Standby
listener parameter) [oracle@rac2 admin]$ vi tnsnames.ora
( Copy the above given Standby
tns parameter) [oracle@rac2 admin]$ vi sqlnet.ora
( Copy the above given Standby
sqlnet parameter) [oracle@rac2 admin]$ lsnrctl start dell
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 11 of 26
RMAN DataGaurd and Broker Configuration LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 07-MAR-2017 13:14:09 Copyright (c) 1991, 2011, Oracle.
All rights reserved.
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.3.0 - Production System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/rac2/dell/alert/log. xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.12)(PORT=1528))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1528))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.12)(PORT=1528))) STATUS of the LISTENER -----------------------Alias dell Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production Start Date 07-MAR-2017 13:14:09 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/rac2/dell/alert/log. xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.12)(PORT=1528))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1528))) Services Summary... Service "DELL_STBY" has 1 instance(s). Instance "DELL", status UNKNOWN, has 1 handler(s) for this service... Service "DELL_STBY_DGMGRL" has 1 instance(s). Instance "DELL", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully [oracle@rac2 admin]$
Services with name DELL_STBY, DELL_STBY_DGMGRL started [oracle@rac1 [oracle@rac2 [oracle@rac2 [oracle@rac2 [oracle@rac2 [oracle@rac2 [oracle@rac2 [oracle@rac2
admin]$ admin]$ tnsping dell admin]$ tnsping dell_live admin]$ tnsping dell_live_dgmgrl admin]$ tnsping dell_stby admin]$ tnsping dell_stby_dgmgrl admin]$ cd $ORACLE_HOME/dbs dbs]$ vi initDELL.ora ( Copy the
above given Standby
init parameter)
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 12 of 26
RMAN DataGaurd and Broker Configuration PRIMARY DB (192.168.1.11) [oracle@rac1 admin]$ tnsping dell_stby [oracle@rac1 admin]$ tnsping dell_stby_dgmgrl
STANDBY DB (192.168.1.12) [oracle@rac2 [oracle@rac2 [oracle@rac2 [oracle@rac2
DELL]$ cd ~]$ . dell dbs]$ cd $ORACLE_HOME/dbs/ dbs]$ vi initDELL.ora ( Copy
the above given Standby
init parameter) [oracle@rac2 dbs]$ sqlplus / as sysdba Connected to an idle instance. SQL> startup nomount pfile='initDELL.ora' ORACLE instance started. SQL> show parameter spfile; NAME TYPE VALUE ---------------------------------- ----------- -----------------------------spfile string SQL> show parameter pfile; NAME TYPE VALUE ---------------------------------- ----------- -----------------------------spfile string SQL> create spfile from pfile; File created. SQL> shut ORACLE instance shut down.
Start Standby database in nomount state using spfile STANDBY DB (192.168.1.12) SQL> startup nomount SQL> show parameter spfile; NAME TYPE VALUE ---------------------------------- ----------- -----------------------------spfile string /u01/app/oracle/product/11.2.0 /dbhome_1/dbs/spfileDELL.ora SQL> show parameter background_dump_dest NAME TYPE VALUE ---------------------------------- ----------- -----------------------------background_dump_dest string /u01/app/oracle/diag/rdbms/del l_stby/DELL/trace SQL>
Note: Open tail for alert log of Standby in new window and keep on observing it till end of DGMGRL
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 13 of 26
RMAN DataGaurd and Broker Configuration [root@rac2 ~]# tail -f /u01/app/oracle/diag/rdbms/dell_stby/DELL/trace/alert_DELL.log SQL> archive log list; ORA-01507: database not mounted SQL> exit
Creation of Password file for Standby STANDBY DB (192.168.1.12) [oracle@rac2 [oracle@rac2 [oracle@rac2 total 16 -rw-r--r-- 1 -rw-r--r-- 1 -rw-r----- 1 -rw-r----- 1 [oracle@rac2 [oracle@rac2 total 4 drwxr-xr-x 2
dbs]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs dbs]$ orapwd file=orapwDELL password=sys dbs]$ ll oracle oinstall 1150 Feb 2 20:40 oracle oinstall 2851 May 15 2009 oracle oinstall 1536 Feb 2 20:50 oracle oinstall 3584 Feb 2 20:41 dbs]$ cd /u01/app/oracle/DELL/ DELL]$ ll oracle oinstall 4096 Mar
initDELL.ora init.ora
orapwDELL spfileDELL.ora
7 14:03 arch
RMAN DATAGAURD CONFIGURATION SETUP WITH SINGLE COMMAND STANDBY DB (192.168.1.12) Connect RMAN using target and auxiliary should connected as “not mounted” only. If the connection shows other than this as (not started, not connected) then you are missing something. Fix the issue if you got. [oracle@rac2 dbs]$ rman target sys/sys@dell_live auxiliary sys/sys@dell_stby Recovery Manager: Release 11.2.0.3.0 - Production on Tue Mar 7 13:25:14 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates.
All rights reserved.
connected to target database: DELL (DBID=3908745866) connected to auxiliary database: DELL (not mounted) RMAN>
The connection is Correct. Now duplicate the Target DB. Monitor both PRIMARY and STANDBY alert logs for updates RMAN> RMAN> duplicate target database for standby from active database nofilenamecheck dorecover;
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 14 of 26
RMAN DataGaurd and Broker Configuration Starting Duplicate Db at 07-MAR-17 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=20 device type=DISK contents of Memory Script: { backup as copy reuse targetfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwDELL' auxiliary format '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwDELL' ; } executing Memory Script Starting backup at 07-MAR-17 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=68 device type=DISK Finished backup at 07-MAR-17 contents of Memory Script: { sql clone "alter system set
control_files =
''/u01/app/oracle/flash_recovery_area/DELL_STBY/controlfile/o1_mf_dcx2pn1s_.c tl'' comment= ''Set by RMAN'' scope=spfile"; backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/flash_recovery_area/DELL_STBY/controlfile/o1_mf_dcx2pn20_.ct l'; sql clone "alter system set control_files = ''/u01/app/oracle/flash_recovery_area/DELL_STBY/controlfile/o1_mf_dcx2pn20_.c tl'' comment= ''Set by RMAN'' scope=spfile"; shutdown clone immediate; startup clone nomount; } executing Memory Script sql statement: alter system set control_files = ''/u01/app/oracle/flash_recovery_area/DELL_STBY/controlfile/o1_mf_dcx2pn1s_.c tl'' comment= ''Set by RMAN'' scope=spfile Starting backup at 07-MAR-17 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy copying standby control file output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_DELL.f tag=TAG20170307T132628 RECID=1 STAMP=938006788 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03 Finished backup at 07-MAR-17 sql statement: alter system set control_files = ''/u01/app/oracle/flash_recovery_area/DELL_STBY/controlfile/o1_mf_dcx2pn20_.c tl'' comment= ''Set by RMAN'' scope=spfile
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 15 of 26
RMAN DataGaurd and Broker Configuration Oracle instance shut down connected to auxiliary database (not started) Oracle instance started Total System Global Area
730714112 bytes
Fixed Size Variable Size Database Buffers Redo Buffers
2231952 432013680 293601280 2867200
bytes bytes bytes bytes
contents of Memory Script: { sql clone 'alter database mount standby database'; } executing Memory Script sql statement: alter database mount standby database contents of Memory Script: { set newname for tempfile 1 to "/u01/app/oracle/DELL/temp01.dbf"; switch clone tempfile all; set newname for datafile 1 to "/u01/app/oracle/DELL/system01.dbf"; set newname for datafile 2 to "/u01/app/oracle/DELL/sysaux01.dbf"; set newname for datafile 3 to "/u01/app/oracle/DELL/undotbs01.dbf"; set newname for datafile 4 to "/u01/app/oracle/DELL/users01.dbf"; backup as copy reuse datafile 1 auxiliary format "/u01/app/oracle/DELL/system01.dbf" datafile 2 auxiliary format "/u01/app/oracle/DELL/sysaux01.dbf" datafile 3 auxiliary format "/u01/app/oracle/DELL/undotbs01.dbf" datafile 4 auxiliary format "/u01/app/oracle/DELL/users01.dbf" ; sql 'alter system archive log current'; } executing Memory Script executing command: SET NEWNAME renamed tempfile 1 to /u01/app/oracle/DELL/temp01.dbf in control file executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 16 of 26
RMAN DataGaurd and Broker Configuration executing command: SET NEWNAME Starting backup at 07-MAR-17 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy input datafile file number=00001 name=/u01/app/oracle/DELL/system01.dbf output file name=/u01/app/oracle/DELL/system01.dbf tag=TAG20170307T132646 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45 channel ORA_DISK_1: starting datafile copy input datafile file number=00002 name=/u01/app/oracle/DELL/sysaux01.dbf output file name=/u01/app/oracle/DELL/sysaux01.dbf tag=TAG20170307T132646 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35 channel ORA_DISK_1: starting datafile copy input datafile file number=00003 name=/u01/app/oracle/DELL/undotbs01.dbf output file name=/u01/app/oracle/DELL/undotbs01.dbf tag=TAG20170307T132646 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting datafile copy input datafile file number=00004 name=/u01/app/oracle/DELL/users01.dbf output file name=/u01/app/oracle/DELL/users01.dbf tag=TAG20170307T132646 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 Finished backup at 07-MAR-17 sql statement: alter system archive log current contents of Memory Script: { backup as copy reuse archivelog like "/u01/app/oracle/DELL/arch/arch61938005132.arc" auxiliary format "/u01/app/oracle/DELL/arch/arch61938005132.arc" archivelog like "/u01/app/oracle/DELL/arch/arch71938005132.arc" auxiliary format "/u01/app/oracle/DELL/arch/arch71938005132.arc" ; catalog clone archivelog "/u01/app/oracle/DELL/arch/arch61938005132.arc"; catalog clone archivelog "/u01/app/oracle/DELL/arch/arch71938005132.arc"; switch clone datafile all; } executing Memory Script Starting backup at 07-MAR-17 using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log copy input archived log thread=1 sequence=6 RECID=5 STAMP=938006808 output file name=/u01/app/oracle/DELL/arch/arch61938005132.arc RECID=0 STAMP=0 channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting archived log copy input archived log thread=1 sequence=7 RECID=6 STAMP=938006891 output file name=/u01/app/oracle/DELL/arch/arch71938005132.arc RECID=0 STAMP=0 channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01 Finished backup at 07-MAR-17 cataloged archived log archived log file name=/u01/app/oracle/DELL/arch/arch61938005132.arc RECID=1 STAMP=938006893
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 17 of 26
RMAN DataGaurd and Broker Configuration cataloged archived log archived log file name=/u01/app/oracle/DELL/arch/arch71938005132.arc RECID=2 STAMP=938006893 datafile 1 switched to datafile copy input datafile copy RECID=1 STAMP=938006894 name=/u01/app/oracle/DELL/system01.dbf datafile 2 switched to datafile copy input datafile copy RECID=2 STAMP=938006894 name=/u01/app/oracle/DELL/sysaux01.dbf datafile 3 switched to datafile copy input datafile copy RECID=3 STAMP=938006894 name=/u01/app/oracle/DELL/undotbs01.dbf datafile 4 switched to datafile copy input datafile copy RECID=4 STAMP=938006894 name=/u01/app/oracle/DELL/users01.dbf
file file file file
contents of Memory Script: { set until scn 1007250; recover standby clone database delete archivelog ; } executing Memory Script executing command: SET until clause Starting recover at 07-MAR-17 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=44 device type=DISK starting media recovery archived log for thread 1 with sequence 6 is already on disk as file /u01/app/oracle/DELL/arch/arch61938005132.arc archived log for thread 1 with sequence 7 is already on disk as file /u01/app/oracle/DELL/arch/arch71938005132.arc archived log file name=/u01/app/oracle/DELL/arch/arch61938005132.arc thread=1 sequence=6 archived log file name=/u01/app/oracle/DELL/arch/arch71938005132.arc thread=1 sequence=7 media recovery complete, elapsed time: 00:00:00 Finished recover at 07-MAR-17 Finished Duplicate Db at 07-MAR-17 RMAN> RMAN> RMAN> RMAN> exit Recovery Manager complete.
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 18 of 26
RMAN DataGaurd and Broker Configuration [oracle@rac2 dbs]$
Check your CRD files created at Standby Side STANDBY DB (192.168.1.12) [oracle@rac2 dbs]$ cd /u01/app/oracle/DELL/ [oracle@rac2 DELL]$ ll total 1573492 drwxrwxr-x 2 oracle oinstall 4096 Mar 7 13:37 arch -rw-r----- 1 oracle oinstall 52429312 Mar 7 13:28 redo01.log -rw-r----- 1 oracle oinstall 52429312 Mar 7 13:28 redo02.log -rw-r----- 1 oracle oinstall 52429312 Mar 7 13:28 redo03.log -rw-r----- 1 oracle oinstall 52429312 Mar 7 13:46 stbyredo04.log -rw-r----- 1 oracle oinstall 52429312 Mar 7 13:37 stbyredo05.log -rw-r----- 1 oracle oinstall 52429312 Mar 7 13:28 stbyredo06.log -rw-r----- 1 oracle oinstall 524296192 Mar 7 13:28 sysaux01.dbf -rw-r----- 1 oracle oinstall 734011392 Mar 7 13:28 system01.dbf -rw-r----- 1 oracle oinstall 31465472 Mar 7 13:28 undotbs01.dbf -rw-r----- 1 oracle oinstall 5251072 Mar 7 13:28 users01.dbf [oracle@rac2 DELL]$ [oracle@rac2 dbs]$ sqlplus / as sysdba SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/app/oracle/DELL/arch Oldest online log sequence 0 Next log sequence to archive 0 Current log sequence 0 SQL> -----------------------------------------------------------------------------
Wait till your STANDBY alert log file show following (5 Mins) Wed Mar 08 09:10:31 2017 Switch of datafile 1 complete to datafile copy checkpoint is 1006629 Switch of datafile 2 complete to datafile copy . . . . . . . . . . . . . . . . Errors in file /u01/app/oracle/diag/rdbms/dell_stby/DELL/trace/DELL_ora_6139.trc: ORA-00313: open failed for members of log group 6 of thread 0 ORA-00312: online log 6 thread 0: '/u01/app/oracle/DELL/stbyredo06.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Completed: alter database clear logfile group 6 RFS connections are allowed Wed Mar 08 09:14:27 2017 RFS[1]: Assigned to RFS process 6733 RFS[1]: Selected log 4 for thread 1 sequence 8 dbid -386150402 branch 938076161
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 19 of 26
RMAN DataGaurd and Broker Configuration Wed Mar 08 09:14:27 2017 Primary database is in MAXIMUM PERFORMANCE mode RFS[2]: Assigned to RFS process 6737 RFS[2]: Selected log 5 for thread 1 sequence 9 dbid -386150402 branch 938076161 Wed Mar 08 09:14:27 2017 Archived Log entry 3 added for thread 1 sequence 8 ID 0xe8fb65fe dest 1: -----------------------------------------------------------------------------
Wait till your PRIMARY alert log file show following (5 Mins) Wed Mar 08 09:10:27 2017 Thread 1 advanced to log sequence 8 (LGWR switch) Current log# 2 seq# 8 mem# 0: /u01/app/oracle/DELL/redo02.log Archived Log entry 6 added for thread 1 sequence 7 ID 0xe8fb65fe des Wed Mar 08 09:14:26 2017 Thread 1 advanced to log sequence 9 (LGWR switch) Current log# 3 seq# 9 mem# 0: /u01/app/oracle/DELL/redo03.log Wed Mar 08 09:14:26 2017 Archived Log entry 7 added for thread 1 sequence 8 ID 0xe8fb65fe dest 1: Wed Mar 08 09:14:26 2017 ****************************************************************** LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2 ****************************************************************** Wed Mar 08 09:14:26 2017 ARC7: Standby redo logfile selected for thread 1 sequence 8 for destination LOG_ARCHIVE_DEST_2 LNS: Standby redo logfile selected for thread 1 sequence 9 for destination LOG_ARCHIVE_DEST_2 ----------------------------------------------------------------------------SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/app/oracle/DELL/arch Oldest online log sequence 0 Next log sequence to archive 0 Current log sequence 9 SQL> SQL> col name for a6; SQL> select NAME,CONTROLFILE_TYPE,OPEN_MODE,DATABASE_ROLE,PROTECTION_MODE from v$database; NAME CONTROL OPEN_MODE DATABASE_ROLE PROTECTION_MODE ------ ------- -------------------- ---------------- -------------------DELL STANDBY MOUNTED PHYSICAL STANDBY MAXIMUM PERFORMANCE SQL>
Command for datagard boker status SQL> select NAME,DATABASE_ROLE,DATAGUARD_BROKER from v$database; NAME DATABASE_ROLE DATAGUAR --------- ---------------- -------DELL PHYSICAL STANDBY DISABLED
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 20 of 26
RMAN DataGaurd and Broker Configuration SQL>
PRIMARY DB (192.168.1.11) SQL> archive log list; Database log mode Automatic archival Archive destination Oldest online log sequence Next log sequence to archive Current log sequence
Archive Mode Enabled /u01/app/oracle/DELL/arch 7 9 9
SQL> SQL> col name for a6; SQL> select NAME,CONTROLFILE_TYPE,OPEN_MODE,DATABASE_ROLE,PROTECTION_MODE from v$database; NAME CONTROL OPEN_MODE DATABASE_ROLE PROTECTION_MODE ------ ------- -------------------- ---------------- -------------------DELL CURRENT READ WRITE PRIMARY MAXIMUM PERFORMANCE SQL> ---------------------------------------------------------------------------------------------------------------------------------------------------------
here new service added to only PRIMARY listener [oracle@rac1 ~]$ lsnrctl status dell Service "DELLXDB" has 1 instance(s). ---------------------------------------------------------------------------------------------------------------------------------------------------------
Monitor the standby log file for log shipping SQL> alter system switch logfile; System altered. SQL> archive log list; Database log mode Automatic archival Archive destination Oldest online log sequence Next log sequence to archive Current log sequence SQL>
Archive Mode Enabled /u01/app/oracle/DELL/arch 8 10 10
STANDBY DB (192.168.1.12) SQL> archive log list; Database log mode Automatic archival Archive destination Oldest online log sequence Next log sequence to archive Current log sequence
Archive Mode Enabled /u01/app/oracle/DELL/arch 8 0 10
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 21 of 26
RMAN DataGaurd and Broker Configuration SQL>
Enable FLASHBACK for STANDBY SQL> SQL> select LOG_MODE,FLASHBACK_ON,FORCE_LOGGING from v$database; LOG_MODE FLASHBACK_ON ------------ -----------------ARCHIVELOG NO
FOR --YES
SQL> SQL> alter database flashback on; Database altered. SQL> SQL> select LOG_MODE,FLASHBACK_ON,FORCE_LOGGING from v$database; LOG_MODE FLASHBACK_ON ------------ -----------------ARCHIVELOG SQL>
YES
FOR --YES
We have successfully configured Datagaurd with RMAN Enjoy!!!!!
Now let’s Configure BROKER to Data Gaurd PRIMARY DB (192.168.1.11) SQL> select NAME,DATABASE_ROLE,DATAGUARD_BROKER from v$database; NAME DATABASE_ROLE DATAGUAR --------- ---------------- -------DELL PRIMARY DISABLED
Set parameter dg_broker_start=TRUE in your init or SPFILE SQL> show parameter dg_broker NAME TYPE VALUE ---------------------------------- ----------- -----------------------------dg_broker_config_file1 string /u01/app/oracle/product/11.2.0 /dbhome_1/dbs/dr1.dat dg_broker_config_file2 string /u01/app/oracle/product/11.2.0 /dbhome_1/dbs/dr2.dat dg_broker_start boolean TRUE SQL> SQL>
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 22 of 26
RMAN DataGaurd and Broker Configuration SQL> exit [oracle@rac1 dbs]$ [oracle@rac1 dbs]$ dgmgrl DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production Copyright (c) 2000, 2009, Oracle. All rights reserved. Welcome to DGMGRL, type "help" for information. DGMGRL> DGMGRL> DGMGRL> connect sys/sys@DELL_LIVE Connected. DGMGRL> DGMGRL> show configuration; ORA-16532: Data Guard broker configuration does not exist Configuration details cannot be determined by DGMGRL
This is because there is no configuration available for Broker Now let’s create configuration and add Database to it DGMGRL> DGMGRL> DGMGRL> create configuration DELL as > primary database is DELL_LIVE > connect identifier is DELL_LIVE; Configuration "dell" created with primary database "dell_live" DGMGRL> DGMGRL> ---------------------------------------------------------------------------------------------------------------------------------------------------------
Here at this point files Datagaurd Broker files dr1.dat, dr2.dat created for Primary database as per our spfile record. [oracle@rac1 dbs]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs/ [oracle@rac1 dbs]$ ll total 9592 -rw-r----- 1 oracle oinstall 8192 Mar 7 14:58 dr1.dat -rw-r----- 1 oracle oinstall 12288 Mar 7 14:58 dr2.dat --------------------------------------------------------------------------------------------------------------------------------------------------------DGMGRL> DGMGRL> show configuration; Configuration - dell Protection Mode: MaxPerformance Databases:
dell_live - Primary database Fast-Start Failover: DISABLED Configuration Status: DISABLED
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 23 of 26
RMAN DataGaurd and Broker Configuration DGMGRL>
Here when you add standby database a background Process NSV1 will start on PRIMARY. You can monitor this in PRIMARY log file DGMGRL> add database DELL_STBY as > connect identifier is DELL_STBY > maintained as physical; Database "dell_stby" added DGMGRL> DGMGRL> DGMGRL> show configuration; Configuration - dell Protection Mode: MaxPerformance Databases: dell_live - Primary database
dell_stby - Physical standby database Fast-Start Failover: DISABLED Configuration Status:
DISABLED DGMGRL>
Broker config is done now you have to enable this Config DGMGRL> DGMGRL> enable configuration Enabled. DGMGRL>
(monitor PRIM and STANDBY logs)
Here at this point files dr1.dat, dr2.dat files are created for Standby database and added Broker Service to STANDBY listener DGMGRL> --------------------------------------------------------------------------------------------------------------------------------------------------------[oracle@rac2 dbs]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs/ [oracle@rac2 dbs]$ ll total 60 -rw-r----- 1 oracle oinstall 16384 Mar 7 15:06 dr1.dat -rw-r----- 1 oracle oinstall 16384 Mar 7 15:06 dr2.dat [oracle@rac2 ~]$ [oracle@rac2 ~]$ lsnrctl status dell Service "DELL_STBY_DGB" has 1 instance(s). ------ Added Broker Service to PRIMARY Listener also. [oracle@rac1 ~]$ [oracle@rac1 ~]$ lsnrctl status dell Service "DELL_LIVE_DGB" has 1 instance(s). -----------------------------------------------------------------------------
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 24 of 26
RMAN DataGaurd and Broker Configuration ----------------------------------------------------------------------------DGMGRL> show configuration; Configuration - dell Protection Mode: MaxPerformance Databases: dell_live - Primary database dell_stby - Physical standby database Fast-Start Failover: DISABLED Configuration Status:
SUCCESS DGMGRL> DGMGRL> exit [oracle@rac1 dbs]$ sqlplus / as sysdba SQL> select NAME,DATABASE_ROLE,DATAGUARD_BROKER from v$database; NAME DATABASE_ROLE DATAGUAR --------- ---------------- -------DELL PRIMARY ENABLED SQL> SQL> archive log list; Database log mode Automatic archival Archive destination Oldest online log sequence Next log sequence to archive Current log sequence SQL>
Archive Mode Enabled /u01/app/oracle/DELL/arch 9 11 11
STANDBY DB (192.168.1.12) SQL> select NAME,DATABASE_ROLE,DATAGUARD_BROKER from v$database; NAME DATABASE_ROLE DATAGUAR ------ ---------------- -------DELL PHYSICAL STANDBY ENABLED SQL> archive log list; Database log mode Automatic archival Archive destination Oldest online log sequence Next log sequence to archive Current log sequence SQL>
Archive Mode Enabled /u01/app/oracle/DELL/arch 9 0 11
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 25 of 26
RMAN DataGaurd and Broker Configuration DATAGUARD_BROKER has successfully configured This article helps those who like to configure datagaurd with RMAN And also to configure Broker service to a datagaurd Setup Thanks for Reading, Regards, Mohammed Areefuddin
http://my-orcl.blogspot.com/2017/03/rman-datagaurd-configuration.html
Page 26 of 26