My Posts on Standby Database[s] -- Data Guard

Although I have, in previous posts, covered Data Guard in 12c (and 12cR1 RAC), this is a list of recent Blog Posts on Data Guard. 

1.  Quickly creating a Standby Database in 19c  (Feb-20)

2.  Redo Shipping for Standby Database in 19c  (Mar-20)

3. Using FLASHBACK DATABASE for [destructive] D.R. Testing  (Mar-20)

4.  Restoring a lost Datafile on a Standby Database and knowing about V$RECOVER_FILE  (May-20)

5.  V$RECOVER_FILE and PDB$SEED and Standby Database  (May-20)

6.  RMAN Backup of a Standby Database  (May-20)

7.  Full Recovery of Standby Database over the network  (Jun-20)

8.  Archive Log Deletion Policy with a Standby Database  (Jul-20)

9.  Creating a PDB as a Clone in a DataGuard environment  (Sep-20)

10.  Active Data Guard and DML Redirection  (Nov-20)

11.  Primary and Standby in the same RMAN Catalog  (Apr-21)

12.  Tracking the Standby Lag from the Primary  (May-21)

13.  Restoring a Standby Database to the Primary  (Jun-21)

14.  Using a Snapshot Standby Database for [destructive] D.R. Testing  (Jun-21)

15.  Failover to a Standby with Data Loss  (Jul-21)

16.  Creating [1 or more] Additional Standby Database[s]  (Jul-21)

17.  A Standby that lags the Primary by a deliberate Delay  (Jul-21)

18.  Opening a Lagging Standby Database (to verify data ?)  (Jul-21)

19.  Failover and Database Incarnation  (Aug-21)

20.  Restoring Standby Database after Failover  (Aug-21)

21.  ADG and DML Redirection -- with Multiple Standbys  (Sep-21)

22.  Resuming Standby Databases after a RESETLOGS (without Data Loss from Online Redo Logs !!) at the Primary  (Sep-21)

22.  A few dgmgrl (DataGuard Broker) commands  (Jul-24)

My Posts on Database Flashback

 

My Blog Posts on Database Flashback

(The first 5 demonstrations are in 11gR2.  The last demonstration is in 19c)

My Blog Posts on the FLASHBACK DATABASE command

1.  Introduction to Operations

2.  Flashback Requires Redo (ArchiveLog)

3.  Purging (older) Flashback Logs

4.  Flashback Database Logs can exceed the Retention Target

5.  Flashback Pluggable Database
.
.
.

(not in the series)

6.  Using FLASHBACK DATABASE for [destructive] D.R. Testing

My Posts on Parallel Execution

My series of blog posts on Parallel Execution

(These demonstrations were against Oracle 11gR2.  19c may have new features / changes / improvements)

1.  Parallel Execution -- 1 The PARALLEL Hint and AutoDoP  (Feb-15)

2.  Parallel Execution -- 1b The PARALLEL Hint and AutoDoP (contd)  (Mar-15)

3.  Parallel Execution -- 2 PX Servers  (Mar-15)

4.  Parallel Execution -- 2b PX Servers  (Mar-15)

5.  Parallel Execution -- 2c PX Servers  (Mar-15)

6.  Parallel Execution -- 3 Limiting PX Servers  (Mar-15)

7.  Parallel Execution -- 3b Limiting PX Servers with Resource Manager  (Apr-15)

8.  Parallel Execution -- 4 Parsing PX Queries  (Apr-15)

9.  Parallel Execution -- 5 Parallel INSERT  (May-15)

10.  Parallel Execution -- 5b Parallel INSERT Execution Plan  (May-15)

11.  Parallel Execution -- 6 Parallel DML Restrictions  (May-15)

Download Oracle Database Virtual Box / Vagrant / Docker Images

 A few websites where you can download Oracle Database images for practice at home under single user licences

Prebuilt Oracle Virtual Box VMs from Oracle's download site

Oracle's Vagrant Projects on GitHub

Oracle's Database Examples on GitHub

Oracle-Base (Tim Hall) GitHub  (Docker and Vagrant)