Steps to clone a database through RMAN using standby database.

Please follow the below for database clone through RMAN using standby database.

1)  Step 1:
——————-

a) Cancel the recovery in CTL DR on dbprod01.
b) Open the database in read only mode. – alter database open read only;
c) start the below listener on CTL DR. – LISTENER_DD_RESTORE (Create one for this)

2) Step 2  :
————–

a) connect BTLP database and do the below (This database has to be recreated again)

shutdown immediate;
startup nomount;
alter database mount exclusive;
alter system enable restricted session;
drop database;

b) startup nomount pfile=’/orahome/app/oracle/product/11204/BTLP/dbs/initBTL.ora’ ( Please check db_file_name_convert and log_file_name_convert are perfectly edited)

c) Create and Start the listener – LISTENER_BTLP_CLONE

d)

rman target sys/pwd@CTL_DD_RESTORE auxiliary sys/pwd@BTLP_CLONE 
run 
{
ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
ALLOCATE CHANNEL c2 DEVICE TYPE DISK;
ALLOCATE CHANNEL c3 DEVICE TYPE DISK;
ALLOCATE CHANNEL c4 DEVICE TYPE DISK;
ALLOCATE CHANNEL c5 DEVICE TYPE DISK;
ALLOCATE CHANNEL c6 DEVICE TYPE DISK;
ALLOCATE CHANNEL c7 DEVICE TYPE DISK;
allocate auxiliary channel c8 device type disk ;  
allocate auxiliary channel c9 device type disk ; 
allocate auxiliary channel c10 device type disk ; 
duplicate target database to BTLP from active database nofilenamecheck;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
release channel c6;
release channel c7;
release channel c8;
release channel c9;
release channel c10;
}

e) shut down the db and open it

f) create spfile.
shut the database and open it in spfile.

g)

shutdown immediate;
startup mount;
alter database noarchivelog;
alter database open;
h) stop the listener – LISTENER_BTLP_CLONE

Step 3
_______

a) Shut down the DR
b) startup mount
c) ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION; 

d) stop the listener – LISTENER_DD_RESTORE

Thats it.

  • March 12, 2019 | 21 views
  • Comments