![Creating a Standby on 21c [Single Instance]](https://project42.site/wp-content/uploads/2021/09/Standby_DBCA_21c-360x240.png)
For this post, I just wanted to test the same DBCA option we saw in the past to create Standby but this time on 21c. The first thing I have to clarify is that I will be using rac1-node1 to host the 21c primary database (cdb21) and rac1-node2 to host our new Standby (cdbst21). The... » read more
![A warning about DG Broker “PREPARE DATABASE FOR DATA GUARD” command on 21c [21.3 version]](https://project42.site/wp-content/uploads/2021/09/21c-Data-Broker-360x240.png)
One of the new features of 21c Data Guard Broker is the ability to prepare a Database for Dataguard Configuration running a simple command. It is very handy feature since DG broker will enable Archive Mode, restart the database, create the Standby Redo logs, etc.. Before you use it though, please be aware of some... » read more
![DML Operations over Standby in Active Dataguard [19c feature]](https://project42.site/wp-content/uploads/2020/12/DML-Redirect-360x240.png)
One of the new Features for 19c database is the possibility to execute DML operations (INSERT, UPDATE, DELETE…) over a Standby in a Active Dataguard configuration. The operation itself won’t be actually executed in the standby, but redirected to the primary where will be executed and then apply in the standby by the Recovery Process.... » read more
![Standby Automatic Flashback [19c feature]](https://project42.site/wp-content/uploads/2020/12/Automatic_flashback-360x240.jpg)
One of the new Database 19c Features is the possibility of automatically Flashback the standby database if the Primary has been Flashback. There are couple of requisites though, the Standby has to have Flashback enabled, and in order for the Automatic flashback to start, the standby has to be mounted Lets do a quick test... » read more
Converting a Physical Standby Database to Snapshot Standby can be of a great solution if you need to do some new code test in a system but you can’t have a full Test Clone. Also, since the standby is a block by block copy of the Primary, we are making sure the test is made... » read more
![Create RAC Standby Database Using DBCA [19c Version]](https://project42.site/wp-content/uploads/2020/08/Standby_DBCA_RAC-360x240.png)
DBCA evolves the same way than most Oracle Components, and since 12.2 version, you can create Standby Databases directly using DBCA. Before you start, is important to check your version limitation, so for example, 12.2 only allows single instance Databases to be created (see this article by Frank Pachot [https://blog.dbi-services.com/12cr2-dbca-can-create-a-standby-database/]), but that is not longer... » read more
![Create Single Instance Standby Using DBCA [12.2 Version]](https://project42.site/wp-content/uploads/2020/08/Standby_DBCA-360x240.png)
Since 12.2, dbca can create Standby Databases directly, but with some restrictions, like only for Single Instance Databases and only non container Databases. This has changed for each version, and since 18c, you can create the RAC Standby and they can have PDBs (will have an article about that soon 🙂 ) For this test,... » read more
![Create Standby using RMAN Duplicate [12.2 Version]](https://project42.site/wp-content/uploads/2020/08/Standby-360x240.png)
While I was starting another project, I realised I don’t have any post covering Standby Database creation. Everyone has their own way of doing things, but last time I needed to create one, this was how I ended up doing it. The Primary Database will be called TEST and run in RAC1 cluster (rac1-node1 /... » read more
![Rolling Forward a Physical Standby using “Recover From Service” command [12.1 feature]](https://project42.site/wp-content/uploads/2020/08/mind-gap-360x240.jpg)
This is what we can see from the Oracle Doc ID 1987763.1 regarding Recover standby from Service option added in 12.1: Rolling Forward a Physical Standby Using Recover From Service Command in 12c (Doc ID 1987763.1) ========================================================================= Prior to 12c, in order to roll forward the standby database using incremental backups you would need to:... » read more