Steps to create RMAN Active duplicate in
11gR2
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.
The article
assumes the active duplicate database is being created on a separate server. In
this test case the target database is PROD and duplicate database will be TEST.
Preparation
of PROD database
- Create
password file on PROD and scp to TEST DB ($ORACLE_HOME/dbs location)
orapwd file=$ORACLE_HOME/dbs/orapwTEST
password=password entries=10
scp password file to TEST server ($ORACLE_HOME/dbs location)
- Make
proper entries in tnsnames.ora in both PROD and TEST database
Sample
entry as below mention:-
#
Generated by Oracle configuration tools.
PROD
=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =
dev1.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PROD) (UR=A)
)
)
TEST
=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =
dev2.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST)(UR=A)
)
)
Preparation
of TEST database.
- Create
pfile (ORACLE_HOME/dbs/initTEST.ora)
*.DB_NAME=TEST
*.DB_UNIQUE_NAME=TEST
*.diagnostic_dest='/u01/app/oracle'
*.db_block_size=8192
*.Memory_TARGET=843055104
*.COMPATIBLE= 11.2.0.0.0
*.local_listener='(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dev2.localdomain.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TEST)(UR=A)))'
*.log_file_name_convert='/u01/app/oracle/oradata/ora11g/','/u01/app/oracle/oradata/TEST/','/u01/app/oracle/oradata/PROD/','/u01/app/oracle/oradata/TEST/'
*.db_file_name_convert='/u01/app/oracle/oradata/ora11g/','/u01/app/oracle/oradata/TEST/','/u01/app/oracle/oradata/PROD/','/u01/app/oracle/oradata/TEST/'
- Make
proper entries in tnsnames.ora and listener.ora
Sample
entry is as below mention
cat
tnsnames.ora
#
Generated by Oracle configuration tools.
PROD
=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =
dev1.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PROD) (UR=A)
)
)
TEST
=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =
dev2.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST)(UR=A)
)
)
cat listener.ora
INBOUND_CONNECT_TIMEOUT_LISTENER
= 0
TEST
=
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
dev2.localdomain.com)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY =
EXTPROC))
)
)
)
SID_LIST_TEST
=
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME =
/u01/app/oracle/product/11.3.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = TEST)
(ORACLE_HOME =
/u01/app/oracle/product/11.3.0)
(SID_NAME = TEST)
)
)
ADR_BASE_REPL
= /u01/app/oracle
- Make
proper directory structure on TEST DB for Datafile and logfile
- Test
connection from both database (PROD/TEST). We should be able to connect sqlplus
from both PROD and TEST database.
sqlplus
sys/Welcome123@PROD as sysdba
sqlplus
sys/Welcome123@TEST as sysdba
- Start
TEST database in nomount
export
ORACLE_HOME= /u01/app/oracle/product/11.3.0
export
ORACLE_SID=TEST
export
PATH=$ORACLE_HOME/bin:$PATH
sqlplus
>startup nomount pfile=’$ORACLE_HOME/dbs/initTEST.ora’
rman
target sys/Welcome123@PROD
connect
auxiliary sys/Welcome123@TEST
[oracle@dev2
dbs]$ rman target sys/Welcome123@PROD
Recovery
Manager: Release 11.2.0.3.0 - Production on Sat Apr 5 11:45:02 2014
Copyright
(c) 1982, 2011, Oracle and/or its affiliates.
All rights reserved.
connected
to target database: PROD (DBID=255635113)
RMAN>
connect auxiliary sys/Welcome123@TEST
connected
to auxiliary database: TEST (not mounted)
RMAN>
DUPLICATE
TARGET DATABASE TO "TEST" FROM ACTIVE DATABASE;
SQL>
select name from v$database;
NAME
---------
TEST
Sqlplus
> create pfile from spfile;
Your
TEST database is ready now.
