• Arun Kumar

RMAN Cloning Via RMAN DUPLICATE

In this article we will look at RMAN cloning using RMAN DUPLICATE command.

  • Primary Database: PRODDB

  • Clone Database: CLONE1

Take RMAN Backup


Connect PRODDB via RMAN and take database backup

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;


Create Clone Parameter File


Create Parameter file for CLONE1 database

  • SQL> create pfile=’$ORACLE_HOME/dbs/initclone1.ora’ from spfile;

Edit Parameter file as per CLONE1 database

db_file_name_convert='/u01/app/oracle/oradata/proddb','/u01/app/oracle/oradata/clone1'
log_file_name_convert='/u01/app/oracle/oradata/proddb','/u01/app/oracle/oradata/clone1'


Create Clone Password File


Create password file for CLONE1 database:

ORAPWD FILE=$ORACLE_HOME/dbs/orapwclone1 PASSWORD=sys ENTRIES=5

Copy CLONE1 pfile to CLONE1 server and create directories as per the pfile contents.


Also copy the password file to CLONE1 server.

  • Configure Listener & TNS for both databases

  • Take clone1 db to nomount stage


Run RMAN DUPLICATE

  • Connect PRODDB & AUXILARY (clone1) VIA RMAN AND FIRE:

rman target sys/sys auxiliary sys/sys@clone1
Duplicate target database to 'clone1' nofilenamecheck;


Recent Posts

See All

Perform Manual Switchover on Physical Standby

Connect to proddb database via client: Take a new putty session and connect to proddb database via client machine. Keep querying below sqlplus sys/sys@proddb as sysdba SQL> select name, open_mode, db

How to check database backups

Checking Database backups are one of the main focus areas of a DBA. Time to time, DBA needs to check database backup status and see if its completed, failed, running etc. Also, DBA must be able to get

Automate RMAN Backups using Shell Scripts

In a real environment, off course you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. In this article we will look at RMAN backup au

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback