backup

Real Interview questions for experienced DBAs – 1

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...

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...