Duplicating Oracle Database on the Same Host Using RMAN Backup
Duplicating Oracle Database on the Same Host Using RMAN Backup
Ø
Goal: To quickly duplicate a production Oracle
database on the same host without shutting down / over loading the source
database.
Ø
Method: Duplicating the running database using
RMAN backups.
Ø
Environment:
·
Host: Oracle Solaris
·
OS: SunOS 5.10
·
Oracle Database: 11.1.0.3.0
·
Source DB: EXAOEM
·
Duplicate DB: OEMDUP
1. Checking the source DB
1.1.
DB file location and size
2.
Prep
for the duplicate database
2.1
Ensure the needed space needed is available.
oracle@wapexam5k02oem01>
df -h /DB_restore/
Filesystem size used
avail capacity Mounted on
wapexam5k01cgn01:/os_images/DB_restore
488G 119G 370G 25%
/DB_restore
2.2
Add a TNS entry
OEMDUP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
wapexam5k02oem01)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = OEMDUP)
)
)
oracle@wapexam5k02oem01>
tnsping OEMDUP
TNS Ping Utility for
Solaris: Version 11.2.0.3.0 - Production on 31-JUL-2018 10:30:49
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the
alias
Attempting to contact (DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = wapexam5k02oem01)(PORT =
1521))) (CONNECT_DATA = (SERVICE_NAME = OEMDUP)))
OK (10 msec)
2.3
Create the directories and password file
oracle@wapexam5k02oem01>
mkdir /u01/oracle/admin/OEMDUP; cd /u01/oracle/admin/OEMDUP
oracle@wapexam5k02oem01>
mkdir adump dpdump pfile
oracle@wapexam5k02oem01> orapwd
file=$ORACLE_HOME/dbs/orapwOEMDUP password=xxxxxxxx entries=5
3
Check
the RMAN backups (in CommVault)
RMAN> show all;
using
target database control file instead of recovery catalog
RMAN
configuration parameters for database with db_unique_name EXAOEM are:
CONFIGURE
RETENTION POLICY TO RECOVERY WINDOW OF 35 DAYS;
CONFIGURE
BACKUP OPTIMIZATION OFF; # default
CONFIGURE
DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE
CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE
CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE
CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE
DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE
DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE
DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG
BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE
ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE
CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576, SBT_LIBRARY=/opt/commvault/Base/libobk.so';
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/oracle/product/11.2.0.3/dbhome_1/dbs/snapcf_EXAOEM.f'; # default
Check the DB
files, controlfile, spfile, and the archived logs, in the backup, since the
last level 0 backup.
RMAN> list backup by file completed
after 'sysdate-1';
List of Datafile Backups
========================
File Key TY LV S Ckp SCN Ckp Time
#Pieces #Copies Compressed Tag
---- ------- - -- - ---------- --------- ------- ------- ----------
---
1 73524
B 0 A 61380820739 30-JUL-18 1 1
YES TAG20180730T210015
2 73525
B 0 A 61380820736 30-JUL-18 1 1
YES TAG20180730T210015
3 73523
B 0 A 61380820746 30-JUL-18 1 1
YES TAG20180730T210015
4 73520
B 0 A 61380820769 30-JUL-18 1 1
YES TAG20180730T210015
5 73527
B 0 A 61380820730 30-JUL-18 4 1
YES TAG20180730T210015
6 73526
B 0 A 61380820723 30-JUL-18 6 1
YES TAG20180730T210015
7 73522
B 0 A 61380820794 30-JUL-18 1 1
YES TAG20180730T210015
List of Archived Log Backups
============================
Thrd Seq Low SCN
Low Time BS Key S #Pieces #Copies Compressed Tag
---- ------- ---------- ---------
------- - ------- ------- ---------- ---
1 705892
61379737010 30-JUL-18 73504 A
1 1 YES TAG20180730T120016
......
1 706336
61381748075 31-JUL-18 73546 A
1 1 YES TAG20180731T080016
List of Control File Backups
============================
CF Ckp SCN Ckp Time BS Key
S #Pieces #Copies Compressed Tag
----------- --------- ------- -
------- ------- ---------- ---
61380820753 30-JUL-18 73521 A 1
1 YES TAG20180730T210015
List of SPFILE Backups
======================
Modification Time BS Key S #Pieces #Copies Compressed Tag
----------------- ------- -
------- ------- ---------- ---
09-JUL-18 73528
A 1 1 YES TAG20180730T210015
4
Create
pfile for the duplicate database
SQL> sho
parameter pfile
NAME TYPE
VALUE
-------- -----------
------------------------------
spfile
string
/u01/oracle/product/11.2.0.3/d bhome_1/dbs/spfileEXAOEM.ora
SQL> create
pfile='/u01/oracle/product/11.2.0.3/dbhome_1/dbs/initOEMDUP.ora' from spfile;
File created.
- - Create the
pfile with all parameters retrieved from the source DB spfile to avoid
specifying “spfile” in the RMAN duplicate command.
- - Make
changes in the highlighted parameters
- - Add “db_file_name_convert”
and “log_file_name_convert”
oracle@wapexam5k02oem01> vi $ORACLE_HOME/dbs/initOEMDUP.ora
OEMDUP.__db_cache_size=1191182336
OEMDUP.__java_pool_size=16777216
OEMDUP.__large_pool_size=16777216
OEMDUP.__oracle_base='/u01/oracle' #ORACLE_BASE set from environment
OEMDUP.__pga_aggregate_target=1056964608
OEMDUP.__sga_target=3154116608
OEMDUP.__shared_io_pool_size=0
OEMDUP.__shared_pool_size=1862270976
OEMDUP.__streams_pool_size=16777216
*.audit_file_dest='/u01/oracle/admin/OEMDUP/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/DB_restore/oradata/OEMDUP/control01.ctl','/DB_restore/oradata/OEMDUP/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='OEMDUP'
*.diagnostic_dest='/u01/oracle'
*.dispatchers='(PROTOCOL=TCP)
(SERVICE=OEMDUPXDB)'
*.job_queue_processes=1000
*.log_archive_dest_1='location=/DB_restore/archive/OEMDUP/'
*.open_cursors=300
*.pga_aggregate_target=1046478848
*.processes=400
*.remote_login_passwordfile='EXCLUSIVE'
*.service_names='OEMDUP'
*.session_cached_cursors=500
*.sessions=445
*.sga_target=3139436544
*.shared_pool_size=600M
*.undo_tablespace='UNDOTBS1'
db_file_name_convert =
'/u01/oracle/database/data/EXAOEM','/DB_restore/oradata/OEMDUP'
log_file_name_convert =
'/u01/oracle/database/data/EXAOEM','/DB_restore/oradata/OEMDUP'
5
Run
RMAN duplicate
5.1
Start the duplicate instance in nomount mode
oracle@wapexam5k02oem01>
export ORACLE_SID=OEMDUP
oracle@wapexam5k02oem01>
sqlplus / as sysdba
SQL> startup
nomount
SQL> sho parameter pfile
NAME TYPE VALUE
------------------------------------
----------- ---------
spfile string
SQL> sho parameter name
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
db_file_name_convert string /u01/oracle/database/data/EXAO
EM, /DB_restore/oradata/OEMDUP
db_name string OEMDUP
db_unique_name string OEMDUP
global_names boolean FALSE
instance_name string OEMDUP
lock_name_space string
log_file_name_convert string /u01/oracle/database/data/EXAO
EM, /DB_restore/oradata/OEMDUP
processor_group_name string
service_names string OEMDUP
oracle@wapexam5k02oem01>
ps -ef | grep pmon | grep -v grep
oracle 23480 5894 0
Mar 10 ? 220:22
ora_pmon_EXAOEM
oracle 6011 5894
0 10:51:13 ? 0:00
ora_pmon_OEMDUP
5.2
Run RMAN duplicate
oracle@wapexam5k02oem01> rman
Recovery Manager: Release
11.2.0.3.0 - Production on Tue Jul 31 11:59:58 2018
Copyright (c) 1982, 2011, Oracle
and/or its affiliates. All rights
reserved.
RMAN> connect target sys/xxxxxxxx@exaoem
connected to target database:
EXAOEM (DBID=3547364463)
RMAN> connect auxiliary /
connected to auxiliary database:
OEMDUP (not mounted)
RMAN> spool log to OEMDUP_crt_073118.log
RMAN> duplicate target database to OEMDUP;
oracle@wapexam5k02oem01>
tail -f OEMDUP_crt_073118.log
(The RMAN outputs
shortened)
Starting
Duplicate Db at 31-JUL-18
using target database
control file instead of recovery catalog
allocated channel:
ORA_AUX_SBT_TAPE_1
channel
ORA_AUX_SBT_TAPE_1: SID=281 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_1: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel:
ORA_AUX_SBT_TAPE_2
channel
ORA_AUX_SBT_TAPE_2: SID=291 device type=SBT_TAPE
channel ORA_AUX_SBT_TAPE_2:
CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel:
ORA_AUX_SBT_TAPE_3
channel
ORA_AUX_SBT_TAPE_3: SID=301 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_3: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel:
ORA_AUX_SBT_TAPE_4
channel
ORA_AUX_SBT_TAPE_4: SID=311 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_4: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel:
ORA_AUX_SBT_TAPE_5
channel
ORA_AUX_SBT_TAPE_5: SID=321 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_5: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel:
ORA_AUX_SBT_TAPE_6
channel
ORA_AUX_SBT_TAPE_6: SID=331 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_6: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel:
ORA_AUX_SBT_TAPE_7
channel
ORA_AUX_SBT_TAPE_7: SID=341 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_7: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel:
ORA_AUX_SBT_TAPE_8
channel
ORA_AUX_SBT_TAPE_8: SID=351 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_8: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel:
ORA_AUX_DISK_1
channel ORA_AUX_DISK_1:
SID=361 device type=DISK
allocated channel:
ORA_AUX_DISK_2
channel ORA_AUX_DISK_2:
SID=371 device type=DISK
allocated channel:
ORA_AUX_DISK_3
channel ORA_AUX_DISK_3:
SID=381 device type=DISK
allocated channel:
ORA_AUX_DISK_4
channel ORA_AUX_DISK_4:
SID=391 device type=DISK
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 3140960256 bytes
Fixed Size 2163424 bytes
Variable Size 687873312 bytes
Database Buffers 2415919104 bytes
Redo Buffers 35004416 bytes
contents of Memory
Script:
{
sql clone "alter system set db_name =
''EXAOEM'' comment=
''Modified by RMAN duplicate''
scope=spfile";
sql clone "alter system set db_unique_name =
''OEMDUP'' comment=
''Modified by RMAN duplicate''
scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile;
alter clone database mount;
}
executing Memory Script
sql statement: alter
system set db_name = ''EXAOEM'' comment= ''Modified by RMAN
duplicate'' scope=spfile
sql statement: alter
system set db_unique_name = ''OEMDUP'' comment= ''Modified by RMAN
duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global
Area 3140960256 bytes
Fixed Size 2163424 bytes
Variable Size 687873312 bytes
Database Buffers 2415919104 bytes
Redo Buffers 35004416 bytes
Starting restore at
31-JUL-18
allocated channel:
ORA_AUX_SBT_TAPE_1
channel
ORA_AUX_SBT_TAPE_1: SID=281 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_1: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel:
ORA_AUX_SBT_TAPE_2
channel
ORA_AUX_SBT_TAPE_2: SID=291 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_2: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel:
ORA_AUX_SBT_TAPE_3
channel
ORA_AUX_SBT_TAPE_3: SID=301 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_3: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel:
ORA_AUX_SBT_TAPE_4
channel
ORA_AUX_SBT_TAPE_4: SID=311 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_4: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel:
ORA_AUX_SBT_TAPE_5
channel
ORA_AUX_SBT_TAPE_5: SID=321 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_5: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel:
ORA_AUX_SBT_TAPE_6
channel ORA_AUX_SBT_TAPE_6:
SID=331 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_6: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel:
ORA_AUX_SBT_TAPE_7
channel
ORA_AUX_SBT_TAPE_7: SID=341 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_7: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel:
ORA_AUX_SBT_TAPE_8
channel
ORA_AUX_SBT_TAPE_8: SID=351 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_8: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel:
ORA_AUX_DISK_1
channel ORA_AUX_DISK_1:
SID=361 device type=DISK
allocated channel:
ORA_AUX_DISK_2
channel ORA_AUX_DISK_2:
SID=371 device type=DISK
allocated channel:
ORA_AUX_DISK_3
channel ORA_AUX_DISK_3:
SID=381 device type=DISK
allocated channel:
ORA_AUX_DISK_4
channel ORA_AUX_DISK_4:
SID=391 device type=DISK
channel
ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel
ORA_AUX_SBT_TAPE_1: restoring control file
channel
ORA_AUX_SBT_TAPE_1: reading from backup piece i3t9avf1_1_1
channel
ORA_AUX_SBT_TAPE_1: piece handle=i3t9avf1_1_1 tag=TAG20180730T210015
channel
ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel
ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
output file
name=/DB_restore/oradata/OEMDUP/control01.ctl
output file
name=/DB_restore/oradata/OEMDUP/control02.ctl
Finished restore at
31-JUL-18
database mounted
contents of Memory
Script:
{
set until scn 61382180107;
set newname for datafile 1 to
"/DB_restore/oradata/OEMDUP/system01.dbf";
set newname for datafile 2 to
"/DB_restore/oradata/OEMDUP/sysaux01.dbf";
set newname for datafile 3 to
"/DB_restore/oradata/OEMDUP/undotbs01.dbf";
set newname for datafile 4 to
"/DB_restore/oradata/OEMDUP/users01.dbf";
set newname for datafile 5 to
"/DB_restore/oradata/OEMDUP/mgmt_ecm_depot1.dbf";
set newname for datafile 6 to
"/DB_restore/oradata/OEMDUP/mgmt.dbf";
set newname for datafile 7 to
"/DB_restore/oradata/OEMDUP/mgmt_ad4j.dbf";
restore
clone database
;
}
executing Memory Script
executing command: SET
until clause
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
Starting restore at
31-JUL-18
using channel
ORA_AUX_SBT_TAPE_1
using channel
ORA_AUX_SBT_TAPE_2
using channel
ORA_AUX_SBT_TAPE_3
using channel
ORA_AUX_SBT_TAPE_4
using channel
ORA_AUX_SBT_TAPE_5
using channel
ORA_AUX_SBT_TAPE_6
using channel
ORA_AUX_SBT_TAPE_7
using channel
ORA_AUX_SBT_TAPE_8
using channel
ORA_AUX_DISK_1
using channel
ORA_AUX_DISK_2
using channel
ORA_AUX_DISK_3
using channel ORA_AUX_DISK_4
channel
ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel
ORA_AUX_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel
ORA_AUX_SBT_TAPE_1: restoring datafile 00004 to
/DB_restore/oradata/OEMDUP/users01.dbf
channel
ORA_AUX_SBT_TAPE_1: reading from backup piece i4t9avf1_1_1
channel ORA_AUX_SBT_TAPE_2:
starting datafile backup set restore
channel
ORA_AUX_SBT_TAPE_2: specifying datafile(s) to restore from backup set
…………
channel
ORA_AUX_SBT_TAPE_5: restore complete, elapsed time: 00:03:40
channel
ORA_AUX_SBT_TAPE_6: piece handle=hut9avf0_1_1 tag=TAG20180730T210015
channel
ORA_AUX_SBT_TAPE_6: restored backup piece 1
channel
ORA_AUX_SBT_TAPE_6: restore complete, elapsed time: 00:08:04
Finished restore at
31-JUL-18
contents of Memory
Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to
datafile copy
input datafile copy
RECID=10 STAMP=982934518 file name=/DB_restore/oradata/OEMDUP/system01.dbf
datafile 2 switched to
datafile copy
input datafile copy
RECID=11 STAMP=982934518 file name=/DB_restore/oradata/OEMDUP/sysaux01.dbf
datafile 3 switched to
datafile copy
input datafile copy
RECID=12 STAMP=982934519 file name=/DB_restore/oradata/OEMDUP/undotbs01.dbf
datafile 4 switched to
datafile copy
input datafile copy
RECID=13 STAMP=982934519 file name=/DB_restore/oradata/OEMDUP/users01.dbf
datafile 5 switched to
datafile copy
input datafile copy
RECID=14 STAMP=982934519 file
name=/DB_restore/oradata/OEMDUP/mgmt_ecm_depot1.dbf
datafile 6 switched to
datafile copy
input datafile copy
RECID=15 STAMP=982934519 file name=/DB_restore/oradata/OEMDUP/mgmt.dbf
datafile 7 switched to
datafile copy
input datafile copy
RECID=16 STAMP=982934519 file name=/DB_restore/oradata/OEMDUP/mgmt_ad4j.dbf
contents of Memory
Script:
{
set until scn 61382180107;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET
until clause
Starting recover at
31-JUL-18
using channel
ORA_AUX_SBT_TAPE_1
using channel
ORA_AUX_SBT_TAPE_2
using channel
ORA_AUX_SBT_TAPE_3
using channel
ORA_AUX_SBT_TAPE_4
using channel
ORA_AUX_SBT_TAPE_5
using channel ORA_AUX_SBT_TAPE_6
using channel
ORA_AUX_SBT_TAPE_7
using channel
ORA_AUX_SBT_TAPE_8
using channel
ORA_AUX_DISK_1
using channel
ORA_AUX_DISK_2
using channel ORA_AUX_DISK_3
using channel
ORA_AUX_DISK_4
starting media recovery
archived log for thread 1
with sequence 706138 is already on disk as file
/clu01/archive/1_706138_807372338.dbf
archived log for thread 1
with sequence 706139 is already on disk as file
/clu01/archive/1_706139_807372338.dbf
archived log for thread 1
with sequence 706140 is already on disk as file
/clu01/archive/1_706140_807372338.dbf
…………
archived log for thread 1
with sequence 706430 is already on disk as file
/clu01/archive/1_706430_807372338.dbf
archived log for thread 1
with sequence 706431 is already on disk as file
/clu01/archive/1_706431_807372338.dbf
archived log for thread 1
with sequence 706432 is already on disk as file
/clu01/archive/1_706432_807372338.dbf
channel
ORA_AUX_SBT_TAPE_1: starting archived log restore to default destination
channel
ORA_AUX_SBT_TAPE_1: restoring archived log
archived log thread=1
sequence=706135
channel
ORA_AUX_SBT_TAPE_1: restoring archived log
archived log thread=1
sequence=706136
channel
ORA_AUX_SBT_TAPE_1: restoring archived log
archived log thread=1
sequence=706137
channel
ORA_AUX_SBT_TAPE_1: reading from backup piece imt9b056_1_1
channel
ORA_AUX_SBT_TAPE_1: piece handle=imt9b056_1_1 tag=TAG20180730T211204
channel
ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel
ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:15
archived log file
name=/DB_restore/archive/OEMDUP/1_706135_807372338.dbf thread=1 sequence=706135
channel clone_default:
deleting archived log(s)
archived log file
name=/DB_restore/archive/OEMDUP/1_706135_807372338.dbf RECID=585353
STAMP=982934535
archived log file
name=/DB_restore/archive/OEMDUP/1_706136_807372338.dbf thread=1 sequence=706136
channel clone_default:
deleting archived log(s)
archived log file
name=/DB_restore/archive/OEMDUP/1_706136_807372338.dbf RECID=585354
STAMP=982934536
archived log file
name=/DB_restore/archive/OEMDUP/1_706137_807372338.dbf thread=1 sequence=706137
channel clone_default:
deleting archived log(s)
archived log file
name=/DB_restore/archive/OEMDUP/1_706137_807372338.dbf RECID=585355
STAMP=982934537
archived log file
name=/clu01/archive/1_706138_807372338.dbf thread=1 sequence=706138
archived log file
name=/clu01/archive/1_706139_807372338.dbf thread=1 sequence=706139
…………
archived log file
name=/clu01/archive/1_706430_807372338.dbf thread=1 sequence=706430
archived log file
name=/clu01/archive/1_706431_807372338.dbf thread=1 sequence=706431
archived log file
name=/clu01/archive/1_706432_807372338.dbf thread=1 sequence=706432
media recovery complete,
elapsed time: 00:02:08
Finished recover at
31-JUL-18
Oracle instance started
Total System Global
Area 3140960256 bytes
Fixed Size 2163424 bytes
Variable Size 687873312 bytes
Database Buffers 2415919104 bytes
Redo Buffers 35004416 bytes
contents of Memory
Script:
{
sql clone "alter system set db_name =
''OEMDUP'' 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 = ''OEMDUP'' 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 3140960256 bytes
Fixed Size 2163424 bytes
Variable Size 687873312 bytes
Database Buffers 2415919104 bytes
Redo Buffers 35004416 bytes
sql statement: CREATE
CONTROLFILE REUSE SET DATABASE "OEMDUP" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 4680
LOGFILE
GROUP
1 ( '/DB_restore/oradata/OEMDUP/redo01.log',
'/DB_restore/oradata/OEMDUP/redo01a.log' ) SIZE 50 M REUSE,
GROUP
2 ( '/DB_restore/oradata/OEMDUP/redo02.log',
'/DB_restore/oradata/OEMDUP/redo02a.log' ) SIZE 50 M REUSE,
GROUP
3 ( '/DB_restore/oradata/OEMDUP/redo03.log',
'/DB_restore/oradata/OEMDUP/redo03a' ) SIZE 50 M REUSE
DATAFILE
'/DB_restore/oradata/OEMDUP/system01.dbf'
CHARACTER SET WE8MSWIN1252
contents of Memory
Script:
{
set newname for tempfile 1 to
"/DB_restore/oradata/OEMDUP/temp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy
"/DB_restore/oradata/OEMDUP/sysaux01.dbf",
"/DB_restore/oradata/OEMDUP/undotbs01.dbf",
"/DB_restore/oradata/OEMDUP/users01.dbf",
"/DB_restore/oradata/OEMDUP/mgmt_ecm_depot1.dbf",
"/DB_restore/oradata/OEMDUP/mgmt.dbf",
"/DB_restore/oradata/OEMDUP/mgmt_ad4j.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET
NEWNAME
renamed tempfile 1 to
/DB_restore/oradata/OEMDUP/temp01.dbf in control file
cataloged datafile copy
datafile copy file
name=/DB_restore/oradata/OEMDUP/sysaux01.dbf RECID=1 STAMP=982934792
cataloged datafile copy
datafile copy file
name=/DB_restore/oradata/OEMDUP/undotbs01.dbf RECID=2 STAMP=982934792
cataloged datafile copy
datafile copy file
name=/DB_restore/oradata/OEMDUP/users01.dbf RECID=3 STAMP=982934792
cataloged datafile copy
datafile copy file
name=/DB_restore/oradata/OEMDUP/mgmt_ecm_depot1.dbf RECID=4 STAMP=982934792
cataloged datafile copy
datafile copy file
name=/DB_restore/oradata/OEMDUP/mgmt.dbf RECID=5 STAMP=982934792
cataloged datafile copy
datafile copy file
name=/DB_restore/oradata/OEMDUP/mgmt_ad4j.dbf RECID=6 STAMP=982934792
datafile 2 switched to
datafile copy
input datafile copy
RECID=1 STAMP=982934792 file name=/DB_restore/oradata/OEMDUP/sysaux01.dbf
datafile 3 switched to
datafile copy
input datafile copy
RECID=2 STAMP=982934792 file name=/DB_restore/oradata/OEMDUP/undotbs01.dbf
datafile 4 switched to
datafile copy
input datafile copy
RECID=3 STAMP=982934792 file name=/DB_restore/oradata/OEMDUP/users01.dbf
datafile 5 switched to
datafile copy
input datafile copy
RECID=4 STAMP=982934792 file
name=/DB_restore/oradata/OEMDUP/mgmt_ecm_depot1.dbf
datafile 6 switched to
datafile copy
input datafile copy
RECID=5 STAMP=982934792 file name=/DB_restore/oradata/OEMDUP/mgmt.dbf
datafile 7 switched to
datafile copy
input datafile copy
RECID=6 STAMP=982934792 file name=/DB_restore/oradata/OEMDUP/mgmt_ad4j.dbf
contents of Memory
Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database
opened
Finished
Duplicate Db at 31-JUL-18
6
Verify
the duplicate database
posted by Kyle H @ August 01, 2018
0 Comments
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home