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...
backup
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...
ORA-00245: control file backup failed; target is likely on a local file system
PROBLEM: While taking RMAN backup in oracle RAC database, getting below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK F...
monitor rman backup progress
Use the below query to monitor the currently running rman backup status. SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE" FROM V$SESSION_LONGOPS WHERE OPNAME L...