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...
rman
How to duplicate database using RMAN backup set
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...
Useful RMAN commands
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...
Shell script to delete old archives using RMAN
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...
Duplicate a database from RMAN TAPE BACKUP
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...
ORA-19815: WARNING: db_recovery_file_dest_size of bytes is used
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...
RMAN-08137: WARNING: archived log not deleted, needed for standby
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...
Rman backup of archives between two sequences
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...
ORA-19809: limit exceeded for recovery files
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...
ORA-65500: could not modify DB_UNIQUE_NAME while duplicating db
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...