Quick reference: Duplicating database using RMAN

Written by Kokei's Blog
Posted Apr 10, 2008 at 1:28 AM

1. Pre-requisites
i) Full backup of the source database
ii) Source database must be in open or mount mode
iii) Set the following environment variables
NLS_DATE_FORMAT='DD-MM-YYYY HH24:MI:SS'; export NLS_DATE_FORMAT
NLS_LANG='AMERICAN_AMERICA.WE8ISO8859P1'; export NLS_LANG
iv) Create the directories for datafiles, archivelog, dumps

2. Preparing the initialization file for the duplicate instance
i)Copy the initialization file( i.e. init .ora) to the duplicate host

ii)Edit the following parameters
db_name
instance_name
control_files
background_dump_dest
core_dump_dest
user_dump_dest
log_archive_dest_1
db_file_name_convert=SrcSID,DestSID
db_file_name_convert=SrcSID,DestSID
remote_login_passwordfile=exclusive

3. Start the duplicate database

i)set ORACLE_HOME and ORACLE_SID

ii)create a password file

%orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=kernel

iii)start the duplicate instance in nomount state

SQL> startup nomount pfile=''

4. Start the duplication at the duplicate host

rman
connect auxiliary /
connect target sys/password@source_db

CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/ /%d_%T_%t_%s.bkp';

run{
set until time '12-01-1999 11:20:00'
duplicate target database to DUP;
}

References
Metalink Doc ID 73912.1

These icons link to social bookmarking sites where readers can share and discover new web pages.