ORACLE 11G :ACTIVE DATABASE DUPLICATION-RMAN

ORACLE 11G :ACTIVE DATABASE DUPLICATION-RMAN

Oracle 11g introduced active database duplication using which we can create a duplicate database of the target database without any backups. Duplication is performed over the network.

Procedure :

Overview:

on the source  host

- Create Pfile from source database
- Create an entry in tnsnames.ora for duplictae database on target host on port 1522

on the target host
- Add a line in the file /etc/oratab to reflect the database instance you are going to copy
- create folders
- Copy the initialization parameter file from the source database add edit it.
- Copy the password file
- Create a listener in database home on port 1522 and register duplicate database statically with it
- Startup the target database in nomount mode using modified parameter file
- Using RMAN  connect to the source database(orcl) as target database and duplicate database (orclt) as auxiliary instance
- duplicate the target database

********************************
  source database  orcl
  Duplicate database  orclt
***********************************

Implementation

– On source host

– CREATE PFILE FROM SOURCE DATABASE

SQL>CREATE PFILE=’/u01/app/oracle/oradata/orcl/initsource.ora’     FROM SPFILE;

– On source database, create a service for orclt on target host on port 1522

The rest of the steps occur on the target host.

– Add a line in the file /etc/oratab to reflect the database instance you are going to copy
     orclt:/u01/app/oracle/product/11.2.0/db1:N

– Now set the Oracle SID as the duplicated database SID:
# . oraenv
ORACLE_SID = [orclt] ?

– create folders

 $mkdir -p /u01/app/oracle/oradata/orclt
  mkdir -p /u01/app/oracle/flash_recovery_area/orclt
  mkdir -p /u01/app/oracle/admin/orclt/adump
  mkdir -p /u01/app/oracle/admin/orclt/dpdump

– Copy the initialization parameter file from the main database.
$cp  /u01/app/oracle/oradata/orcl/initsource.ora /u01/app/oracle/oradata/orclt/inittarget.ora

– Edit the initialization parameter file
$vi /u01/app/oracle/oradata/orclt/inittarget.ora

   – Change db_name = orclt
   – Edit it to reflect the new locations that might be appropriate
     such as control file locations,audit dump destinations, datafile
     locations, etc.
   – add these lines –
     db_file_name_convert = (“/u01/app/oracle/oradata/orcl”,
                             “/u01/app/oracle/oradata/orclt”)
     log_file_name_convert = (“/u01/app/oracle/oradata/orcl”,
                             “/u01/app/oracle/oradata/orclt”)

In case source and destination databases ae ASM, following lines can be added :

db_file_name_convert = (“+DATA/orcl”,”+DATA/orclt”)
log_file_name_convert = (“+DATA/orcl”,”+DATA/orclt”, “+FRA/orcl”,”+FRA/orclt”)

– Copy the password file as well
$cp /u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl  /u01/app/oracle/product/11.2.0/db_1/dbs/orapworclt

– Startup the target database in nomount mode using modified parameter file
$ . oraenv
ORACLE_SID = [orclt] ?
$sqlplus sys/oracle as sysdba

SQL> startup nomount pfile=’/u01/app/oracle/oradata/orclt/inittarget.ora';
     create spfile from pfile=’/u01/app/oracle/oradata/orclt/inittarget.ora';

– create a listener on port 1522 in database home on target host and statically register service
    orclt with it.

– connect to the auxiliary instance

$. oraenv
   orclt
$rman target sys/oracle@orcl auxiliary sys/oracle@orclt

– duplicate the database orcl to orclt from active database
– the command performs the following steps:
    * Creates an SPFILE
    * Shuts down the instance and restarts it with the new spfile
    * Restores the controlfile from the backup
    * Mounts the database
    * Performs restore of the datafiles. In this stage it creates the files in the
      converted names.
    * Recovers the datafiles up to the time specified and opens the database

RMAN>duplicate target database to orclt from active database;

– check that duplicate database is up
$sqlplus / as sysdba

sql>conn hr/hr
    select * from tab;

-- Note that  DBID is different from the main database so it can be backed up
   independently and using the same catalog as well.

SQL> select dbid from v$database;
      DBID
———-
3779357884

     conn sys/oracle@orcl as sysdba
   
     select dbid from v$database;
      DBID
———-
1326904854