Initialization parameter DB_RECOVERY_FILE_DEST_SIZE set to '20g'. RMAN configuration archivelog deletion policy set to SHIPPED TO ALL STANDBY. Initialization parameter DB_LOST_WRITE_PROTECT set to 'TYPICAL'. Initialization parameter DB_FLASHBACK_RETENTION_TARGET set to 120. Starting database 'cdb1' to mounted mode. Primary database must be restarted to enable archivelog mode.

Primary database must be restarted after setting static initialization parameters. Initialization parameter LOG_BUFFER set to 268435456. Initialization parameter DB_FILES set to 1024.

Here is an example of the command used during my Vagrant 21c Data Guard build.ĭgmgrl / > Preparing database 'cdb1' for Data Guard. Prepare a primary database for a Data Guard environment. Welcome to DGMGRL, type 'help' for information. We make a bequeath connection to the database and issue the HELP PREPARE command to see the syntax.ĭGMGRL for Linux: Release 21.0.0.0.0 - Production on Sun Feb 6 13:11:59 2022Ĭopyright (c) 1982, 2021, Oracle and/or its affiliates. In Oracle 21c these steps can be performed using the PREPARE DATABASE FOR DATA GUARD command. Set the STANDBY_FILE_MANAGEMENT initialization parameter and enable the broker.Īlter system set standby_file_management=auto Set the DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST initialization parameters.Īlter system set db_recovery_file_dest_size=400g Īlter system set db_recovery_file_dest='/u01/app/oracle/fast_recovery_area' Įnable archivelog mode and force logging.Īlter database add standby logfile thread 1 group 10 size 50m Īlter database add standby logfile thread 1 group 11 size 50m Īlter database add standby logfile thread 1 group 12 size 50m Īlter database add standby logfile thread 1 group 13 size 50m For a simple single instance primary database they might look like this. There are a number of steps necessary to prepare a primary database before configuring Data Guard.

Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 21c.

The PREPARE DATABASE FOR DATA GUARD Command in Oracle Database 21c.

The PREPARE DATABASE FOR DATA GUARD command simplifies the setup of the primary database when configuring Data Guard in Oracle database 21c. Home » Articles » 21c » Here Data Guard : The PREPARE DATABASE FOR DATA GUARD Command in Oracle Database 21c

Alter system db recovery file dest size