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...
cloning
How to clone oracle home in oracle 19c using gold image
In this article, we will explain , how to clone 19c oracle home binary (including patches) , from one server to another server using gold image method. Prior to oracle 19c, cloning was done using runI...
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...
Database cloning using hot backup
In this article We will explain the steps for cloning a database using hot backup method without using RMAN utility. During hot backup, the source database will be up and running. NOTE – SOURCE ...
Database cloning using cold backup
Cold database backup means while taking backup or doing cloning, we need to shutdown the source database. This method is usually used for test database when database is in noarchivelog mode. Note- Bot...