RMAN cloning

2009-05-25T11:18:00.000-07:00

Duplicate a Database Using RMAN
A nice feature of RMAN is the ability to duplicate, or clone, a database from a previous backup. 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 article I'll demonstrate the last method, how to duplicate a database on the local server with a different file structure. This can prove useful when you want to recover selected objects from a backup, rather than roll back a whole database or tablespace.

Frist create a target database with archivelog mode
SQL> create tablespace ts1 datafile '/disk1/oracle/app/oradata/orcl/data1.dbf' size 200m;

Tablespace created.

Create one user with sysdba privilage
SQL> create user reco identified by reco default tablespace ts1;

User created.

SQL> grant sysdba,connect,create session,resource to reco;

Grant succeeded.

Second create a catalog database

SQL> create tablespace tbs1 datafile '/disk1/oracle/app/oradata/catalog/data1.dbf' size 200m;

Tablespace created.

Create one user with recovery_catalog_database privilage

SQL> create user cache identified by cache default tablespace tbs1;

User created.

SQL> grant recovery_catalog_owner,connect,create session,resource to cache;

Grant succeeded.

Create listner with target and catalog database

$netca

Configure RMAN

$Rman target=usernmae/password@target catalog=username/password@catalog

RMAN>create catalog

RMAN>register database

RMAN>backup database

RMAN>exit

we must create a password file for the duplicate instance:
$orapwd file=/disk1/oracle/app/10g/dbs/orapwDUP password=password entries=10

Next add the appropriate entries into the tnsnames.ora and listener.ora files in the $ORACLE_HOME/network/admin directory. Remember to load the new configuration into the listener:

# Added to the listener.ora SID_LIST
(SID_DESC =
(ORACLE_HOME = disk1/oracle/app/10g/)
(SID_NAME = DUP)
)

# Added to the tnsnames.ora
DUP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1.tshcomputing.com)(PORT = 1521))
)
(CONNECT_DATA =
(ORACLE_SID = DUP)
)
)

# Reload listener
lsnrctl >reload

Next create an init.ora file for the duplicate database. Since we are duplicating the database onto the same server as the original we must convert the file names so there is no conflict:

Vi Initdup.ora
# Minimum Requirement.
DB_NAME=DUP
CONTROL_FILES /disk1/oracle/app/oradata/dub//control01.ctl,
/disk1/oracle/app/oradata/dub/control02.ctl,
/disk1/oracle/app/oradata/dub/control03.ctl)

# Convert file names to allow for different directory structure.
DB_FILE_NAME_CONVERT=(/u02/oradata/TSH1/,/u02/oradata/DUP/)
LOG_FILE_NAME_CONVERT=(/u01/oradata/TSH1/,/u01/oradata/DUP/)

# make sure block_size and compatible parameters
# match if you are not using the default.
DB_BLOCK_SIZE=8192
COMPATIBLE= 10.2.0.1.0

Next we connect to the duplicate instance:
ORACLE_SID=DUP; export ORACLE_SID

sqlplus /nolog
SQL>conn / as sysdba

Next we create an SPFILE based on the init.ora:
SQL>CREATE SPFILE FROM PFILE='/u01/app/oracle/admin/DUP/pfile/init.ora';

Next we start the database in NOMOUNT mode:
SQL>STARTUP FORCE NOMOUNT;
With the duplicate database started we can now connect to it from RMAN. For the duplication to work we must connect to the original database (TARGET), the recovery catalog (CATALOG) and our duplicate database (AUXILIARY):

ORACLE_SID=DUP; export ORACLE_SID
$rman TARGET sys/password@tsh1 CATALOG rman/rman@tshadm AUXILIARY /

We can then dupicate the database using one of the following commands:
# Duplicate database to TARGET's current state.
RMAN>DUPLICATE TARGET DATABASE TO DUP;

Or

# Duplicate database to TARGET's state 4 days ago.
RMAN>DUPLICATE TARGET DATABASE TO DUP UNTIL TIME 'SYSDATE-4';

run {
# Allocate the channel for the duplicate work
allocate auxiliary channel ch1 type disk;

# Duplicate the database to TESTDB
duplicate target database to TESTDB;
}

using target database controlfile instead of recovery catalog
allocated channel: ch1
channel ch1: sid=13 devtype=DISK
Starting Duplicate Db at 03-NOV-04

printing stored script: Memory Script
{
set until scn 14757706;
set newname for datafile 1 to "/u06/app/oradata/TESTDB/system01.dbf";
set newname for datafile 2 to "/u06/app/oradata/TESTDB/undotbs1_01.dbf";
set newname for datafile 3 to "/u06/app/oradata/TESTDB/cwmlite01.dbf";
set newname for datafile 4 to "/u06/app/oradata/TESTDB/drsys01.dbf";
set newname for datafile 5 to "/u06/app/oradata/TESTDB/indx01.dbf";
set newname for datafile 6 to "/u06/app/oradata/TESTDB/odm01.dbf";
set newname for datafile 7 to "/u06/app/oradata/TESTDB/tools01.dbf";
set newname for datafile 8 to "/u06/app/oradata/TESTDB/users01.dbf";
set newname for datafile 9 to "/u06/app/oradata/TESTDB/xdb01.dbf";
set newname for datafile 10 to "/u06/app/oradata/TESTDB/example01.dbf";
set newname for datafile 11 to "/u06/app/oradata/TESTDB/perfstat01.dbf";
set newname for datafile 12 to "/u06/app/oradata/TESTDB/users02.dbf";
restore
check readonly
clone database ; }

Vivek Raghavan M

RMAN cloning