Karan Rajpoot Oracle DBA Blog's

Introduction: RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, a remote server will a different file structure or the local server with a different file structure.  In this demonstration , I am using the "prod" as a Source database and "clone" as an Auxiliary database. Prerequisites: RMAN must be connected as AUXILIARY to the instance of the duplicate database. The instance of the duplicate database is called the auxiliary instance. The auxiliary instance must be started with the NOMOUNT option. High-Level steps of  RMAN backup based cloning in Oracle 11g Source Server: - 1) The database should be in Archive log mode. 2) Set the recovery parameters. 3) Set the datafile and logfile convert parameter. 4) Create Parameter file (pfile). 5) Take a fresh backup. 6) Create Password fi

In my case, I am using below databases for cloning purpose Source Database : - prod Target Database : - karan Step 1) Set the environment through a source server. Example: -  [oracle@prod ~]$ . oraenv ORACLE_SID = [oracle] ? prod The Oracle base has been set to /u01/app/oracle Step 2) Login through sqlplus and start the database, make sure you start your database using spfile. Example: - [oracle@prod ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Fri Jan 18 20:53:01 2019 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area  839282688 bytes Fixed Size     2257880 bytes Variable Size   545262632 bytes Database Buffers   289406976 bytes Redo Buffers     2355200 bytes Database mounted. Database opened. Step 3) Make sure your database should in archive mode. Example: - SQL> archive log