Oracle 12c Data Guard Create Physical Standby Database

#Purpose
This tutorial describes the steps to create an Oracle 12c Physical Standby database.
The tutorial was implemented using Oracle VirtualBox version 5 and an appliance with Oracle Database

12c Release 1 installed on Linux 6 with Automatic Storage Management (ASM) instance

#Tutorial Document
The tutorial has been documented and its document can be downloaded from the following link:

#TIMESTAMPS
0:03 Introducing the tutorial
2:08 Oracle Data Guard Usages
5:29 Start of the tutorial
10:20 Prepare the tutorial environment
31:45 Prepare the Primary Database
45:19 Prepare the Standby Database system
50:55 Create the Physical Standby Database

#LINKS
Have a look at my course

#about Ahmed Baraka
I began my career as an Oracle Developer but soon transitioned to Oracle Database Administration. I have 18 years of extensive experience in the computer industry, with focus on Oracle database administration technologies like Oracle RAC, ASM, Data Guard, GoldenGate, WebLogic, Database Appliance, and Enterprise Manager.

# Download
You can download the VM machines (appliances) that has been created in the tutorial from the following link:

#Contact Info

[sata]

perfect you are a great gentleman, gods keep your health, and still a big thank you.

[Jorge-jstl]

If you guys are configuring a single instance standby for a RAC production database, remember: You have to use "set CLUSTER_DATABASE='FALSE'" in duplicate database command.

[sharathkumarmarathe]

Amazing.. thanks very much Ahmed.. Indeed helpful for a beginner....

[robertoxocop]

This tutorial was very helpful to me. thanks Amhed.

[fadialdebir]

thank you sir, ,, to make it on 19c with Dataguard broker

[syedibrahim]

Ahmed sir, this is one of the best video I could find for data guard setup, Thank you so much for this.
I have a small query: The tutorial here is using ASM database and have following section:

"We are using ASM, so the directories under ASM diskgroups should also be created:
su - grid
asmcmd
cd DATA
mkdir ORADB_S2
mkdir ORADB"

My question is: If we are using Database without ASM, then can we skip that step? And are there any other change in steps mentioned? Thanks in advance.

[ajeshkumar]

hi sir, it is very nice and informative for me. many thanks to u

I have oracle virtual box 5. can u please share me the link for downloading oracle asm appliances to get installed oracle database with asm instance

[Daniel-hzdn]

Hi Ahmed, Very nice video, great explanation on how to setup a Physical Standby for a Non-CDB database. One question, is it possible to setup Data Guard between a Non-CDB Primary Database and a standby in a PDB ? Also, How do you switchover the instances ? Would you have to configure DG Broker to do so ?

[dbloyd]

Dataguard doesn't work for my site. It would take weeks to switch all the systems to point to the new location. I wish there was a solution that can redirect all connections to a new instance.

[Jorge-jstl]

Ahmed, everything was going well, but the command "alter database flashback on;" after "alter database recover managed standby database cancel;" does not work. It results the following error:
SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38788: More standby database recovery is needed

Do you know why? The duplicate command completed with no errors and the apply process seems to be stopped, as you suggested.

I finished the instructions bypassing that step, why do you need to have flashback enabled on the standby database?

btw, i bought your course, that seems to be very good. (I just started)

[WV]

Awesome presentation clarity. TU. Anywhere to download iso for vmware ?

[jeanmarieassah]

Hello Ahmed Baraka, I am very happy with the oracle videos on your youtube channel, I have something to do with you, I would like you to take a course on fundamental SQL

[acoustic_living]

I have 2 questions:

> 8.1 Configure ARCHIVELOG DELETION POLICY in RMAN in both systems
rman target /
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;


Will it delete the archivelogs from the system or will it just make the archivelogs obsolete and we need to fire Rman "Delete obsolete"' to actually delete the archivelogs.

>8.4 Register the standby database in the Oracle Restart:

srvctl add database -db ORADB_S2 -instance ORADB_S2 -oraclehome
-startoption MOUNT -stopoption IMMEDIATE -policy AUTOMATIC -
role physical_standby -spfile

Why is the spfile location Local, can this be changed to +DATA

[Jorge-jstl]

Hello Ahmed, thank you for your video!

I would like to ask you something..

How do you determine appropriately the number of standby redo log file groups in a RAC scenario? I have a 2 nodes RAC database which I want to configure a single node Data Guard "backup" instance for.

I've tried to configure a physical standby database using the Oracle Enterprise Manager CC 13c, but unfortunately it does not work, have you ever configured a standby database using EM 13c? Does it require additional steps than just clicking on "Configure a standby database", and then following that simple wizard?

I've noticed you have a course about that on udemy, I am thinking about buying that, but my environment is all based on Oracle Linux 7 + Oracle Database 12c + RAC, do you think your course would help me?

[AltafHussain-hyfo]

Hello,
How to find query generating more redo/archive log in Oracle database?
Thanks

[Rhymes_days]

Is Primary db and Standby can use same DB name?

[Jorge-jstl]

Ahmed, Why do you delete that multiplexed standby redo files? Just to free space? In my production scenario I have a 2 Node RAC, using 8 redo groups. which should use (8+1)*2=18 files, so 36 after multiplexing.

[MrEnriquek]

do we need to have both the primary and the standy on the same patch set level ? how about creating RAC to RAC data guard broker managed ? it will be great, thanks

[sharathkumarmarathe]

Can you share please the passwords for oracle, grid and root to use the appliance ? i downloaded it however unable to use due to not having passwords :( I have also sent email regarding the same in the contact form of the site..

[Batmunkhcom]

Hi Ahmed Braka!. What is your email or chat ?