Oracle Cloud (DBaaS): Oracle Data Guard in Database Cloud Service ( DBCS )

    Aug 28, 2017 12:56:00 AM by Skant Gupta

    This article was written by Skant Gupta and Joel Perez in Oracle OTN

    When creating an Oracle Database Cloud Service database deployment at the Oracle Database Cloud Service level, you can create an Oracle Data Guard configuration.

    Since we will talk about Oracle Data Guard, let’s remember the concept:

    Oracle Data Guard enables production Oracle databases to survive disasters and data corruptions by providing a comprehensive set of services that create, maintain, manage, and monitor a standby database. Oracle Data Guard maintains the standby database as a copy of the production database. If the production database becomes unavailable because of a planned or an unplanned outage, you can switch the standby database to the production role, minimizing the downtime associated with the outage.

    To create an Oracle Data Guard configuration in Database Cloud Service, make the following choices in the Create Service wizard:

    • For Service Level, choose Oracle Database Cloud Service.
    • For Software Edition, choose Enterprise Edition, Enterprise Edition – High Performance, or Enterprise Edition – Extreme Performance.
    • For Database Type, choose Single Instance with Data Guard Standby.
    • For Standby Database Configuration (on the Service Details page), choose where you want the standby database placed in relation to the primary database:
    • High Availability—The standby database is placed in a different availability domain from the primary database, thus providing isolation at the infrastructure level.
    • Disaster Recovery—The standby database is placed in a different data center from the primary database, thus providing isolation at the infrastructure level and geographical separation to support availability despite catastrophic events.

    When you make these choices, Database Cloud Service creates an Oracle Data Guard configuration with a primary database and a single standby database, hosting the databases on two independent compute nodes. It creates these compute nodes using computing, storage and networking resources provided by Oracle Compute Cloud service.

    Create the Oracle Data Guard in Cloud Database Service

    a) Login to your Oracle cloud services account, go to the “Oracle Database Cloud Service” page and create a new service.

    • For Service Name, select DATAGUARD.
    • From the Service Level list, select Oracle Database Cloud Service.
    • From the Metering Frequency list, select whatever frequency is appropriate for your environment.
    • From the Software Release list, select Oracle Database 11g Release2.
    • From the Software Edition list, select Enterprise Edition.
    • From the Database Type list, select Single Instance with Data Guard Standby.

    Then click Next to continue.

    If you want to read rest to the article, go across this link : Oracle Data Guard in Database Cloud

    Tags: Toad for Oracle

    Skant Gupta

    Written by Skant Gupta

    Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. He is also Technical Writer on and with more than 30 article published in Oracle Technical Network.