DB Clone using Grid Control

In this post I would demonstrate how to clone an Oracle Database using GRID CONTROL. The steps are pretty straight forward, however I am posting it just for the sake of familiarity - Most of the DBAs prefer to do clone the database manually (either using rman, or manual OS level copy). When cloning through grid - The agent runs the following script: $AGENT_HOME/sysman/admin/scripts/db/dbclone/db_clone.pl


1. Login to Grid Control














2. Follow the navigation "TARGETS" => DATABASES=> Click on the Source Database (ie EBSPRD in this example)

3. The working directory Location is where the source database backup files would be placed. You can choose to delete or retain the backup after the clone.

4. Since the source database is not in archive log mode, It prompts you if the database should be put in archive log mode or not? (If not, It would take the cold backup of the source).















5. The below screen shows the database file locations, by default the database files are stored in one of the directories in the $ORACLE_HOME, we don't want that..To change it hit the "Customize" button.















6. Specify the location where you want the files to be on the target.





























7. Give an appropriate Description of the Job. If you want to schedule the clone later, you can do that as well.





























8. You can monitor the status of the job by clicking on the "Jobs" tab on the top right hand side.

































9. Incase you want to see more details of the job, just click on it.

























10. Once the job completes successfully, the database is also registered in the grid control.