TEP 1:
CREATE PASSWORD FILES ON SOURCE AND TARGET. THE SYS PASSWORDS SHOULD BE SAME.
orapwd file=/u01/app/oracle/product/11.2.0/db_1/dbs/orapwTARGETZ password=sys entries=10
orapwd file=/u01/app/oracle/product/11.2.0/db_1/dbs/orapwSDB password=sys entries=10
STEP 2:
ADD TNSENTRY ON BOTH THE SERVERS FOR BOTH THE DBS.
SDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = test1.telenor.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SDB) ) )
TARGETZ = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = test2.telenor.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TARGETZ) ) )
STEP 3:
ADD STATIC ENTRY IN THE TARGET LISTENER.ORA FILE AND BOUNCE THE LISTENER.
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = TARGETZ) ) )
STEP 4:
STARTUP THE TARGET DB WITH PFILE IN NOMOUNT MODE.
STEP 5:
CONNECT TO TARGET DB
rman > connect TARGET sys/sys@SDB rman > connect AUXILIARY sys/sys@TARGETZ
DUPLICATE DATABASE TO TARGETZ FROM ACTIVE DATABASE SPFILE NOFILENAMECHECK;
STEP 6:
Recovery Manager: Release 11.2.0.3.0 – Production on Tue Dec 17 11:11:48 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> connect TARGET sys/sys@SDB
connected to target database: SDB (DBID=2346129765)
RMAN> connect AUXILIARY sys/sys@TARGETZ
connected to auxiliary database: TARGETZ (not mounted)
RMAN> DUPLICATE DATABASE TO TARGETZ 2> FROM ACTIVE DATABASE 3> SPFILE 4> NOFILENAMECHECK;
RMAN> exit
Recovery Manager complete.
[oracle@tel2 adump]$ cd $ORACLE_HOME [oracle@tel2 dbhome_1]$ pwd /u01/app/oracle/product/11.2.0/dbhome_1 [oracle@tel2 dbhome_1]$ cd dbs [oracle@tel2 dbs]$ ls hc_DB11G.dat hc_TARGETX.dat init.ora initTARGETZ.ora lkTAR lkTARGETZ spfileDB11G.ora spfileTARGETZ.ora hc_TAR.dat hc_TARGETZ.dat initTARGETX_BKP.ora lkDB11G_STBY lkTARGETX orapwTARGETZ spfileTARGETX.ora [oracle@tel2 dbs]$ pwd /u01/app/oracle/product/11.2.0/dbhome_1/dbs [oracle@tel2 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Dec 17 11:13:03 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile=initTARGETZ.ora ORACLE instance started.
Total System Global Area 1853947904 bytes Fixed Size 2229384 bytes Variable Size 469764984 bytes Database Buffers 1375731712 bytes Redo Buffers 6221824 bytes SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@tel2 dbs]$ rman
Recovery Manager: Release 11.2.0.3.0 – Production on Tue Dec 17 11:13:29 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> connect TARGET sys/sys@SDB
connected to target database: SDB (DBID=2346129765)
RMAN> connect AUXILIARY sys/sys@TARGETZ
connected to auxiliary database: TARGETZ (not mounted)
RMAN> DUPLICATE DATABASE TO TARGETZ 2> FROM ACTIVE DATABASE 3> SPFILE 4> NOFILENAMECHECK;
Starting Duplicate Db at 17-DEC-13 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=63 device type=DISK
contents of Memory Script: { backup as copy reuse targetfile ‘/u01/app/oracle/product/11.2.0/db_1/dbs/spfileSDB.ora’ auxiliary format ‘/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileTARGETZ.ora’ ; sql clone “alter system set spfile= ”/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileTARGETZ.ora””; } executing Memory Script
Starting backup at 17-DEC-13 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=69 device type=DISK Finished backup at 17-DEC-13
sql statement: alter system set spfile= ”/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileTARGETZ.ora”
contents of Memory Script: { sql clone “alter system set db_name = ”TARGETZ” comment= ”duplicate” scope=spfile”; shutdown clone immediate; startup clone nomount; } executing Memory Script
sql statement: alter system set db_name = ”TARGETZ” comment= ”duplicate” scope=spfile
Oracle instance shut down
connected to auxiliary database (not started) Oracle instance started
Total System Global Area 2505338880 bytes
Fixed Size 2230952 bytes Variable Size 553649496 bytes Database Buffers 1929379840 bytes Redo Buffers 20078592 bytes
contents of Memory Script: { sql clone “alter system set db_name = ”SDB” comment= ”Modified by RMAN duplicate” scope=spfile”; sql clone “alter system set db_unique_name = ”TARGETZ” comment= ”Modified by RMAN duplicate” scope=spfile”; shutdown clone immediate; startup clone force nomount backup as copy current controlfile auxiliary format ‘/u01/NEWDB/SDB/control01.ctl’; restore clone controlfile to ‘/u01/app/oracle/fast_recovery_area/SDB/control02.ctl’ from ‘/u01/NEWDB/SDB/control01.ctl’; alter clone database mount; } executing Memory Script
sql statement: alter system set db_name = ”SDB” comment= ”Modified by RMAN duplicate” scope=spfile
sql statement: alter system set db_unique_name = ”TARGETZ” comment= ”Modified by RMAN duplicate” scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 2505338880 bytes
Fixed Size 2230952 bytes Variable Size 553649496 bytes Database Buffers 1929379840 bytes Redo Buffers 20078592 bytes
Starting backup at 17-DEC-13 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy copying current control file output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_SDB.f tag=TAG20131217T095101 RECID=1 STAMP=834400262 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03 Finished backup at 17-DEC-13
Starting restore at 17-DEC-13 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=63 device type=DISK
channel ORA_AUX_DISK_1: copied control file copy Finished restore at 17-DEC-13
database mounted RMAN-05538: WARNING: implicitly using DB_FILE_NAME_CONVERT
contents of Memory Script: { set newname for datafile 1 to “/u01/NEWDB/SDB/system01.dbf”; set newname for datafile 2 to “/u01/NEWDB/SDB/sysaux01.dbf”; set newname for datafile 3 to “/u01/NEWDB/SDB/undotbs01.dbf”; set newname for datafile 4 to “/u01/NEWDB/SDB/users01.dbf”; set newname for datafile 5 to “/u01/NEWDB/SDB/steasm_tbs01.dbf”; backup as copy reuse datafile 1 bauxiliary format “/u01/NEWDB/SDB/system01.dbf” datafile 2 auxiliary format “/u01/NEWDB/SDB/sysaux01.dbf” datafile 3 auxiliary format “/u01/NEWDB/SDB/undotbs01.dbf” datafile 4 auxiliary format “/u01/NEWDB/SDB/users01.dbf” datafile 5 auxiliary format “/u01/NEWDB/SDB/steasm_tbs01.dbf” ; sql ‘alter system archive log current’; } executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 17-DEC-13 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy input datafile file number=00002 name=/u01/NEWDB/SDB/sysaux01.dbf output file name=/u01/NEWDB/SDB/sysaux01.dbf tag=TAG20131217T095111 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:27 channel ORA_DISK_1: starting datafile copy input datafile file number=00001 name=/u01/NEWDB/SDB/system01.dbf output file name=/u01/NEWDB/SDB/system01.dbf tag=TAG20131217T095111 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:16 channel ORA_DISK_1: starting datafile copy input datafile file number=00003 name=/u01/NEWDB/SDB/undotbs01.dbf output file name=/u01/NEWDB/SDB/undotbs01.dbf tag=TAG20131217T095111 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15 channel ORA_DISK_1: starting datafile copy input datafile file number=00005 name=/u01/NEWDB/SDB/steasm_tbs01.dbf output file name=/u01/NEWDB/SDB/steasm_tbs01.dbf tag=TAG20131217T095111 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting datafile copy input datafile file number=00004 name=/u01/NEWDB/SDB/users01.dbf output file name=/u01/NEWDB/SDB/users01.dbf tag=TAG20131217T095111 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 Finished backup at 17-DEC-13
sql statement: alter system archive log current
contents of Memory Script: { backup as copy reuse archivelog like “/u01/NEWDB/ARC/1_374_830162152.dbf” auxiliary format “/u01/NEWDB/ARC1_374_830162152.dbf” ; catalog clone archivelog “/u01/NEWDB/ARC1_374_830162152.dbf”; switch clone datafile all; } executing Memory Script
Starting backup at 17-DEC-13 using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log copy input archived log thread=1 sequence=374 RECID=372 STAMP=834400460 output file name=/u01/NEWDB/ARC1_374_830162152.dbf RECID=0 STAMP=0 channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03 Finished backup at 17-DEC-13
cataloged archived log archived log file name=/u01/NEWDB/ARC1_374_830162152.dbf RECID=372 STAMP=834405481
datafile 1 switched to datafile copy input datafile copy RECID=1 STAMP=834405481 file name=/u01/NEWDB/SDB/system01.dbf datafile 2 switched to datafile copy input datafile copy RECID=2 STAMP=834405481 file name=/u01/NEWDB/SDB/sysaux01.dbf datafile 3 switched to datafile copy input datafile copy RECID=3 STAMP=834405481 file name=/u01/NEWDB/SDB/undotbs01.dbf datafile 4 switched to datafile copy input datafile copy RECID=4 STAMP=834405481 file name=/u01/NEWDB/SDB/users01.dbf datafile 5 switched to datafile copy input datafile copy RECID=5 STAMP=834405481 file name=/u01/NEWDB/SDB/steasm_tbs01.dbf
contents of Memory Script: { set until scn 6767843; recover clone database delete archivelog ; } executing Memory Script
executing command: SET until clause
Starting recover at 17-DEC-13 using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 374 is already on disk as file /u01/NEWDB/ARC1_374_830162152.dbf archived log file name=/u01/NEWDB/ARC1_374_830162152.dbf thread=1 sequence=374 media recovery complete, elapsed time: 00:00:01 Finished recover at 17-DEC-13 Oracle instance started
Total System Global Area 2505338880 bytes
Fixed Size 2230952 bytes Variable Size 553649496 bytes Database Buffers 1929379840 bytes Redo Buffers 20078592 bytes
contents of Memory Script: { sql clone “alter system set db_name = ”TARGETZ” 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 = ”TARGETZ” 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 2505338880 bytes
Fixed Size 2230952 bytes Variable Size 553649496 bytes Database Buffers 1929379840 bytes Redo Buffers 20078592 bytes sql statement: CREATE CONTROLFILE REUSE SET DATABASE “TARGETZ” RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 SIZE 50 M , GROUP 2 SIZE 50 M , GROUP 3 SIZE 50 M DATAFILE ‘/u01/NEWDB/SDB/system01.dbf’ CHARACTER SET WE8MSWIN1252
contents of Memory Script: { set newname for tempfile 1 to “/u01/NEWDB/SDB/temp01.dbf”; switch clone tempfile all; catalog clone datafilecopy “/u01/NEWDB/SDB/sysaux01.dbf”, “/u01/NEWDB/SDB/undotbs01.dbf”, “/u01/NEWDB/SDB/users01.dbf”, “/u01/NEWDB/SDB/steasm_tbs01.dbf”; switch clone datafile all; } executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/NEWDB/SDB/temp01.dbf in control file
cataloged datafile copy datafile copy file name=/u01/NEWDB/SDB/sysaux01.dbf RECID=1 STAMP=834405504 cataloged datafile copy datafile copy file name=/u01/NEWDB/SDB/undotbs01.dbf RECID=2 STAMP=834405504 cataloged datafile copy datafile copy file name=/u01/NEWDB/SDB/users01.dbf RECID=3 STAMP=834405504 cataloged datafile copy datafile copy file name=/u01/NEWDB/SDB/steasm_tbs01.dbf RECID=4 STAMP=834405504
datafile 2 switched to datafile copy input datafile copy RECID=1 STAMP=834405504 file name=/u01/NEWDB/SDB/sysaux01.dbf datafile 3 switched to datafile copy input datafile copy RECID=2 STAMP=834405504 file name=/u01/NEWDB/SDB/undotbs01.dbf datafile 4 switched to datafile copy input datafile copy RECID=3 STAMP=834405504 file name=/u01/NEWDB/SDB/users01.dbf datafile 5 switched to datafile copy input datafile copy RECID=4 STAMP=834405504 file name=/u01/NEWDB/SDB/steasm_tbs01.dbf
contents of Memory Script: { Alter clone database open resetlogs; } executing Memory Script
database opened Finished Duplicate Db at 17-DEC-13
RMAN> exit
SAFI 