Creation of a standby database in 19c is pretty simliar to 11g except of two points: 1- Using the compressed feature in the Duplicate command  “USING COMPRESSED BACKUPSET” can speed up the whole process by 200%. [12.2 New feature] 2- TEMPFILES will be created automatically whenStandby DB get opened in OPEN mode. Before we start […]

Problem: The Duplicate of a standby DB fails with the following error: ORA-32006: CLUSTER_DATABASE initialization parameter has been deprecated ORA-39511: Start of CRS resource for instance ‘223’ failed with error:[CRS-5702: Resource ‘ora.asm’ is already running on ‘ORCLDR_N1’ CRS-0223: Resource ‘ora.asm’ has placement error. clsr_start_resource:260 status:223 clsrapi_start_asm:start_asmdbs status:223 Analysis: The database which is being created is […]

 Starting with Oracle 12.2, AWR can be configured and run against Standby DB, before that release (since 11gR2) the only option available for having similar data was by generating an ASH report on the Standby DB, which was limited by how much data is still available in the standby instance memory. Here are the briefed […]

While creating a Standby database on a RAC environment from another RAC database using duplicate method I was getting this weird error: RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of Duplicate Db command at 05/20/2020 14:20:14RMAN-05501: aborting duplication of target databaseRMAN-03015: error occurred in stored script Memory ScriptORA-19845: error in backupControlFile while […]

This script is designed to run against STANDBY databases to deleted applied archives older than specific number of hours defined by the user. It maintains that un-applied archives remain un-touched. Download the script: https://www.dropbox.com/s/xx5o6b94rv5ps30/delete_applied_archives_on_standby.sh?dl=0 How to use the script:   ⏩ Set MAIL_LIST variable to your E-mail to receive an email alert if archives are not […]

I had a requirement to set the archive apply delay feature between the primary and the standby DB, where the archives will be sent immediately to the standby site but will get applied in a delay of one hour. Such feature enables you to eliminate any erroneous update get executed on the primary from being […]

When it comes to catastrophic scenarios where the database has been corrupted and there is no available backup, flashback feature was not turned on, database cannot be open due to errors or inconsistent status, there is still a chance to recover and save the data as long as the datafiles are still exist on the […]

Considering RMAN image copy backup for your production databases in your backup strategy is a very helpful approach to easily recover from disk failure scenarios. Why consider RMAN image backups in your backup strategy:It helps you fix disastrous situations due to physical damages, such as losing one or more datafiles in a minimal downtime, by […]

You need to synchronize a standby DB from an incremental RMAN backup in these two cases:1-There is a big gap between the primary database and the standby database whereas copying and applying the archives from Production to DR site will take a long time.2-You lost one or more archive log file on the primary site […]

Switch Over:Switch over means to switch the roles between the Primary DB and the Standby DB, so after the Switch over the Primary DB will act as the standby DB, and the Standby DB will act as the Primary DB.This approach is usually being used during the DR drills, where the standby database will be […]