Balasubramanian oracle dba blog: ORACLE 11203 RMAN Active Database Cloning without Source Backup

11203 RMAN Active Database Cloning without Source Backup:

Source database will be in Mount Stage (No ArchiveLog Mode) è SRCDB

Target Database will be In NoMount Stage while Active cloning: è DUPB

Time Taken: 12mins for 180GB (Same Server with ASM DiskGroup)

Steps Overview:

Step1: Source DB = Mount (NO ARCHIVE LOG)

Setp2: Target DB - Nomount (Auxiliary)

Step3: RMAN -

run {

ALLOCATE CHANNEL d1 TYPE DISK ;

ALLOCATE CHANNEL d2 TYPE DISK ;

ALLOCATE CHANNEL d3 TYPE DISK ;

ALLOCATE AUXILIARY CHANNEL a1 TYPE DISK ;

ALLOCATE AUXILIARY CHANNEL a2 TYPE DISK ;

ALLOCATE AUXILIARY CHANNEL a3 TYPE DISK ;

duplicate target database to DUPDB from active database;

}

Step 4: Copy the wallet encryption file from source db to target db (if you having Wallet encryption in your database)

Step5: start the db in mount stage (after cloning)

step6: open the wallet

step7: Alter database open;

Generating Pfile from Cloning Duplicate Database:

[oracle@MyServer ~]$ echo $ORACLE_SID

SRCDB

[oracle@MyServer ~]$ sqlplus '/as sysdba'

SQL> create pfile='/localfs/export/SRCDB/initSRCDB.ora' from spfile;

File created.

SQL> exit

Edit your PFILE:

[oracle@MyServer SRCDB]$ cp initSRCDB.ora initDUPDB.ora

[oracle@MyServer SRCDB]$ vi initDUPDB.ora

*.audit_file_dest='/localfs/orasrc/admin/DUPDB/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

#*.control_files='/localfs/oradata/DUPDB/control01.ctl','/localfs/oradata/DUPDB/control02.ctl'

*.db_block_size=8192

*.db_domain='MYDOMAIN.ORG'

*.db_name='DUPDB'

*.diagnostic_dest='/localfs/orasrc'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=DUPDBXDB)'

*.open_cursors=300

*.pga_aggregate_target=235929600

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=707788800

*.undo_tablespace='UNDOTBS1'

db_file_name_convert='/localfs/oradata/SRCDB/','/localfs/oradata/DUPDB/'

log_file_name_convert='/localfs/oradata/SRCDB/','/localfs/oradata/DUPDB/'

Copy your Soruce Password file

[oracle@MyServer SRCDB]$ cd $ORACLE_HOME/dbs

[oracle@MyServer dbs]$ cp orapwSRCDB orapwDUPDB

[oracle@MyServer dbs]$ cd -

/localfs/export/SRCDB

Creating Spfile:

[oracle@MyServer SRCDB]$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.2.0 Production on Tue Feb 19 04:14:33 2013

Connected to an idle instance.

SQL> create spfile from pfile='/localfs/export/SRCDB/initDUPDB.ora';

File created.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 705662976 bytes

Fixed Size 2229840 bytes

Variable Size 201329072 bytes

Database Buffers 494927872 bytes

Redo Buffers 7176192 bytes

SQL> exit

Source Database Mount:

[oracle@MyServer admin]$ echo $ORACLE_SID

SRCDB

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 705662976 bytes

Fixed Size 2229840 bytes

Variable Size 201329072 bytes

Database Buffers 494927872 bytes

Redo Buffers 7176192 bytes

Database mounted.

SQL> exit

My Listener Entries:

LSNR_DUPDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MyServer.MYDOMAIN.ORG)(PORT = 1522))
)

SID_LIST_LSNR_DUPDB =
(SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = DUPDB.MYDOMAIN.ORG)
      (ORACLE_HOME = /localfs/orasrc/product/db/11.2.0.2)
      (SID_NAME = DUPDB)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = SRCDB.MYDOMAIN.ORG)
      (ORACLE_HOME = /localfs/orasrc/product/db/11.2.0.2)
      (SID_NAME = SRCDB)
    )
)

[oracle@MyServer admin]$ ps -ef | grep tns
oracle 28013 1 0 04:36 ? 00:00:00 /localfs/orasrc/product/db/11.2.0.2/bin/tnslsnr LSNR_DUPDB -inherit

Note: NoMount Stage Database required the Seperate Listener to avoid the below error while cloning the database using RMAN Auxiliary connection

ORA-12528: TNS:listener: all appropriate instances are blocking new connections

My TnsName Entry:

SRCDB.MYDOMAIN.ORG =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = MyServer.MYDOMAIN.ORG)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = SRCDB.MYDOMAIN.org)
    )
)

DUPDB.MYDOMAIN.ORG =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = MyServer.MYDOMAIN.ORG)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DUPDB.MYDOMAIN.org)
    )
)

=============================================================================

RMAN Execution:

[oracle@MyServer SRCDB]$ rman

Recovery Manager: Release 11.2.0.2.0 - Production on Tue Feb 19 04:40:54 2013

RMAN> connect auxiliary sys/PassWd@DUPDB

connected to auxiliary database: DUPDB (not mounted)

RMAN> connect target sys/PassWd@SRCDB

connected to target database: SRCDB (DBID=523443299, not open)

RMAN> run
2> {
3> ALLOCATE CHANNEL d1 TYPE DISK ;
ALLOCATE CHANNEL d2 TYPE DISK ;
4> 5> ALLOCATE CHANNEL d3 TYPE DISK ;
6> ALLOCATE AUXILIARY CHANNEL a1 TYPE DISK ;
7> ALLOCATE AUXILIARY CHANNEL a2 TYPE DISK ;
8> ALLOCATE AUXILIARY CHANNEL a3 TYPE DISK ;
9> duplicate target database to DUPDB from active database;
10> }

using target database control file instead of recovery catalog
allocated channel: d1
channel d1: SID=63 device type=DISK

allocated channel: d2
channel d2: SID=129 device type=DISK

allocated channel: d3
channel d3: SID=191 device type=DISK

allocated channel: a1
channel a1: SID=63 device type=DISK

allocated channel: a2
channel a2: SID=129 device type=DISK

allocated channel: a3
channel a3: SID=192 device type=DISK

Starting Duplicate Db at 19-FEB-13

contents of Memory Script:
{
   sql clone "alter system set db_name =
''SRCDB'' comment=
''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set db_unique_name =
''DUPDB'' comment=
''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   backup as copy current controlfile auxiliary format '/localfs/orasrc/product/db/11.2.0.2/dbs/cntrlDUPDB.dbf';
   alter clone database mount;
}
executing Memory Script
......

......

contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 19-FEB-13
released channel: d1
released channel: d2
released channel: d3
released channel: a1
released channel: a2
released channel: a3

RMAN> exit

Recovery Manager complete.
[oracle@MyServer SRCDB]$

=============================================================================

[oracle@MyServer ~]$ export ORACLE_SID=DUPDB
[oracle@MyServer ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.2.0 Production on Tue Feb 19 04:45:02 2013

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select open_mode from v$database;

OPEN_MODE
------------------------------------------------------------
READ WRITE

======================================================================

Thursday, 28 November 2013

ORACLE 11203 RMAN Active Database Cloning without Source Backup

No comments:

Post a Comment