Starting with 12.2, Oracle introduced a new feature called Multi-Instance Redo Apply (MIRA), in a nutshell, this feature allows the Redo Apply to sync the data from all standby nodes (in parallel) which improves the scalability of Redo Apply on Standby RAC DB. But the bad news is that, this feature is not functioning properly, […]

This shell script can help you schedule RMAN full backup from the Crontab:https://www.dropbox.com/home?preview=schedule_rman_full_bkp.sh In case you are interested in an interactive script to run it manually then use this script:https://dba-tips.blogspot.com/2017/03/rman-backup-script.html For the first script before you schedule it to run in the crontab you have to do the following: Modify the following mandatory parameters at […]

Problem: On a 19.5 database, I was trying to duplicate a database from an RMAN backup, first time the duplicate failed after restoring 90% of the datafiles due to space limitation on the underlying datafiles location, I re-ran the same duplicate command for the second time without deleting the already restored datafiles to see if […]

Case: Let’s suppose you created a new datafile and missed the .dbf extension or had a typo in the name but you want to fix it. Let’s suppose the bad datafile name is /data01/STFBKUAT01/datafile/users012 and it should be renamed to /data01/STFBKUAT01/datafile/users02.dbf Prerequisite: – The database should be in ARCHIVELOG mode. – It’s always recommended to […]

Problem: While restoring a Non-Production DB from RMAN backup using Duplicate method , I received this error: RMAN-05502: the target database must be mounted when issuing a DUPLICATE command Here is the RMAN script I was using: # export ORACLE_SID=pssp # rman AUXILIARY / RMAN>  run { ALLOCATE AUXILIARY CHANNEL ch1  DEVICE TYPE DISK; ALLOCATE […]

This hassle free RMAN backup Shell script helps the DBA to take an on-demand self-contained & consistent RMAN backup for Oracle database resides on Linux OS. It will help to easily specify the number of channels, select backup options (Compression/Encryption) and then it will run in the background in nohup mode. Script download: https://www.dropbox.com/s/l3g17oxz6j56cdz/RMAN_full.sh?dl=0 How […]

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 […]