- \n
- Cascading Structure is not supported by Data Guard Broker.<\/li>\n
- To use Oracle RAC on primary side, you have to use least 11.2.0.2 verion.<\/li>\n
- Cascaded standby database do not support Real Time Apply<\/li>\n<\/ul>\n
![\"\"](\"http:\/\/www.fatihacar.com\/blog\/resimler\/oracle_cascade_standby_structure_oracle11g.jpg\")
<\/p>\nI will configure cascade standby database structure like below schema.<\/p>\n
System Informations<\/strong><\/h2>\n
PRIMARY DATABASE<\/strong>
\nVERSION :<\/strong> 11.2.0.3
\nIP :<\/strong> 192.168.9.129
\nSID :<\/strong> PRI
\nHOSTNAME :<\/strong> primary.localdomain<\/p>\n<\/p>\n
CASCADING DATABASE<\/strong>
\nVERSION :<\/strong> 11.2.0.3
\nIP :<\/strong> 192.168.9.130
\nSID :<\/strong> DR1
\nHOSTNAME :<\/strong> dr1.localdomain<\/p>\nCASCADED DATABASE<\/strong>
\nVERSION :<\/strong> 11.2.0.3
\nIP :<\/strong> 192.168.9.131
\nSID :<\/strong> DR2
\nHOSTNAME :<\/strong> dr2.localdomain<\/p>\nAssumptions<\/strong><\/h2>\n
Primary database installed.
\nStandby databases installed as only software.
\nShh-Keygen connection configuration completed.<\/p><\/blockquote>\nhosts file of all systems<\/strong><\/p>\n
192.168.9.129 primary.localdomain primary
\n192.168.9.130 dr1.localdomain dr1
\n192.168.9.131 dr2.localdomain dr2<\/p><\/blockquote>\nOracle User Bash Profiles<\/strong><\/p>\n
Primary Database Oracle User .bash_profile<\/strong><\/p>\n
\n
\r\n#bash_profile\r\n\r\n# Get the aliases and functions\r\nif [ -f ~\/.bashrc ]; then\r\n . ~\/.bashrc\r\nfi\r\n\r\n# User specific environment and startup programs\r\n\r\nif [ $USER = \"oracle\" ]; then\r\n if [ $SHELL = \"\/bin\/ksh\" ]; then\r\n ulimit -p 16384\r\n ulimit -n 65536\r\n else\r\n ulimit -u 16384 -n 65536\r\n fi\r\nfi\r\n\r\n# User specific environment and startup programs\r\n# Oracle Settings\r\nTMP=\/tmp; export TMP\r\nTMPDIR=$TMP; export TMPDIR\r\nORACLE_HOSTNAME=primary.localdomain; export ORACLE_HOSTNAME\r\nORACLE_UNQNAME=PRI; export ORACLE_UNQNAME\r\nORACLE_BASE=\/oracle\/db\/11.2.0; export ORACLE_BASE\r\nORACLE_SID=PRI; export ORACLE_SID\r\nORACLE_HOME=\/oracle\/db\/11.2.0\/db_home; export ORACLE_HOME\r\nORACLE_TERM=xterm; export ORACLE_TERM\r\nLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH\r\nCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH\r\nBASE_PATH=\/usr\/sbin:$PATH:$HOME\/bin; export BASE_PATH\r\nPATH=$ORACLE_HOME\/bin:$BASE_PATH; export PATH\r\n\r\nalias home='cd \/oracle\/db\/11.2.0\/db_home'\r\nalias sql='sqlplus \/ as sysdba'\r\nalias alert_db='tail -100f \/oracle\/db\/11.2.0\/diag\/rdbms\/PRI\/PRI\/trace\/alert_PRI.log'\r\n<\/code><\/pre>\n<\/p><\/blockquote>\n
Cascading Standby Database Oracle User .bash_profile<\/strong><\/p>\n
\n
\r\n#bash_profile\r\n\r\n# Get the aliases and functions\r\nif [ -f ~\/.bashrc ]; then\r\n . ~\/.bashrc\r\nfi\r\n\r\n# User specific environment and startup programs\r\n\r\nif [ $USER = \"oracle\" ]; then\r\n if [ $SHELL = \"\/bin\/ksh\" ]; then\r\n ulimit -p 16384\r\n ulimit -n 65536\r\n else\r\n ulimit -u 16384 -n 65536\r\n fi\r\nfi\r\n\r\n# User specific environment and startup programs\r\n# Oracle Settings\r\nTMP=\/tmp; export TMP\r\nTMPDIR=$TMP; export TMPDIR\r\nORACLE_HOSTNAME=dr1.localdomain; export ORACLE_HOSTNAME\r\nORACLE_UNQNAME=DR1; export ORACLE_UNQNAME\r\nORACLE_BASE=\/oracle\/db\/11.2.0; export ORACLE_BASE\r\nORACLE_SID=DR1; export ORACLE_SID\r\nORACLE_HOME=\/oracle\/db\/11.2.0\/db_home; export ORACLE_HOME\r\nORACLE_TERM=xterm; export ORACLE_TERM\r\nLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH\r\nCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH\r\nBASE_PATH=\/usr\/sbin:$PATH:$HOME\/bin; export BASE_PATH\r\nPATH=$ORACLE_HOME\/bin:$BASE_PATH; export PATH\r\n\r\nalias home='cd \/oracle\/db\/11.2.0\/db_home'\r\nalias sql='sqlplus \/ as sysdba'\r\nalias alert_db='tail -100f \/oracle\/db\/11.2.0\/diag\/rdbms\/dr1\/DR1\/trace\/alert_DR1.log'\r\n\r\n<\/code><\/pre>\n<\/blockquote>\nCascading Standby Database Oracle User .bash_profile<\/strong><\/p>\n
\n
\r\n#bash_profile\r\n\r\n# Get the aliases and functions\r\nif [ -f ~\/.bashrc ]; then\r\n . ~\/.bashrc\r\nfi\r\n\r\n# User specific environment and startup programs\r\n\r\nif [ $USER = \"oracle\" ]; then\r\n if [ $SHELL = \"\/bin\/ksh\" ]; then\r\n ulimit -p 16384\r\n ulimit -n 65536\r\n else\r\n ulimit -u 16384 -n 65536\r\n fi\r\nfi\r\n\r\n# User specific environment and startup programs\r\n# Oracle Settings\r\nTMP=\/tmp; export TMP\r\nTMPDIR=$TMP; export TMPDIR\r\nORACLE_HOSTNAME=dr2.localdomain; export ORACLE_HOSTNAME\r\nORACLE_UNQNAME=DR2; export ORACLE_UNQNAME\r\nORACLE_BASE=\/oracle\/db\/11.2.0; export ORACLE_BASE\r\nORACLE_SID=DR2; export ORACLE_SID\r\nORACLE_HOME=\/oracle\/db\/11.2.0\/db_home; export ORACLE_HOME\r\nORACLE_TERM=xterm; export ORACLE_TERM\r\nLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH\r\nCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH\r\nBASE_PATH=\/usr\/sbin:$PATH:$HOME\/bin; export BASE_PATH\r\nPATH=$ORACLE_HOME\/bin:$BASE_PATH; export PATH\r\n\r\nalias home='cd \/oracle\/db\/11.2.0\/db_home'\r\nalias sql='sqlplus \/ as sysdba'\r\nalias alert_db='tail -100f \/oracle\/db\/11.2.0\/diag\/rdbms\/dr2\/DR2\/trace\/alert_DR2.log'\r\n\r\n<\/code><\/pre>\n<\/blockquote>\nConfiguration Steps<\/strong><\/h2>\n
1- Create Listener on Standby Sides<\/strong><\/h3>\n
You can use netca assistant to create new listener. You have to configure like below after creating.<\/p>\n
Cascading Standby Database listener.ora file<\/strong><\/p>\n
\n
\r\nSID_LIST_LISTENER=\r\n\t(SID_LIST=\r\n\t\t(SID_DESC=\r\n\t\t\t(GLOBAL_DBNAME=DR1)\r\n\t\t\t(ORACLE_HOME=\/oracle\/db\/11.2.0\/db_home)\r\n\t\t\t(SID_NAME=DR1)\r\n\t\t)\r\n\t\t(SID_DESC=\r\n\t\t\t(GLOBAL_DBNAME=DR2)\r\n\t\t\t(ORACLE_HOME=\/oracle\/db\/11.2.0\/db_home)\r\n\t\t\t(SID_NAME=DR2)\r\n\t\t)\r\n\t)\t\r\n\r\nLISTENER =\r\n (DESCRIPTION_LIST =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = dr1.localdomain)(PORT = 1521))\r\n (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\r\n )\r\n )\r\n\r\nADR_BASE_LISTENER = \/oracle\/db\/11.2.0\r\n<\/code><\/pre>\n<\/p><\/blockquote>\n
Cascaded Standby Database listener.ora file<\/strong><\/p>\n
\n
\r\nSID_LIST_LISTENER=\r\n\t(SID_LIST=\r\n\t\t(SID_DESC=\r\n\t\t\t(GLOBAL_DBNAME=DR1)\r\n\t\t\t(ORACLE_HOME=\/oracle\/db\/11.2.0\/db_home)\r\n\t\t\t(SID_NAME=DR1)\r\n\t\t)\r\n\t\t(SID_DESC=\r\n\t\t\t(GLOBAL_DBNAME=DR2)\r\n\t\t\t(ORACLE_HOME=\/oracle\/db\/11.2.0\/db_home)\r\n\t\t\t(SID_NAME=DR2)\r\n\t\t)\r\n\t)\r\n\r\nLISTENER =\r\n (DESCRIPTION_LIST =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = dr2.localdomain)(PORT = 1521))\r\n (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\r\n )\r\n )\r\n\r\nADR_BASE_LISTENER = \/oracle\/db\/11.2.0\r\n\r\n<\/code><\/pre>\n<\/p><\/blockquote>\n
2- Create and Configure Tnsnames on All Sides<\/strong><\/h3>\n
tnsnames.ora File on All Sides<\/strong><\/p>\n
\n
\r\nPRI =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = primary.localdomain)(PORT = 1521))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = PRI)\r\n )\r\n )\r\n\r\nDR1 =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = dr1.localdomain)(PORT = 1521))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = DR1)\r\n )\r\n )\r\n\r\nDR2 =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = dr2.localdomain)(PORT = 1521))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = DR2)\r\n )\r\n )\r\n\r\n<\/code><\/pre>\n<\/blockquote>\n3- Configure Parameters of Primary Database<\/strong><\/h3>\n
\n
\r\n\r\nSQL> alter system set remote_login_passwordfile=EXCLUSIVE scope=spfile;\r\n\r\nSystem altered.\r\n\r\nSQL> alter system set standby_file_management=AUTO scope=both;\r\n\r\nSystem altered.\r\n\r\nSQL> alter database force logging;\r\n\r\nDatabase altered.\r\n\r\nSQL> alter system set fal_client=PRI scope=spfile;\r\n\r\nSystem altered.\r\n\r\nSQL> alter system set fal_server=DR1 scope=spfile;\r\n\r\nSystem altered.\r\n\r\nSQL> alter system set log_archive_dest_1='LOCATION=\/oracle\/fra\/PRI\/archivelog\/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRI'; \r\n\r\nSystem altered.\r\n\r\nSQL> alter system set log_archive_dest_2='SERVICE=DR1 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=DR1';\r\n\r\nSystem altered.\r\n\r\nSQL> alter system set log_archive_config='DG_CONFIG=(PRI,DR1,DR2)' scope=spfile;\r\n\r\nSystem altered.\r\n\r\nSQL> shu immediate;\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\nSQL> startup;\r\nORACLE instance started.\r\n\r\nTotal System Global Area 818401280 bytes\r\nFixed Size\t\t 2232800 bytes\r\nVariable Size\t\t 620760608 bytes\r\nDatabase Buffers\t 192937984 bytes\r\nRedo Buffers\t\t 2469888 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\n\r\n<\/code><\/pre>\n<\/blockquote>\n4- Copy Password File Of Primary Database to Standby Databases<\/strong><\/h3>\n
\n
\r\n\r\n[oracle@primary ~]$ scp \/oracle\/db\/11.2.0\/db_home\/dbs\/orapwPRI oracle@dr1:\/oracle\/db\/11.2.0\/db_home\/dbs\/orapwDR1\r\norapwPRI 100% 1536 1.5KB\/s 00:00 \r\n[oracle@dr1 ~]$ scp \/oracle\/db\/11.2.0\/db_home\/dbs\/orapwDR1 oracle@dr2:\/oracle\/db\/11.2.0\/db_home\/dbs\/orapwDR2\r\norapwdDR1\r\norapwPRI 100% 1536 1.5KB\/s 00:00\r\n\r\n<\/code><\/pre>\n<\/blockquote>\n5- Standby Databases Auto Open Disable<\/strong><\/h3>\n
\n
\r\n\r\nAdd below line to \/etc\/oratab file on all standby server.\r\n\r\n[oracle@dr1 ~] vi \/etc\/oratab\r\n\r\nDR1:\/oracle\/db\/11.2.0\/db_home:N\r\n\r\n[oracle@dr2 ~] vi \/etc\/oratab\r\n\r\nDR2:\/oracle\/db\/11.2.0\/db_home:N \r\n\r\n<\/code><\/pre>\n<\/blockquote>\n6- Configure Parameter Files<\/strong><\/h3>\n
You can export pfile like below command from primary database.<\/p>\n
\n
\r\nSQL> create pfile='\/tmp\/pfile.ora' from spfile;<\/blockquote>\r\n<\/code><\/pre>\n<\/blockquote>\nYou have to configure pfile files for standby databases. In the last case, your datafiles can be like below. Parameters can vary depending on your system.<\/p>\n
Primary Database Parameter File<\/strong><\/p>\n
\n
\r\n \r\nPRI.__db_cache_size=226492416\r\nPRI.__java_pool_size=4194304\r\nPRI.__large_pool_size=4194304\r\nPRI.__oracle_base='\/oracle\/db\/11.2.0'#ORACLE_BASE set from environment\r\nPRI.__pga_aggregate_target=285212672\r\nPRI.__sga_target=536870912\r\nPRI.__shared_io_pool_size=0\r\nPRI.__shared_pool_size=289406976\r\nPRI.__streams_pool_size=4194304\r\n*.audit_file_dest='\/oracle\/db\/11.2.0\/admin\/PRI\/adump'\r\n*.audit_trail='db'\r\n*.compatible='11.2.0.0.0'\r\n*.control_files='\/oracle\/data\/PRI\/control01.ctl','\/oracle\/db\/11.2.0\/fast_recovery_area\/PRI\/control02.ctl'\r\n*.db_block_size=8192\r\n*.db_domain=''\r\n*.db_name='PRI'\r\n*.db_recovery_file_dest='\/oracle\/fra'\r\n*.db_recovery_file_dest_size=10737418240\r\n*.diagnostic_dest='\/oracle\/db\/11.2.0'\r\n*.dispatchers='(PROTOCOL=TCP) (SERVICE=PRIXDB)'\r\n*.fal_client='PRI'\r\n*.fal_server='DR1'\r\n*.job_queue_processes=1000\r\n*.log_archive_config='DG_CONFIG=(PRI,DR1,DR2)'\r\n*.log_archive_dest_1='LOCATION=\/oracle\/fra\/PRI\/archivelog\/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRI'\r\n*.log_archive_dest_2='SERVICE=DR1 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=DR1'\r\n*.memory_target=821035008\r\n*.archive_lag_target=900\r\n*.open_cursors=300\r\n*.processes=150\r\n*.remote_login_passwordfile='EXCLUSIVE'\r\n*.standby_file_management='AUTO'\r\n*.undo_tablespace='UNDOTBS1'\r\n\r\n<\/code><\/pre>\n<\/blockquote>\nCascading Standby Database Parameter File<\/strong><\/p>\n
\n
\r\n \r\nDR1.__db_cache_size=226492416\r\nDR1.__java_pool_size=4194304\r\nDR1.__large_pool_size=4194304\r\nDR1.__oracle_base='\/oracle\/db\/11.2.0'#ORACLE_BASE set from environment\r\nDR1.__pga_aggregate_target=285212672\r\nDR1.__sga_target=536870912\r\nDR1.__shared_io_pool_size=0\r\nDR1.__shared_pool_size=289406976\r\nDR1.__streams_pool_size=4194304\r\n*.audit_file_dest='\/oracle\/db\/11.2.0\/admin\/DR1\/adump'\r\n*.audit_trail='db'\r\n*.compatible='11.2.0.0.0'\r\n*.control_files='\/oracle\/data\/DR1\/control01.ctl','\/oracle\/fra\/DR1\/control02.ctl'\r\n*.db_block_size=8192\r\n*.db_domain=''\r\n*.db_unique_name='DR1'\r\n*.db_name='PRI'\r\n*.db_recovery_file_dest='\/oracle\/fra'\r\n*.db_recovery_file_dest_size=10737418240\r\n*.diagnostic_dest='\/oracle\/db\/11.2.0'\r\n*.dispatchers='(PROTOCOL=TCP) (SERVICE=DR1XDB)'\r\n*.fal_client='DR1'\r\n*.fal_server='PRI'\r\n*.job_queue_processes=1000\r\n*.log_archive_config='DG_CONFIG=(PRI,DR1,DR2)'\r\n*.log_archive_dest_1='LOCATION=\/oracle\/fra\/DR1\/archivelog\/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=DR1'\r\n*.log_archive_dest_2='SERVICE=PRI LGWR ASYNC VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=PRI'\r\n*.log_archive_dest_3='SERVICE=DR2 VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=DR2'\r\n*.db_file_name_convert='\/oracle\/data\/PRI','\/oracle\/data\/DR1'\r\n*.log_file_name_convert='\/oracle\/data\/PRI','\/oracle\/data\/DR1'\r\n*.service_names='DR1'\r\n*.memory_target=821035008\r\n*.open_cursors=300\r\n*.processes=150\r\n*.remote_login_passwordfile='EXCLUSIVE'\r\n*.standby_file_management='AUTO'\r\n*.undo_tablespace='UNDOTBS1'\r\n\r\n<\/code><\/pre>\n<\/blockquote>\nCascaded Standby Database Parameter File<\/strong><\/p>\n
\n
\r\n \r\nDR2.__db_cache_size=226492416\r\nDR2.__java_pool_size=4194304\r\nDR2.__large_pool_size=4194304\r\nDR2.__oracle_base='\/oracle\/db\/11.2.0'#ORACLE_BASE set from environment\r\nDR2.__pga_aggregate_target=285212672\r\nDR2.__sga_target=536870912\r\nDR2.__shared_io_pool_size=0\r\nDR2.__shared_pool_size=289406976\r\nDR2.__streams_pool_size=4194304\r\n*.audit_file_dest='\/oracle\/db\/11.2.0\/admin\/DR2\/adump'\r\n*.audit_trail='db'\r\n*.compatible='11.2.0.0.0'\r\n*.control_files='\/oracle\/data\/DR2\/control01.ctl','\/oracle\/fra\/DR2\/control02.ctl'\r\n*.db_block_size=8192\r\n*.db_domain=''\r\n*.db_unique_name='DR2'\r\n*.db_name='PRI'\r\n*.db_recovery_file_dest='\/oracle\/fra'\r\n*.db_recovery_file_dest_size=10737418240\r\n*.diagnostic_dest='\/oracle\/db\/11.2.0'\r\n*.dispatchers='(PROTOCOL=TCP) (SERVICE=DR2XDB)'\r\n*.fal_client='DR2'\r\n*.fal_server='DR1'\r\n*.job_queue_processes=1000\r\n*.log_archive_config='DG_CONFIG=(PRI,DR1,DR2)'\r\n*.log_archive_dest_1='LOCATION=\/oracle\/fra\/DR2\/archivelog\/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=DR2'\r\n*.db_file_name_convert='\/oracle\/data\/PRI','\/oracle\/data\/DR2'\r\n*.log_file_name_convert='\/oracle\/data\/PRI','\/oracle\/data\/DR2'\r\n*.memory_target=821035008\r\n*.open_cursors=300\r\n*.processes=150\r\n*.remote_login_passwordfile='EXCLUSIVE'\r\n*.standby_file_management='AUTO'\r\n*.undo_tablespace='UNDOTBS1'\r\n\r\n<\/code><\/pre>\n<\/blockquote>\nAfter changed parameters for your systems, you can create spfile on the standby databases from pfile like below.<\/p>\n
\n
\r\nSQL> create spfile from pfile='\/tmp\/pfile.ora';\r\n<\/code><\/pre>\n<\/blockquote>\n7- Backup And Restore<\/strong><\/h3>\n
Backup From Primary Database<\/strong><\/p>\n
Your backup directory have to be the same at primary and standby servers.<\/p>\n
\n
\r\n[oracle@primary ~] rman target \/\r\n\r\nRMAN> run {\r\nALLOCATE CHANNEL d1 TYPE DISK FORMAT '\/oracle\/backup\/backup_pri_%d_s%s_p%p_%T' ;\r\nbackup as compressed backupset database plus archivelog;\r\nbackup current controlfile for standby format '\/oracle\/backup\/controlfile_standby.ctl' ;\r\nrelease channel d1;\r\n}\r\n\r\n<\/code><\/pre>\n<\/blockquote>\nCopy Backup Files to Standby Servers.<\/strong><\/p>\n
You can use scp command or ftp file transfer application to transport backups.<\/p>\n
Restore Cascading Standby Database<\/strong><\/p>\n
\n
\r\n[oracle@dr1 ~] sqlplus \/ as sysdba\r\nSQL> create spfile from pfile='\/tmp\/pfile.ora';\r\nSQL> startup nomount;\r\nSQL> exit;\r\n\r\n[oracle@dr1 ~] rman target \/\r\n\r\nconnected to target database: PRI (not mounted)\r\n\r\nRMAN> restore standby controlfile from '\/oracle\/backup\/controlfile_standby.ctl';\r\n\r\nStarting restore at 02-MAR-17\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=19 device type=DISK\r\n\r\nchannel ORA_DISK_1: restoring control file\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\r\noutput file name=\/oracle\/data\/DR1\/control01.ctl\r\noutput file name=\/oracle\/fra\/DR1\/control02.ctl\r\nFinished restore at 02-MAR-17\r\n\r\nRMAN> sql 'alter database mount standby database';\r\n\r\nsql statement: alter database mount standby database\r\nreleased channel: ORA_DISK_1\r\n\r\nRMAN> restore database;\r\n\r\nStarting restore at 02-MAR-17\r\nStarting implicit crosscheck backup at 02-MAR-17\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=27 device type=DISK\r\nCrosschecked 4 objects\r\nFinished implicit crosscheck backup at 02-MAR-17\r\n\r\nStarting implicit crosscheck copy at 02-MAR-17\r\nusing channel ORA_DISK_1\r\nFinished implicit crosscheck copy at 02-MAR-17\r\n\r\nsearching for all files in the recovery area\r\ncataloging files...\r\nno files cataloged\r\n\r\nusing channel ORA_DISK_1\r\n\r\nchannel ORA_DISK_1: starting datafile backup set restore\r\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\r\nchannel ORA_DISK_1: restoring datafile 00001 to \/oracle\/data\/DR1\/system01.dbf\r\nchannel ORA_DISK_1: restoring datafile 00002 to \/oracle\/data\/DR1\/sysaux01.dbf\r\nchannel ORA_DISK_1: restoring datafile 00003 to \/oracle\/data\/DR1\/undotbs01.dbf\r\nchannel ORA_DISK_1: restoring datafile 00004 to \/oracle\/data\/DR1\/users01.dbf\r\nchannel ORA_DISK_1: restoring datafile 00005 to \/oracle\/data\/DR1\/example01.dbf\r\nchannel ORA_DISK_1: reading from backup piece \/oracle\/backup\/backup_pri_PRI_s2_p1_20170302\r\nchannel ORA_DISK_1: piece handle=\/oracle\/backup\/backup_pri_PRI_s2_p1_20170302 tag=TAG20170302T170208\r\nchannel ORA_DISK_1: restored backup piece 1\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:35\r\nFinished restore at 02-MAR-17\r\n\r\nRMAN> recover database;\r\n\r\nRMAN> exit;\r\n\r\n[oracle@primary ~] sqlplus \/ as sysdba\r\nSQL> shu immediate;\r\nSQL> startup mount;\r\n\r\n<\/code><\/pre>\n<\/blockquote>\nRestore Cascaded Standby Database<\/strong><\/p>\n
\n
\r\n\r\nThe same steps like cascading standby restore and recovery steps.\r\n\r\n<\/code><\/pre>\n<\/blockquote>\n8- Create Standby Log File<\/strong><\/h3>\n
For real time apply you have to create standby log file at cascading standby database. This standby log files have to be the same size with redo log files and should be more 1 than redo log count.<\/p>\n
\n
\r\n\r\nCheck primary redo log sizes and count with below.\r\n\r\n[oracle@primary ~] sqlplus \/ as sysdba\r\n\r\nSQL> select group#,bytes from v$log;\r\n GROUP#\tBYTES\r\n---------- ----------\r\n\t 1 52428800\r\n\t 2 52428800\r\n\t 3 52428800\r\n\r\nYou can see this example, 3 redo log files and 50 MB size. We have to add 4 standby log files and size has to be 50 MB.\r\n\r\nCreate Standby Log Files at Cascading Standby Database.\r\n\r\n[oracle@dr1 ~] sqlplus \/ as sysdba\r\n\r\nSQL> alter database add standby logfile size 50M;\r\n\r\nDatabase altered.\r\n\r\nSQL> alter database add standby logfile size 50M;\r\n\r\nDatabase altered.\r\n\r\nSQL> alter database add standby logfile size 50M;\r\n\r\nDatabase altered.\r\n\r\nSQL> alter database add standby logfile size 50M;\r\n\r\nDatabase altered.\r\n\r\n<\/code><\/pre>\n<\/blockquote>\n9- Start Listener<\/strong><\/h3>\n
Standby Listeners have to be started state.<\/p>\n
Start Listener<\/strong><\/p>\n
\n
\r\n\r\n[oracle@dr1 dbs]$ lsnrctl start\r\n\r\nLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 22-MAR-2017 17:48:22\r\n\r\nCopyright (c) 1991, 2011, Oracle. All rights reserved.\r\n\r\nStarting \/oracle\/db\/11.2.0\/db_home\/bin\/tnslsnr: please wait...\r\n\r\nTNSLSNR for Linux: Version 11.2.0.3.0 - Production\r\nSystem parameter file is \/oracle\/db\/11.2.0\/db_home\/network\/admin\/listener.ora\r\nLog messages written to \/oracle\/db\/11.2.0\/diag\/tnslsnr\/dr1\/listener\/alert\/log.xml\r\nListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dr1.localdomain)(PORT=1521)))\r\nListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))\r\n\r\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dr1.localdomain)(PORT=1521)))\r\nSTATUS of the LISTENER\r\n------------------------\r\nAlias LISTENER\r\nVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production\r\nStart Date 22-MAR-2017 17:48:22\r\nUptime 0 days 0 hr. 0 min. 10 sec\r\nTrace Level off\r\nSecurity ON: Local OS Authentication\r\nSNMP OFF\r\nListener Parameter File \/oracle\/db\/11.2.0\/db_home\/network\/admin\/listener.ora\r\nListener Log File \/oracle\/db\/11.2.0\/diag\/tnslsnr\/dr1\/listener\/alert\/log.xml\r\nListening Endpoints Summary...\r\n (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dr1.localdomain)(PORT=1521)))\r\n (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))\r\nServices Summary...\r\nService \"DR1\" has 1 instance(s).\r\n Instance \"DR1\", status UNKNOWN, has 1 handler(s) for this service...\r\nService \"DR2\" has 1 instance(s).\r\n Instance \"DR2\", status UNKNOWN, has 1 handler(s) for this service...\r\nThe command completed successfully\r\n\r\n\r\n[oracle@dr2 ~]$ lsnrctl start\r\n\r\nLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 22-MAR-2017 17:51:22\r\n\r\nCopyright (c) 1991, 2011, Oracle. All rights reserved.\r\n\r\nStarting \/oracle\/db\/11.2.0\/db_home\/bin\/tnslsnr: please wait...\r\n\r\nTNSLSNR for Linux: Version 11.2.0.3.0 - Production\r\nSystem parameter file is \/oracle\/db\/11.2.0\/db_home\/network\/admin\/listener.ora\r\nLog messages written to \/oracle\/db\/11.2.0\/diag\/tnslsnr\/dr2\/listener\/alert\/log.xml\r\nListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dr2.localdomain)(PORT=1521)))\r\nListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))\r\n\r\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dr2.localdomain)(PORT=1521)))\r\nSTATUS of the LISTENER\r\n------------------------\r\nAlias LISTENER\r\nVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production\r\nStart Date 22-MAR-2017 17:51:22\r\nUptime 0 days 0 hr. 0 min. 10 sec\r\nTrace Level off\r\nSecurity ON: Local OS Authentication\r\nSNMP OFF\r\nListener Parameter File \/oracle\/db\/11.2.0\/db_home\/network\/admin\/listener.ora\r\nListener Log File \/oracle\/db\/11.2.0\/diag\/tnslsnr\/dr2\/listener\/alert\/log.xml\r\nListening Endpoints Summary...\r\n (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dr2.localdomain)(PORT=1521)))\r\n (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))\r\nServices Summary...\r\nService \"DR1\" has 1 instance(s).\r\n Instance \"DR1\", status UNKNOWN, has 1 handler(s) for this service...\r\nService \"DR2\" has 1 instance(s).\r\n Instance \"DR2\", status UNKNOWN, has 1 handler(s) for this service...\r\nThe command completed successfully\r\n\r\n<\/code><\/pre>\n<\/blockquote>\n10- Connect And Start Apply On Standby Databases<\/strong><\/h3>\n
In the last case the standby databases were in mount mode. We can use alter database open read only command.<\/p>\n
Cascading Standby<\/strong><\/p>\n
\n
\r\n\r\n[oracle@dr1 dbs]$ sqlplus \/ as sysdba\r\n\r\nSQL> alter database open read only;\r\n\r\nDatabase altered.\r\n\r\nSQL> alter database recover managed standby database using current logfile disconnect;\r\n\r\nDatabase altered.\r\n\r\n<\/code><\/pre>\n<\/blockquote>\nCascaded Standby<\/strong><\/p>\n
\n
\r\n\r\n[oracle@dr1 dbs]$ sqlplus \/ as sysdba\r\n\r\nSQL> alter database recover managed standby database disconnect from session;\r\n\r\nDatabase altered.\r\n\r\n<\/code><\/pre>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"Oracle 11g R2 database supports cascade standby database structure. If you are using RAC on primary side, your database version has to be least 11.2.0.2 to support cascade standby structure. You can use to reduce the load on your primary database with using cascade standby database structure. Primary database redo is written to the standby…<\/p>\n","protected":false},"author":37,"featured_media":0,"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":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9,20],"tags":[14,32],"class_list":["post-2285","post","type-post","status-publish","format-standard","hentry","category-administration","category-oracle-backup-and-recovery","tag-database-administration","tag-oracle-administration"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-AR","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2285","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=2285"}],"version-history":[{"count":13,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2285\/revisions"}],"predecessor-version":[{"id":2307,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2285\/revisions\/2307"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2285"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}