Example With Video & Step By Step
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$&&&&&&&&&&&&&&&&&&&
##Clone A Database with RMAN Backup Base Without Source connectivity:##
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$&&&&&&&&&&&&&&&&&&&
Primary Database Information
************************************
Host : source.localdomain (192.168.56.101)
DB_NAME : prod
File-System : /disk01, /FRA
Clone Database Information
***********************************
Host : target.localdomain (192.168.56.102)
DB_NAME : consol
File-System : /disk02, /FRA
=====================================================
Basic pre-check before deploying Active Clone database server.
------------------------------------------------------------------------------------------
(i) Primary Server, Instance, Databases details.
*********************************************************
NAME INSTANCE_NAME HOST_NAME DATABASE_ROLE LOG_MODE LOGINS OPEN_MODE STARTUP_TIME VERSION
--------- ---------------- -------------------- -------------------- --------------- ---------- --------------- -------------------- -----------
PROD prod source.localdomain PRIMARY ARCHIVELOG ALLOWED READ WRITE 2017:07:28 12:06:31 11.2.0.4.0
(ii) Archive log Should be enable & Flash Recovery Area Details.
*******************************************************************************
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 10
Next log sequence to archive 12
Current log sequence 12
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- -----------
db_recovery_file_dest string /FRA/prod
db_recovery_file_dest_size big integer 4182M
recovery_parallelism integer 0
(iii) File-System Details of Primary Side.
***********************************************
[oracle@source /]$ df -h /disk01
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_source-lv_root
86G 13G 69G 16% /
[oracle@source ~]$ df -h /FRA
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_source-lv_root
86G 13G 69G 16% /
(iv) check whether Source server pinging to Target Server.
***********************************************************************
[oracle@source ~]$ ping 192.168.56.102
PING 192.168.56.102 (192.168.56.102) 56(84) bytes of data.
64 bytes from 192.168.56.102: icmp_seq=1 ttl=64 time=0.294 ms
64 bytes from 192.168.56.102: icmp_seq=2 ttl=64 time=0.502 ms
64 bytes from 192.168.56.102: icmp_seq=3 ttl=64 time=0.502 ms
64 bytes from 192.168.56.102: icmp_seq=4 ttl=64 time=0.577 ms
^C
--- 192.168.56.102 ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3089ms
rtt min/avg/max/mdev = 0.294/0.468/0.577/0.108 ms
(v) check whether Target server pinging to Source Server.
**********************************************************************
[oracle@target ~]$ ping 192.168.56.101
PING 192.168.56.101 (192.168.56.101) 56(84) bytes of data.
64 bytes from 192.168.56.101: icmp_seq=1 ttl=64 time=0.148 ms
64 bytes from 192.168.56.101: icmp_seq=2 ttl=64 time=0.298 ms
64 bytes from 192.168.56.101: icmp_seq=3 ttl=64 time=0.719 ms
64 bytes from 192.168.56.101: icmp_seq=4 ttl=64 time=0.294 ms
^C
--- 192.168.56.101 ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3349ms
rtt min/avg/max/mdev = 0.148/0.364/0.719/0.214 ms
(vi) File-System Details of Target Side.
***********************************************
[oracle@target ~]$ df -h /disk02
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_target-lv_root
86G 14G 68G 17% /
[oracle@target ~]$ df -h /FRA
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_target-lv_root
86G 14G 68G 17% /
$$$$$$$$$$$$$$$$$$$$$$$$$$$
##Activity On Source Site##
$$$$$$$$$$$$$$$$$$$$$$$$$$$
Step: 1
================================================================
Go to the dbs location & tranfer password file to target site ( @Source Site).
--------------------------------------------------------------------------------------------------------------
[oracle@source ~]$ cd $ORACLE_HOME/dbs
[oracle@source dbs]$ ls -lrth
total 20K
-rw-r--r--. 1 oracle oinstall 2.8K May 15 2009 init.ora
-rw-r-----. 1 oracle oinstall 24 Jul 26 12:46 lkPROD
-rw-r-----. 1 oracle oinstall 1.5K Jul 26 12:48 orapwprod
-rw-rw----. 1 oracle oinstall 1.6K Jul 26 13:21 hc_prod.dat
-rw-r-----. 1 oracle oinstall 2.5K Jul 26 13:22 spfileprod.ora
[oracle@source dbs]$ scp orapwprod oracle@192.168.56.102:/u01/app/oracle/product/11.2.0/db_1/dbs/
The authenticity of host '192.168.56.102 (192.168.56.102)' can't be established.
RSA key fingerprint is 8b:e1:39:d2:4b:e8:84:16:90:d9:75:02:c2:07:0b:84.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.56.102' (RSA) to the list of known hosts.
oracle@192.168.56.102's password:
orapwprod 100% 1536 1.5KB/s 00:00
Step: 2
=================================================
Just Make Sure Controlfile Autobackp ON ( @Source Site).
------------------------------------------------------------------------------------
[oracle@source PROD]$ . oraenv
ORACLE_SID = [prod] ? prod
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@source PROD]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jul 28 12:12:03 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (DBID=362197903)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name PROD are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_prod.f'; # default
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
Step: 3
==================================================
Now Take the Rman backup with archive log ( @Source Site).
----------------------------------------------------------------------------------------
RMAN> backup database plus archivelog;
Starting backup at 28-JUL-17
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=45 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=4 RECID=1 STAMP=950361724
input archived log thread=1 sequence=5 RECID=2 STAMP=950398484
input archived log thread=1 sequence=6 RECID=3 STAMP=950398527
input archived log thread=1 sequence=7 RECID=4 STAMP=950399268
input archived log thread=1 sequence=8 RECID=5 STAMP=950471472
input archived log thread=1 sequence=9 RECID=6 STAMP=950477242
input archived log thread=1 sequence=10 RECID=7 STAMP=950484637
input archived log thread=1 sequence=11 RECID=8 STAMP=950530005
input archived log thread=1 sequence=12 RECID=9 STAMP=950563617
channel ORA_DISK_1: starting piece 1 at 28-JUL-17
channel ORA_DISK_1: finished piece 1 at 28-JUL-17
piece handle=/FRA/prod/PROD/backupset/2017_07_28/o1_mf_annnn_TAG20170728T212657_dqpqpb66_.bkp tag=TAG20170728T212657 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 28-JUL-17
Starting backup at 28-JUL-17
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/disk01/prod/prod/system01.dbf
input datafile file number=00002 name=/disk01/prod/prod/sysaux01.dbf
input datafile file number=00005 name=/disk01/prod/prod/example01.dbf
input datafile file number=00003 name=/disk01/prod/prod/undotbs01.dbf
input datafile file number=00004 name=/disk01/prod/prod/users01.dbf
channel ORA_DISK_1: starting piece 1 at 28-JUL-17
channel ORA_DISK_1: finished piece 1 at 28-JUL-17
piece handle=/FRA/prod/PROD/backupset/2017_07_28/o1_mf_nnndf_TAG20170728T212713_dqpqpsjb_.bkp tag=TAG20170728T212713 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
Finished backup at 28-JUL-17
Starting backup at 28-JUL-17
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=13 RECID=10 STAMP=950563708
channel ORA_DISK_1: starting piece 1 at 28-JUL-17
channel ORA_DISK_1: finished piece 1 at 28-JUL-17
piece handle=/FRA/prod/PROD/backupset/2017_07_28/o1_mf_annnn_TAG20170728T212828_dqpqs4om_.bkp tag=TAG20170728T212828 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 28-JUL-17
Starting Control File and SPFILE Autobackup at 28-JUL-17
piece handle=/FRA/prod/PROD/autobackup/2017_07_28/o1_mf_s_950563709_dqpqs69q_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 28-JUL-17
Step: 4
============================================
Make some directory on target server ( @Target Site).
-----------------------------------------------------------------------------
[oracle@target ~]$ mkdir -p /disk02/consol
[oracle@target ~]$ mkdir -p /FRA/consol/CONSOL
[oracle@target ~]$ mkdir -p /u01/app/oracle/admin/consol/adump
[oracle@target ~]$ mkdir -p /u01/app/oracle/admin/consol/cdump
Step: 5
==========================================================================================
Go to the Backup location and tranfer the backup with autobackp of controlfile to target server ( @Source Site).
-------------------------------------------------------------------------------------------------------------------------------------------------------------
[oracle@source PROD]$ pwd
/FRA/prod/PROD
[oracle@source PROD]$ scp -r backupset oracle@192.168.56.102:/FRA/consol/CONSOL
oracle@192.168.56.102's password:
o1_mf_annnn_TAG20170728T212828_dqpqs4om_.bkp 100% 11KB 11.0KB/s 00:00
o1_mf_annnn_TAG20170728T212657_dqpqpb66_.bkp 100% 192MB 63.9MB/s 00:03
o1_mf_nnndf_TAG20170728T212713_dqpqpsjb_.bkp 100% 1116MB 53.1MB/s 00:21
[oracle@source PROD]$ scp -r autobackup oracle@192.168.56.102:/FRA/consol/CONSOL
oracle@192.168.56.102's password:
o1_mf_s_950563709_dqpqs69q_.bkp 100% 9600KB 9.4MB/s 00:00
Step: 6
========================================================================================
Rename tranfered password file for clone database's name & create init file for clone startup in nomount. ( @Target Site).
-----------------------------------------------------------------------------------------------------------------------------------------------------------
[oracle@target consol]$ cd $ORACLE_HOME/dbs
[oracle@target dbs]$ ls -lrth
total 24K
-rw-r--r--. 1 oracle oinstall 2.8K May 15 2009 init.ora
-rw-r-----. 1 oracle oinstall 24 Jul 26 12:44 lkDELL
-rw-rw----. 1 oracle oinstall 1.6K Jul 26 12:47 hc_dell.dat
-rw-r-----. 1 oracle oinstall 1.5K Jul 26 12:47 orapwdell
-rw-r-----. 1 oracle oinstall 2.5K Jul 26 12:54 spfiledell.ora
-rw-r-----. 1 oracle oinstall 1.5K Jul 26 13:38 orapwprod
[oracle@target dbs]$ mv orapwprod orapwconsol
[oracle@target dbs]$ ls -lrth
total 24K
-rw-r--r--. 1 oracle oinstall 2.8K May 15 2009 init.ora
-rw-r-----. 1 oracle oinstall 24 Jul 26 12:44 lkDELL
-rw-rw----. 1 oracle oinstall 1.6K Jul 26 12:47 hc_dell.dat
-rw-r-----. 1 oracle oinstall 1.5K Jul 26 12:47 orapwdell
-rw-r-----. 1 oracle oinstall 2.5K Jul 26 12:54 spfiledell.ora
-rw-r-----. 1 oracle oinstall 1.5K Jul 26 13:38 orapwconsol
[oracle@target dbs]$ vi initconsol.ora
DB_NAME='consol'
CONTROL_FILEs='/disk02/consol/control01.ctl'
audit_file_dest=/u01/app/oracle/admin/consol/adump
core_dump_dest=/u01/app/oracle/admin/consol/cdump
db_recovery_file_dest='/FRA/consol'
db_recovery_file_dest_size=4G
DB_FILE_NAME_CONVERT='/disk01/prod/prod','/disk02/consol/'
LOG_FILE_NAME_CONVERT='/disk01/prod/prod','/disk02/consol/','/FRA/prod/PROD','/FRA/consol/CONSOL'
compatible='11.2.0.4.0'
:wq
Step: 7
=========================================================================
Go to the oracle network location & modifiy listener to make static listener ( @Target Site).
----------------------------------------------------------------------------------------------------------------------------------
[oracle@target dbs]$ cd /u01/app/oracle/product/11.2.0/db_1/network/admin/
[oracle@target admin]$ ls -lrth
total 20K
-rw-r--r--. 1 oracle oinstall 381 Dec 17 2012 shrept.lst
drwxr-xr-x. 2 oracle oinstall 4.0K Jul 26 12:34 samples
-rw-r--r--. 1 oracle oinstall 219 Jul 26 12:42 sqlnet.ora
-rw-r--r--. 1 oracle oinstall 379 Jul 26 12:42 listener.ora
-rw-r-----. 1 oracle oinstall 345 Jul 26 12:46 tnsnames.ora
[oracle@target admin]$ vi listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER_CONSOL =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.201)(PORT = 1526))
)
)
SID_LIST_LISTENER_CONSOL =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(SID_NAME = consol)
)
)
ADR_BASE_LISTENER = /u01/app/oracle
:wq
Step: 8
===================================
Just Start created listener ( @Tareget Site).
--------------------------------------------------------------
[oracle@target dbs]$ lsnrctl start LISTENER_CONSOL
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 29-JUL-2017 01:58:44
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/target/listener_consol/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.102)(PORT=1526)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.102)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias LISTENER_CONSOL
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 29-JUL-2017 01:58:45
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/target/listener_consol/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.102)(PORT=1526)))
Services Summary...
Service "consol" has 1 instance(s).
Instance "consol", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Step: 9
==========================================================================================
Go to the oracle network location & modifiy tnsname file entery to ping both static listeners of Source & Tareget( @Tarege Site).
-------------------------------------------------------------------------------------------------------------------------------------------------------------
[oracle@target admin]$ ls -lrth
total 20K
-rw-r--r--. 1 oracle oinstall 381 Dec 17 2012 shrept.lst
drwxr-xr-x. 2 oracle oinstall 4.0K Jul 26 12:34 samples
-rw-r--r--. 1 oracle oinstall 219 Jul 26 12:42 sqlnet.ora
-rw-r-----. 1 oracle oinstall 706 Jul 26 13:54 tnsnames.ora
-rw-r--r--. 1 oracle oinstall 711 Jul 26 13:59 listener.ora
[oracle@target admin]$ vi tnsname.ora
consol =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.102)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = consol)
)
)
Step: 10
========================================================================
Try and check whether both tns enteries are pinging to their static listeners ( @Tarege Site).
--------------------------------------------------------------------------------------------------------------------------
[oracle@target dbs]$ tnsping CONSOL
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 29-JUL-2017 01:59:33
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.102)(PORT = 1526)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = consol)))
OK (40 msec)
[oracle@target dbs]$
Step: 11
====================================================================================
Set the environment on target server for clone database like SID & ORACLE_HOME ( @Target Site).
-----------------------------------------------------------------------------------------------------------------------------------------------
[oracle@target admin]$ . oraenv
ORACLE_SID = [test] ? consol
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/11.2.0/db_1
The Oracle base remains unchanged with value /u01/app/oracle
Step: 12
=========================================================================================
Connect with sqlplus with sysdba & startup instance in "NOMOUNT" state with inittest.ora pfile. ( @Target Site).
--------------------------------------------------------------------------------------------------------------------------------------------------------
[oracle@target dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 26 14:15:18 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> STARTUP NOMOUNT PFILE='/u01/app/oracle/product/11.2.0/db_1/dbs/initconsol.ora'
ORACLE instance started.
Total System Global Area 217157632 bytes
Fixed Size 2251816 bytes
Variable Size 159384536 bytes
Database Buffers 50331648 bytes
Redo Buffers 5189632 bytes
SQL>
Step: 13
======================================================
Open duplicate session and connect with rman ( @Target Site).
--------------------------------------------------------------------------------------------
[oracle@target test]$ rman auxiliary /
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jul 26 23:45:10 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: TEST (not mounted)
Step: 14
===================================================
Run the following script at rman prompt ( @Standby Site).
-------------------------------------------------------------------------------------
RMAN> duplicate database to 'consol' backup location '/FRA/consol/CONSOL/';
Example :
**********
[oracle@target ~]$ rman auxiliary /
Recovery Manager: Release 11.2.0.4.0 - Production on Sat Jul 29 01:31:51 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: CONSOL (not mounted)
RMAN> duplicate database to 'consol' backup location '/FRA/consol/CONSOL';
Starting Duplicate Db at 29-JUL-17
contents of Memory Script:
{
sql clone "create spfile from memory";
}
executing Memory Script
sql statement: create spfile from memory
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 217157632 bytes
Fixed Size 2251816 bytes
Variable Size 159384536 bytes
Database Buffers 50331648 bytes
Redo Buffers 5189632 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''PROD'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''CONSOL'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile from '/FRA/consol/CONSOL/autobackup/2017_07_29/o1_mf_s_950577384_dqq54jc5_.bkp';
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''PROD'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''CONSOL'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 217157632 bytes
Fixed Size 2251816 bytes
Variable Size 159384536 bytes
Database Buffers 50331648 bytes
Redo Buffers 5189632 bytes
Starting restore at 29-JUL-17
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=18 device type=DISK
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/disk02/consol/control01.ctl
Finished restore at 29-JUL-17
database mounted
released channel: ORA_AUX_DISK_1
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=18 device type=DISK
contents of Memory Script:
{
set until scn 1104846;
sql clone 'alter database flashback off';
set newname for datafile 1 to
"/disk02/consol//system01.dbf";
set newname for datafile 2 to
"/disk02/consol//sysaux01.dbf";
set newname for datafile 3 to
"/disk02/consol//undotbs01.dbf";
set newname for datafile 4 to
"/disk02/consol//users01.dbf";
set newname for datafile 5 to
"/disk02/consol//example01.dbf";
restore
clone database
;
}
executing Memory Script
executing command: SET until clause
sql statement: alter database flashback off
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 29-JUL-17
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /disk02/consol//system01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00002 to /disk02/consol//sysaux01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to /disk02/consol//undotbs01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to /disk02/consol//users01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00005 to /disk02/consol//example01.dbf
channel ORA_AUX_DISK_1: reading from backup piece /FRA/consol/CONSOL/backupset/2017_07_29/o1_mf_nnndf_TAG20170729T011537_dqq531r5_.bkp
channel ORA_AUX_DISK_1: piece handle=/FRA/consol/CONSOL/backupset/2017_07_29/o1_mf_nnndf_TAG20170729T011537_dqq531r5_.bkp tag=TAG20170729T011537
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:55
Finished restore at 29-JUL-17
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=6 STAMP=950578440 file name=/disk02/consol/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=7 STAMP=950578440 file name=/disk02/consol/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=8 STAMP=950578440 file name=/disk02/consol/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=9 STAMP=950578440 file name=/disk02/consol/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=10 STAMP=950578440 file name=/disk02/consol/example01.dbf
contents of Memory Script:
{
set until scn 1104846;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 29-JUL-17
using channel ORA_AUX_DISK_1
starting media recovery
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=17
channel ORA_AUX_DISK_1: reading from backup piece /FRA/consol/CONSOL/backupset/2017_07_29/o1_mf_annnn_TAG20170729T011622_dqq54gxx_.bkp
channel ORA_AUX_DISK_1: piece handle=/FRA/consol/CONSOL/backupset/2017_07_29/o1_mf_annnn_TAG20170729T011622_dqq54gxx_.bkp tag=TAG20170729T011622
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/FRA/consol/CONSOL/archivelog/2017_07_29/o1_mf_1_17_dqq65klx_.arc thread=1 sequence=17
channel clone_default: deleting archived log(s)
archived log file name=/FRA/consol/CONSOL/archivelog/2017_07_29/o1_mf_1_17_dqq65klx_.arc RECID=1 STAMP=950578441
media recovery complete, elapsed time: 00:00:00
Finished recover at 29-JUL-17
Oracle instance started
Total System Global Area 217157632 bytes
Fixed Size 2251816 bytes
Variable Size 159384536 bytes
Database Buffers 50331648 bytes
Redo Buffers 5189632 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''CONSOL'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_name = ''CONSOL'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 217157632 bytes
Fixed Size 2251816 bytes
Variable Size 159384536 bytes
Database Buffers 50331648 bytes
Redo Buffers 5189632 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CONSOL" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/disk02/consol//redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/disk02/consol//redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/disk02/consol//redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/disk02/consol/system01.dbf'
CHARACTER SET WE8MSWIN1252
contents of Memory Script:
{
set newname for tempfile 1 to
"/disk02/consol//temp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/disk02/consol/sysaux01.dbf",
"/disk02/consol/undotbs01.dbf",
"/disk02/consol/users01.dbf",
"/disk02/consol/example01.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /disk02/consol//temp01.dbf in control file
cataloged datafile copy
datafile copy file name=/disk02/consol/sysaux01.dbf RECID=1 STAMP=950578455
cataloged datafile copy
datafile copy file name=/disk02/consol/undotbs01.dbf RECID=2 STAMP=950578455
cataloged datafile copy
datafile copy file name=/disk02/consol/users01.dbf RECID=3 STAMP=950578455
cataloged datafile copy
datafile copy file name=/disk02/consol/example01.dbf RECID=4 STAMP=950578455
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=950578455 file name=/disk02/consol/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=950578455 file name=/disk02/consol/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=950578455 file name=/disk02/consol/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=950578455 file name=/disk02/consol/example01.dbf
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Reenabling controlfile options for auxiliary database
Executing: alter database flashback on
Finished Duplicate Db at 29-JUL-17
RMAN> exit
Recovery Manager complete.
RMAN>
**************************************************************************************************************************************
##Remark## : No need to open clone database in resetlogs while configuring via rman active duplicate, it will do automaticaly via running script. for eg. see above last 15 lines.
**************************************************************************************************************************************
Step: 15
=======================================================================================
Now login to your clone database & check your database health & configuration, whatever you want. ( @Target Site).
-----------------------------------------------------------------------------------------------------------------------------------------------------
NAME INSTANCE_NAME HOST_NAME DATABASE_ROLE LOG_MODE LOGINS OPEN_MODE STARTUP_TIME VERSION
--------- ---------------- -------------------- -------------------- --------------- ---------- --------------- -------------------- -----------------
CONSOL consol target.localdomain PRIMARY ARCHIVELOG ALLOWED READ WRITE 2017:07:29 01:34:12 11.2.0.4.0
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /FRA/consol
db_recovery_file_dest_size big integer 4G
recovery_parallelism integer 0
SQL> select NAME,STATUS,IS_RECOVERY_DEST_FILE from v$controlfile;
NAME STATUS IS_
---------------------------------------- ------- ---
/disk02/consol/control01.ctl NO
SQL> select FILE#,TS#,STATUS from v$datafile;
FILE# TS# STATUS
---------- ---------- -------
1 0 SYSTEM
2 1 ONLINE
3 2 ONLINE
4 4 ONLINE
5 6 ONLINE
SQL> select FILE_NAME,FILE_ID,TABLESPACE_NAME,STATUS,AUTOEXTENSIBLE from dba_data_files;
FILE_NAME FILE_ID TABLESPACE_NAME STATUS AUT
---------------------------------------- ---------- ------------------------------ --------- ---
/disk02/consol/system01.dbf 1 SYSTEM AVAILABLE YES
/disk02/consol/sysaux01.dbf 2 SYSAUX AVAILABLE YES
/disk02/consol/undotbs01.dbf 3 UNDOTBS1 AVAILABLE YES
/disk02/consol/users01.dbf 4 USERS AVAILABLE YES
/disk02/consol/example01.dbf 5 EXAMPLE AVAILABLE YES
SQL> select GROUP#,STATUS,MEMBER,IS_RECOVERY_DEST_FILE from v$logfile;
GROUP# STATUS MEMBER IS_
---------- ------- ---------------------------------------- ---
3 /disk02/consol/redo03.log NO
2 /disk02/consol/redo02.log NO
1 /disk02/consol/redo01.log NO
TABLESPACE FILENAME FL_ID SIZE_GB USED_GB PCT_USED MAXBYTES AUT
------------------------------ -------------------------------------------------- ---------- ---------- ---------- ---------- ---------- ---
TEMP /disk02/consol/temp01.dbf 1 .01953125 .000976563 5 32767.9844 YES
www.oraerrors.blogspot.in
**************************
Pradeep Kumar.
+91-9972201100
