Today I am going to cover step by step configuration for Oracle Dataguard & may be in next or future posts I will discuss on common mistakes which you can do while configure dataguard \/ standby database.<\/p>\n
Below steps are based on assumptions that Primary Database is on Machine1.domain.com<\/strong> & Standby database is on Machine2.domain.com<\/strong> . Database Instance Name is PROD <\/strong>and database listener is listening on port 1525<\/strong>. Mount point on primary & standby database are same (If they are not you need to set parameter db_file_convert<\/em><\/span>)<\/p>\n Assumptions<\/strong> You may have to change options with log shipping service (LOG_ARCHIVE_DEST_n) depending on data protection mode you wish to choose.<\/em><\/span> (I am using Maximum Performance Mode – Default Mode<\/span>)<\/p>\n Enable Archive log <\/strong> SQL> SHUTDOWN SQL> alter system set LOG_ARCHIVE_DEST_1 =’LOCATION=\/u01\/oracle\/data\/arch’ scope=spfile; (I am assuming that you are using spfile here , if you are using pfile skip scope=spfile<\/span>)<\/p>\n SQL> alter system set LOG_ARCHIVE_DEST_2 =’SERVICE=PROD_remote1.domain.com LGWR ASYNC REOPEN=60′ scope=spfile; (We will create above TNS Alias in next step<\/span>) SQL> shutdown immediate You should see archive logs generated after this on standby site<\/p>\n Enable Force Logging <\/strong> Set Initialization Parameter<\/strong> Today I am going to cover step by step configuration for Oracle Dataguard & may be in next or future […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[87,85,88],"class_list":["post-92","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-datraguard","tag-dr","tag-failover"],"yoast_head":"\n
\nI am assuming using LGWR, ASYNC option with log shipping service which means ,
\nLGWR (Log Writer process will be used to write to standby site instead of ARC archiver process<\/span>)
\nASYNC (Redo logs to standby is asynchronous<\/strong> to primary site)<\/p>\n
\nFor standby database configuration your primary database should be running in achieve log mode. In order to convert your primary database into archive log mode follow these steps<\/p>\n
\nSQL> STARTUP MOUNT
\nSQL> ALTER DATABASE ARCHIVELOG;
\nSQL> ALTER DATABASE OPEN;<\/p>\n
\nSQL> alter system log_archive_dest_2=’DEFER’ (Defer this until you have standby system Up<\/span>)<\/p>\n
\nSQL> startup<\/p>\n
\nYou should enable Force logging in primary database else if some transaction which doesn’t generate redo log can corrupt your standby database. (Careful in OLTP transactions or long running requests in Apps<\/em><\/span>)
\nSQL> ALTER DATABASE FORCE LOGGING;<\/p>\n
\nSQL> alter system set fal_client =<\/p>\n","protected":false},"excerpt":{"rendered":"