how to configure standby database in oracle 10g

PRIMARY > select logmode from vdatabase LOGMODE - ARCHIVELOG - Enable force loggin: - FORCE LOGGING is required, every changes in database will go to redo logs, which will be applied on standby SQL > ALTER DATABASE FORCE LOGGING Database altered. For more information about Oracle (NYSE:ORCL), visit . PRIMARY: Make sure database is archive log mode, and enable force logging. Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. To view full details, sign in with your My Oracle Support account.ĭon't have a My Oracle Support account? Click to get started! Login to the Primary database server ORACLESIDctdbp export ORACLESID. Lets add another standby with the name SSTD. Creating a Standby Database using RMAN - 10g - Unix Pre-required/Assumes: On Primary: dbname ctgbp. This document provides the step by step approach on adding a second standby to an existing dataguard configuration.

Physical standby database (disabled): sstd In this article, we will set up physical standby on Oracle Linux 7.6 server. We need to make several changes to the primary database before we can even setup the standby database. There are various steps in which you can configure physical standby database. NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious dataįrom the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material.Īny similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.įor the purposes of this document, the following fictitious environment is used as an example to describe the procedure: Oracle Data Guard Physical Standby Configuration.

How to configure standby database in oracle 10g