TEST
Powered by Blogger.
Responsive Ad
Responsive Ad

Author Profile

About Me

Start Sharing

Start Sharing

Drive Traffic on Social Platforms

Blog Archive

Blog Journey

Blog Journey

Learn how to start a perfect Blog

Work Smart, Not Hard - Let's See

Make your Blogging experience faster and easiest …
Work Smart, Not Hard - Let's See
Design by - Blogger Templates | Distributed by Free Blogger Templates

Made with Love by

Material UI Template is Designed Theme for Giving Enhanced look Various Features are available Whic…

Random Posts

Ads Section

HOME > > Database Cloning to Different Host through RMAN

Database Cloning to Different Host through RMAN

Anup - Wednesday, 8 June 2011
Assumed Source database names:
Host: SUN1
Primary Database SID: PROD
Data file mount Point: /DB/PROD

Assuming Target Database:

Host: SUN2
Primary Database SID: CLONE
Data file mount Point: /DB/CLONE

Steps 1 Create init file for Clone instance

Set init parameter in init file.

DB_NAME=PROD to DB_NAME=CLONE
DB_FILE_NAME_CONVERT <----if using different mount point for database------->
LOG_FILE_NAME_CONVERT <----if using different mount point for database------>

Step 2 create Mount point for RMAN Backup set and Restore RMAN backup on Target Server

Note: RMAN backup set mount point must be same.

Step 3 Startup Clone Instance with Nomount option

Export ORACLE_SID=CLONE
Sqlplus /nolog
Conn / as sysdba
Startup nomount

Step 4 invoke RMAN

$ rman target sys/anup123@prod auxiliary /

Step 5 Execute bellow mention command on Rmount MAN prompt.

If database using same mount point:
RMAN> duplicate target database to “CLONE” nofilenamecheck;

If database using different mount point:

RMAN> duplicate target database to “CLONE” nofilenamecheck;

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me