Overview: Below are the questions asked to a candidate with 10 years of experience in Oracle DBA and postgres . There were 2 rounds.   Round 1 :  What are your day to day activities. And what is...

Though we can the active duplication method, to clone a database from live running database. But sometime we may need to clone a database from a RMAN backup set. Below example will cover the steps for...

In this article we have listed the most useful RMAN commands . 1. Take full backup(incremental level 0 of the database) rman target / configure backup optimization on; configure controlfile autobackup...

If the requirement is to delete archive log backups automatically (without taking backup), then below shell script can be configured in crontab. prepare the shell script. cat rman_arch_del.sh #!/bin/b...

In this article, we will duplicate the database(with new db_name) from tape backup, without connecting to source database. We will only connect to the recovery catalog and auxiliary instance. SOURCE D...

PROBLEM: Observed below error in the alert log Wed Nov 29 03:27:44 2017 Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prd_m000_102938.trc: ORA-19815: WARNING: db_recovery_file_dest_size of...

PROBLEM: Archive logs are not getting deleted with RMAN command, and it is reporting below warnings. RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archi...

Below is the script for taking backup of archive log between sequence number 1000 to 1050 For standalone database: RMAN> backup format '/archive/%d_%s_%p_%c_%t.arc.bkp' archivelog from sequence 100...

PROBLEM: While taking rman backup, it failed with below error ( ORA-19809 & ORA-19804) RMAN> backup archivelog all; Starting backup at 26-MAY-17 current log archived using channel ORA_DISK_1 ch...

PROBLEM: While duplicating a database using RMAN active cloning in RAC database, got below error.(ORA-65500) RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of sql comman...