Following are the steps of Creating a Standby or a Clone Database using Rman Duplicate From Active Database for 11.2.0.2 database.
The following are the steps to create a standby or a clone of oracle database using RMAN,
1) Create a parameter file for the clone or standby
2) Add the following three parameters to the standby or clone database parameter file, even if the paths are identical on both the source and standby or clone servers:
*._compression_compatibility='11.2.0'
*.db_file_name_convert=('target path','auxilary path'....)
*.log_file_name_convert=('target path','auxilary path'....)
3) Copy the passwordfile from the source database to the clone or standby Oracle_Home/database for windows folder or $Oracle_Home/dbs for Linux.
4) Configure the network on the clone or standby server so that you can connect to the database
5) Startup nomount the clone or standby database
6) Add a tnsnames.ora entry to the clone or standby on your source database server
7) Check that you can connect to the clone or standby database as sysdba
8) On the Primary server connect to the source database and clone or standby database (auxiliary) using RMAN
D:\> RMAN TARGET / AUXILIARY sys/password@prodclon
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Nov 2 9:02:41 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (DBID=7119395273)
Connected to auxiliary database: PRODCLON (not mounted)
9) Use the following syntax to duplicate to a clone (use as many channels as CPU’s you may dedicate):
run
{
allocate channel c1 type disk;
allocate auxiliary channel cr1 type disk;
duplicate target database to 'prodclon' from active database nofilenamecheck;
}
10) Use the following syntax to duplicate for standby (use as many channels as CPU’s you may dedicate):
run
{
allocate channel c1 type disk;
allocate auxiliary channel cr1 type disk;
duplicate target database for standby from active database nofilenamecheck;
}
If you have any questions regarding the above steps then please don't hesitate to email me samiora@gmail.com
