Duplicating 9-TB Oracle RAC Database on the Same Cluster Using RMAN Backup
Duplicating 9-TB Oracle RAC Database on the
Same Cluster Using RMAN Backup
Ø
Goal: To quickly verify RMAN backups on tape
(CommVault v11) for a RAC production database, with the DB running and without
additional hosts.
Ø
Method: Duplicating the running RAC database, on
the same cluster, using the backups.
Ø
Environment:
·
Host: Oracle Exadata X4-2, 2-node cluster
(wapexadbadm01, wapexadbadm01)
·
OS: Oracle Linux 6.9
·
Oracle GI: 12.1.0.2.0
·
Oracle RAC: 12.1.0.2.0
·
Source RAC DB: DWREP (9 TB, with encrypted tablespaces)
·
Duplicate RAC DB: DWREPDP
1. Checking the source DB
1.1
Configuration and status
1.2
DB file location and size
SQL>
@dbsize_file
ID TS_Name / FileClass
Filename
Size_GB
--- ----------------------
------------------------------------------------------ ---------
1 SYSTEM
+DATA/dwrep/datafile/system.770.824630433 2.93
2 SYSAUX
+DATA/dwrep/datafile/sysaux.771.824630433 3.81
3 UNDOTBS1
+DATA/dwrep/datafile/undotbs1.772.824630433 30.00
4 USERS
+DATA/dwrep/datafile/users.773.824630433 1.00
5 UNDOTBS2
+DATA/dwrep/datafile/undotbs2.778.824630535 30.00
6 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.782.824736873 24.00
7 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.783.824736999 24.00
8 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.784.824736999 24.00
9 DWREPUSR_D +DATA/dwrep/datafile/dwrepusr_d.785.824737001 24.00
10 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.786.824737001 24.00
11 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.787.824737001 24.00
12 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.788.824737001 24.00
13 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.789.824737003 24.00
14 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.790.824737003 24.00
15 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.791.824737003 24.00
16 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.792.824737003 24.00
17 DWREPUSR_D +DATA/dwrep/datafile/dwrepusr_d.793.824737005 24.00
18 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.794.824737005 24.00
19 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.795.824737005 24.00
20 DWREPUSR_D +DATA/dwrep/datafile/dwrepusr_d.796.824737005 24.00
21 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.797.824737007 24.00
22 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.798.824737007 24.00
23 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.799.824737007 24.00
24 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.800.824737007 24.00
25 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.801.824737009 24.00
26 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.802.824737009 24.00
27 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.803.824737009 24.00
28 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.804.824737009 24.00
29 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.805.824737009 24.00
30 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.806.824737011 24.00
31 DWREPUSR_D +DATA/dwrep/datafile/dwrepusr_d.807.824737011 24.00
32 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.808.824737011 24.00
33 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.809.824737011 24.00
34 DWREPUSR_D +DATA/dwrep/datafile/dwrepusr_d.810.824737013 24.00
35 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.811.824737013 24.00
36 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.812.824737013 24.00
37 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.813.824737013 24.00
38 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.814.824737015 24.00
39 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.815.824737015 24.00
40 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.816.824737015 24.00
41 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.817.824737017 24.00
42 DWREPUSR_D +DATA/dwrep/datafile/dwrepusr_d.818.824737017 24.00
43 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.819.824737017 24.00
44 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.820.824737017 24.00
45 DWREPUSR_D +DATA/dwrep/datafile/dwrepusr_d.821.824737019 24.00
46 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.822.824737019 24.00
47 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.823.824737019 24.00
48 DWREPUSR_D +DATA/dwrep/datafile/dwrepusr_d.824.824737019 24.00
49 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.825.824737021 24.00
50 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.826.824737021 24.00
51
DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.827.824737021 24.00
52 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.828.824737023 24.00
53 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.829.824737023 24.00
54 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.830.824737023 24.00
55 DWREPUSR_D
+DATA/dwrep/datafile/dwrepusr_d.831.824737023 24.00
56 DWREPUSR_D +DATA/dwrep/datafile/dwrepusr_d.832.824737023 24.00
57 DEV_MDS
+DATA/dwrep/datafile/dev_mds.279.865330921 .10
58 DEV_BIPLATFORM
+DATA/dwrep/datafile/dev_biplatform.1300.865330923 .06
59 ENCRYPT_DWREPUSR_D +DATA/dwrep/datafile/encrypt_dwrepusr_d.664.933962639 4,920.00
60 ENCRYPT_ODSDM_1
+DATA/dwrep/datafile/encrypt_odsdm_1.1081.914943293 2,249.00
61 ENCRYPT_ODSDMSTG_1
+DATA/dwrep/datafile/encrypt_odsdmstg_1.1128.914943311 2.00
62 UNDOTBS1 +DATA/dwrep/datafile/undotbs1.657.933967145 2.42
63 UNDOTBS1
+DATA/dwrep/datafile/undotbs1.655.933967215 9.00
64 UNDOTBS1
+DATA/dwrep/datafile/undotbs1.651.933967219 9.00
65 UNDOTBS2
+DATA/dwrep/datafile/undotbs2.638.933967323 8.00
66 UNDOTBS2
+DATA/dwrep/datafile/undotbs2.633.933967327 6.00
67 UNDOTBS2
+DATA/dwrep/datafile/undotbs2.632.933967351 7.00
68 ENCRYPT_HCA_USR
+DATA/dwrep/datafile/encrypt_hca_d.dbf .49
69 ENCRYPT_STATEUSER_D
+DATA/dwrep/datafile/encrypt_stateuser_d.dbf 1.00
70 ENCRYPT_CNSI_USER_MTNC
+DATA/dwrep/datafile/encrypt_cnsi_user_mtnc.dbf 1.00
DEV_IAS_TEMP
+DATA/dwrep/tempfile/dev_ias_temp.270.865330921 .10
TEMP
+DATA/dwrep/tempfile/temp.670.926340657 29.00
TEMP +DATA/dwrep/tempfile/temp.681.926340655 29.00
TEMP
+DATA/dwrep/tempfile/temp.684.926340655 29.00
TEMP
+DATA/dwrep/tempfile/temp.695.926340653 29.00
TEMP
+DATA/dwrep/tempfile/temp.699.926340653 29.00
TEMP
+DATA/dwrep/tempfile/temp.702.926340653 29.00
TEMP
+DATA/dwrep/tempfile/temp.704.926340651 29.00
TEMP
+DATA/dwrep/tempfile/temp.707.926340651 29.00
TEMP
+DATA/dwrep/tempfile/temp.717.926340649 29.00
TEMP
+DATA/dwrep/tempfile/temp.723.926340633 29.00
TEMP
+DATA/dwrep/tempfile/temp.724.926167581 29.00
TEMP
+DATA/dwrep/tempfile/temp.734.926167579 29.00
TEMP +DATA/dwrep/tempfile/temp.736.926167579 29.00
TEMP
+DATA/dwrep/tempfile/temp.737.926167579 29.00
TEMP
+DATA/dwrep/tempfile/temp.739.926167577 29.00
TEMP +DATA/dwrep/tempfile/temp.757.926167575 29.00
TEMP
+DATA/dwrep/tempfile/temp.777.824630521 29.00
[CONTROL FILE]
+DATA/dwrep/controlfile/current.774.824630513
[CONTROL FILE]
+RECO/dwrep/controlfile/current.4690.824630513
[ONLINE REDO LOG]
+DATA/dwrep/onlinelog/group_1.redo_g1m3.rdo 4.00
[ONLINE REDO LOG]
+DATA/dwrep/onlinelog/group_2.redo_g2m1.rdo 4.00
[ONLINE REDO LOG]
+DATA/dwrep/onlinelog/group_3.redo_g3m1.rdo 4.00
[ONLINE REDO LOG]
+DATA/dwrep/onlinelog/group_4.redo_g4m1.rdo 4.00
[ONLINE REDO LOG]
+RECO/dwrep/onlinelog/group_1.redo_g1m4.rdo 4.00
[ONLINE REDO LOG]
+RECO/dwrep/onlinelog/group_2.redo_g2m2.rdo 4.00
[ONLINE REDO LOG]
+RECO/dwrep/onlinelog/group_3.redo_g3m2.rdo 4.00
[ONLINE REDO LOG]
+RECO/dwrep/onlinelog/group_4.redo_g4m2.rdo 4.00
---------
sum
9,031.91
98 rows selected.
1.3
Encrypted
tablespaces
SQL> select encrypted, count(*) from
dba_tablespaces group by encrypted;
ENC
COUNT(*)
--- ----------
NO 10
YES 6
1.4 Confirm OMF is used:
SQL> sho parameter
db_create_
NAME TYPE VALUE
------------------------------------
----------- -----
db_create_file_dest string +DATA
db_create_online_log_dest_1 string +DATA
db_create_online_log_dest_2 string +RECO
2.
Ensure
the space in ASM needed for the duplicate DB is available.
3. Setup for the duplicate DB
3. Setup for the duplicate DB
3.1.
Oracle TDE wallet
Make sure the source database TDE wallet is auto login enabled.
wapexadbadm01:oracle> orapki wallet display -wallet /u01/app/oracle/admin/wallets/DWREP1 -pwd “xxxxxxx”
wapexadbadm01:oracle> orapki wallet display -wallet /u01/app/oracle/admin/wallets/DWREP1 -pwd “xxxxxxx”
Oracle PKI Tool : Version
12.1.0.2
Copyright (c) 2004, 2014, Oracle and/or its affiliates. All
rights reserved.
Found Auto Login (AL)wallet.
Option -pwd is not recognized and ignored.
Requested Certificates:
Subject:
CN=oracle
User Certificates:
Oracle Secret Store entries:
ORACLE.SECURITY.DB.ENCRYPTION.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
ORACLE.SECURITY.DB.ENCRYPTION.MASTERKEY
ORACLE.SECURITY.TS.ENCRYPTION.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Trusted Certificates:
wapexadbadm01:oracle> cat
$ORACLE_HOME/network/admin/sqlnet.ora
ENCRYPTION_WALLET_LOCATION
= (SOURCE = (METHOD = FILE) (METHOD_DATA =
(DIRECTORY =
/u01/app/oracle/admin/wallets/$ORACLE_SID)))
wapexadbadm01:oracle> cd /u01/app/oracle/admin/wallets;
cp -r DWREP1 DWREPDP
Register the auxiliary instance statically
with the listener by adding the ENVS parameter in sqlnet.ora in GI home.
wapexadbadm01:grid>
grep ENVS $ORACLE_HOME/network/admin/sqlnet.ora
(ENVS = "ORACLE_UNQNAME=DWREPDP,
ENCRYPTION_WALLET_LOCATION = (SOURCE = (METHOD = FILE)(METHOD_DATA = (DIRECTORY
= /u01/app/oracle/admin/wallets/DWREPDP)))")
3.2. Add
a TNS entry in RDBMS home
DWREPDP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =
wapexa-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DWREPDP)))
wapexadbadm01:oracle>
tnsping dwrepdp
TNS Ping Utility for Linux: Version
12.1.0.2.0 - Production on 03-AUG-2018 10:25:21
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL =
TCP)(HOST = wapexa-scan)
(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = DWREPDP)))
OK (0 msec)
3.3. Create
directories
wapexadbadm01:oracle> cd
/u01/app/oracle/admin; cp -r DWREP DWREPDP; cd DWREPDP
Delete all files in the sub-dirs,
but keep the 2 wallet files in the dir xdb_wallet
3.4. Create
the password file
wapexadbadm01:oracle> orapwd
file=$ORACLE_HOME/dbs/orapwDWREPDP1 password=xxxxxx entries=5
3.5. Add
an entry in /etc/oratab
DWREPDP:/u01/app/oracle/product/12.1.0.2/dbhome_1:N
4.
Check
the RMAN backups (in CommVault)
wapexadbadm01:oracle>
rman target /
Recovery Manager: Release
12.1.0.2.0 - Production on Fri Aug 3 08:11:11 2018
Copyright (c) 1982, 2014, Oracle
and/or its affiliates. All rights
reserved.
connected to target database:
DWREP (DBID=1004551280)
RMAN> show all;
using target database control
file instead of recovery catalog
RMAN configuration parameters
for database with db_unique_name DWREP are:
CONFIGURE RETENTION POLICY TO
RECOVERY WINDOW OF 35 DAYS;
CONFIGURE BACKUP OPTIMIZATION
OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO
DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP
ON;
CONFIGURE CONTROLFILE AUTOBACKUP
FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP
FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE'
PARALLELISM 32 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES
FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES
FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP
COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP
COPIES FOR DEVICE TYPE SBT_TAPE 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 RMAN OUTPUT TO KEEP
FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION
POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE
NAME TO '+RECO/DWREP/snapshot/snapcf_DWREP1.f';
CONFIGURE SNAPSHOT CONTROLFILE
NAME TO '+RECO/dwrep/snapshot/snapcf_dwrep1.f';
Check the
controlfile, spfile, 70 DB files, and the archived logs, in the backup since
the last level 0 backup.
RMAN> list backup by file
completed after '27-JUL-18';
List of Datafile Backups
========================
File Key TY
LV S Ckp SCN Ckp Time
#Pieces #Copies Compressed Tag
---- ------- -
-- - ----------- --------- ------- ------- ---------- ---
1 186509 B
2 A 71294738805 02-AUG-18 1 1
YES TAG20180802T153108
186429
B 1 A 71286982774 01-AUG-18 1 1
YES TAG20180801T153124
186315 B
2 A 71277765507 31-JUL-18 1 1
YES TAG20180731T153103
186213 B
1 A 71224455617 30-JUL-18 1 1
YES TAG20180730T153133
186137
B 2 A 71156398403 29-JUL-18 1 1
YES TAG20180729T153055
186095 B
1 A 71152800647 28-JUL-18 1 1
YES TAG20180728T153114
186057 B
0 A 71151643743 27-JUL-18 1 1
YES TAG20180727T153109
2 186510 B
2 A 71294738802 02-AUG-18 1 1
YES TAG20180802T153108
186430 B
1 A 71286982767 01-AUG-18 1 1
YES TAG20180801T153124
186307 B
2 A 71277765504 31-JUL-18 1 1
YES TAG20180731T153103
186211 B
1 A 71224455274 30-JUL-18 1 1
YES TAG20180730T153133
186142 B
2 A 71156398346 29-JUL-18 1 1
YES TAG20180729T153055
186099 B
1 A 71152800645 28-JUL-18 1 1
YES TAG20180728T153114
186059 B
0 A 71151643741 27-JUL-18 1 1
YES TAG20180727T153109
…………
69 186518 B
2 A 71294738815 02-AUG-18 1 1
YES TAG20180802T153108
186434 B
1 A 71286982805 01-AUG-18 1 1
YES TAG20180801T153124
186310 B
2 A 71277765518 31-JUL-18 1 1
YES TAG20180731T153103
186217 B
1 A 71224456660 30-JUL-18 1 1
YES TAG20180730T153133
186141 B
2 A 71156398766 29-JUL-18 1 1
YES TAG20180729T153055
186102 B
1 A 71152800654 28-JUL-18 1 1
YES TAG20180728T153114
186058 B
0 A 71151643753 27-JUL-18 1 1
YES TAG20180727T153109
70 186508 B
2 A 71294738795 02-AUG-18 1 1
YES TAG20180802T153108
186426 B
1 A 71286982738 01-AUG-18 1 1
YES TAG20180801T153124
186306 B
2 A 71277765494 31-JUL-18 1 1
YES TAG20180731T153103
186212 B
1 A 71224454651 30-JUL-18 1 1
YES TAG20180730T153133
186138 B
2 A 71156398138 29-JUL-18 1 1
YES TAG20180729T153055
186103 B
1 A 71152800639 28-JUL-18 1 1
YES TAG20180728T153114
186063 B
0 A 71151643754 27-JUL-18 1 1
YES TAG20180727T153109
List of Archived Log Backups
============================
Thrd Seq Low
SCN Low Time BS
Key S #Pieces #Copies Compressed Tag
---- ------- ---------- ---------- ------- - -------
------- ---------- ---
1 1112107
71149845941 27-JUL-18 186042 A 1 1
YES TAG20180727T040345
1 1112108
71149868135 27-JUL-18 186045 A 1 1
YES TAG20180727T090322
1 1112109
71150347645 27-JUL-18 186049 A 1 1
YES TAG20180727T140311
1 1112110
71151636091 27-JUL-18 186079 A 1 1
YES TAG20180727T191254
1 1112111
71152617250 27-JUL-18 186081 A 1 1
YES TAG20180728T000254
1 1112112
71152669444 28-JUL-18 186085 A 1 1
YES TAG20180728T040334
1 1112113
71152691447 28-JUL-18 186087 A 1 1
YES TAG20180728T090255
1 1112114
71152739313 28-JUL-18 186090 A 1 1
YES TAG20180728T140254
1 1112115
71152779324 28-JUL-18 186118 A 1 1
YES TAG20180728T160319
1 1112116
71152803570 28-JUL-18 186121 A 1 1
YES TAG20180729T000258
1 1112117
71152884184 29-JUL-18 186124 A 1 1
YES TAG20180729T040314
…………
2 1147185
71287261682 01-AUG-18 186472 A 1 1
YES TAG20180802T000417
2 1147186
71287429548 01-AUG-18 186477 A 1 1
YES TAG20180802T000417
2 1147187
71287653109 02-AUG-18 186494 A 1 1
YES TAG20180802T040410
2 1147188
71290393537 02-AUG-18 186499 A 1 1
YES TAG20180802T090323
2 1147189
71290872316 02-AUG-18 186502 A 1 1
YES TAG20180802T140311
2 1147190
71293556416 02-AUG-18 186531 A 1 1
YES TAG20180802T160431
2 1147191
71295200079 02-AUG-18 186537 A 1 1
YES TAG20180803T000329
2 1147192
71296051850 02-AUG-18 186536 A 1 1
YES TAG20180803T000329
2 1147193
71296065790 03-AUG-18 186540 A 1 1
YES TAG20180803T040335
List of Control File Backups
============================
CF Ckp SCN Ckp
Time BS Key S #Pieces #Copies Compressed Tag
----------- --------- ------- - ------- -------
---------- ---
71296086915 03-AUG-18 186541 A 1
1 NO
TAG20180803T040455
71296066900 03-AUG-18 186538 A 1
1 NO TAG20180803T000602
71295202183 02-AUG-18 186533 A 1
1 NO TAG20180802T160546
…………
71152670022 28-JUL-18 186083 A 1
1 NO TAG20180728T000345
71152617526 27-JUL-18 186080 A 1
1 NO TAG20180727T191353
71151643767 27-JUL-18 186051 A 1
1 YES TAG20180727T153109
71151636395 27-JUL-18 186050 A 1
1 NO TAG20180727T140412
71150347936 27-JUL-18 186047 A 1
1 NO TAG20180727T090406
71149868685 27-JUL-18 186044 A 1
1 NO TAG20180727T040447
71149846668 27-JUL-18 186041 A 1
1 NO TAG20180727T000534
List of SPFILE Backups
======================
Modification Time BS Key S #Pieces #Copies Compressed Tag
----------------- ------- - ------- ------- ----------
---
30-JUL-18
186541 A 1 1
NO TAG20180803T040455
30-JUL-18 186538
A 1 1 NO TAG20180803T000602
…………
27-JUL-18
186083 A 1 1
NO TAG20180728T000345
27-JUL-18
186080 A 1 1
NO TAG20180727T191353
20-JUL-18
186050 A 1 1
NO TAG20180727T140412
20-JUL-18
186047 A 1 1
NO TAG20180727T090406
5.
Create
pfile for the duplicate DB
SQL> @db
DB_UniqueName Instance
DB_Role Open_Mode Host Started
-------------
------------ --------- ---------- ------------------ --------------
DWREP DWREP1 PRIMARY
READ WRITE wapexadbadm01
05:25 06-09-18
SQL> sho parameter pfile
NAME TYPE VALUE
------------------------------------
----------- ------------------------------
spfile string +DATA/dwrep/spfiledwrep.ora
SQL> create pfile='?/dbs/initDWREPDP.ora'
from spfile;
File created.
Edit $ORACLE_HOME/dbs/initDWREPDP.ora
to the following:
*.cluster_database=FALSE
DWREPDP.__db_cache_size=8959033344
DWREPDP.__java_pool_size=33554432
DWREPDP.__large_pool_size=704643072
DWREPDP.__oracle_base='/u01/app/oracle' #ORACLE_BASE set from environment
DWREPDP.__pga_aggregate_target=6006243328
DWREPDP.__sga_target=11173625856
DWREPDP.__shared_io_pool_size=0
DWREPDP.__shared_pool_size=1442840576
DWREPDP.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/DWREPDP/adump'
*.audit_trail='db'
*.compatible='11.2.0.2.0'
*.control_file_record_keep_time=90
*.control_files='+RECO'
*.db_block_size=8192
*.db_create_file_dest='+RECO'
*.db_create_online_log_dest_1='+RECO'
*.db_create_online_log_dest_2='+RECO'
*.db_domain=''
*.db_name='DWREPDP'
*.db_recovery_file_dest='+RECO'
*.db_recovery_file_dest_size=4147483648000
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP)
(SERVICE=DWREPDPXDB)'
*.java_jit_enabled=TRUE
*.log_archive_format='DWREPDP_arch_%t_%s_%r.dbf'
*.memory_target=17179869184
*.open_cursors=300
*.processes=300
*.remote_listener='wapexa-scan:1521'
*.remote_login_passwordfile='exclusive'
DWREPDP.instance_number=1
DWREPDP.thread=1
DWREPDP.undo_tablespace='UNDOTBS1'
6.
Run
RMAN duplicate
wapexadbadm01:oracle>
export ORACLE_SID=DWREPDP
wapexadbadm01:oracle>
sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0
Production on Fri Aug 3 11:07:03 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1.7180E+10 bytes
Fixed Size
5304248 bytes
Variable Size
8422162504 bytes
Database Buffers
8724152320 bytes
Redo Buffers
28250112 bytes
SQL> sho parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ----------
spfile string
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ----------
cell_offloadgroup_name string
db_file_name_convert string
db_name string DWREPDP
db_unique_name string DWREPDP
global_names boolean FALSE
instance_name
string DWREPDP
lock_name_space string
log_file_name_convert string
pdb_file_name_convert string
processor_group_name string
service_names string DWREPDP
wapexadbadm01:oracle> ps -ef | grep pmon |
grep -v grep
oracle 28350
1 0 11:07 ? 00:00:00 ora_pmon_DWREPDP
grid
168721 1 0 Jun09 ? 00:05:59 asm_pmon_+ASM1
oracle
169286 1 0 Jun09 ? 00:28:12 ora_pmon_dbfs1
oracle
169845 1 0 Jun09 ? 00:13:56 ora_pmon_DWREP1
oracle
169853 1 0 Jun09 ? 00:29:15 ora_pmon_DWPRD1
oracle
169855 1 0 Jun09 ? 00:16:27 ora_pmon_REPOEXA1
wapexadbadm01:oracle> rman
Recovery Manager: Release 12.1.0.2.0 - Production on Tue
Aug 3 14:32:49 2018
Copyright (c)
1982, 2014, Oracle and/or its affiliates.
All rights reserved.
RMAN> connect target sys/Ictwwc2t@dwrep1
connected to target database: DWREP (DBID=1004551280)
RMAN> connect auxiliary /
connected to auxiliary database: DWREPDP
(DBID=1752709701)
RMAN> spool log to DWREPDP_crt_080318.log
RMAN> duplicate target database to DWREPDP;
wapexadbadm01:oracle> tail -f /u01/app/oracle/admin/DWREPDP/pfile/DWREPDP_crt_080318.log
(The lengthy output shortened)
Spooling started in log file:
DWREPDP_crt_080318.log
Recovery
Manager12.1.0.2.0
Starting
Duplicate Db at 03-AUG-18
using
target database control file instead of recovery catalog
allocated
channel: ORA_AUX_SBT_TAPE_1
channel
ORA_AUX_SBT_TAPE_1: SID=362 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
…………
allocated
channel: ORA_AUX_SBT_TAPE_31
channel
ORA_AUX_SBT_TAPE_31: SID=333 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_31: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated
channel: ORA_AUX_SBT_TAPE_32
channel
ORA_AUX_SBT_TAPE_32: SID=348 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_32: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
current
log archived
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 17179869184 bytes
Fixed
Size 5304248 bytes
Variable
Size 8455716936 bytes
Database
Buffers 8690597888 bytes
Redo
Buffers 28250112 bytes
contents
of Memory Script:
{
sql clone "alter system set control_files =
''+RECO/DWREPDP/CONTROLFILE/current.89314.983188097''
comment=
''Set by RMAN'' scope=spfile";
sql clone "alter system set db_name =
''DWREP'' comment=
''Modified by RMAN duplicate''
scope=spfile";
sql clone "alter system set db_unique_name =
''DWREPDP'' 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 control_files
=
''+RECO/DWREPDP/CONTROLFILE/current.89314.983188097'' comment= ''Set by
RMAN'' scope=spfile
sql
statement: alter system set db_name
= ''DWREP'' comment= ''Modified by RMAN
duplicate'' scope=spfile
sql
statement: alter system set
db_unique_name = ''DWREPDP''
comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle
instance shut down
Oracle
instance started
Total
System Global Area 17179869184 bytes
Fixed
Size 5304248 bytes
Variable
Size 8455716936 bytes
Database
Buffers 8690597888 bytes
Redo
Buffers 28250112 bytes
Starting
restore at 03-AUG-18
allocated
channel: ORA_AUX_SBT_TAPE_1
channel
ORA_AUX_SBT_TAPE_1: SID=392 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=407 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_31
channel
ORA_AUX_SBT_TAPE_31: SID=348 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_31: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated
channel: ORA_AUX_SBT_TAPE_32
channel
ORA_AUX_SBT_TAPE_32: SID=363 device type=SBT_TAPE
channel
ORA_AUX_SBT_TAPE_32: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
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 c-1004551280-20180803-02
channel
ORA_AUX_SBT_TAPE_1: piece handle=c-1004551280-20180803-02
tag=TAG20180803T090429
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=+RECO/DWREPDP/CONTROLFILE/current.89314.983188097
Finished
restore at 03-AUG-18
database
mounted
contents
of Memory Script:
{
set until scn 71296471384;
sql clone 'alter database flashback off';
set newname for clone datafile 1 to new;
set newname for clone datafile 2 to new;
…………
set newname for clone datafile 69 to new;
set newname for clone datafile 70 to new;
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
Starting
restore at 03-AUG-18
using
channel ORA_AUX_SBT_TAPE_1
using
channel ORA_AUX_SBT_TAPE_2
…………
using
channel ORA_AUX_SBT_TAPE_31
using
channel ORA_AUX_SBT_TAPE_32
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 00026 to +RECO
channel
ORA_AUX_SBT_TAPE_1: restoring datafile 00048 to +RECO
channel
ORA_AUX_SBT_TAPE_1: reading from backup piece h1t92f26_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_2: restoring datafile 00004 to +RECO
channel
ORA_AUX_SBT_TAPE_2: restoring datafile 00020 to +RECO
channel
ORA_AUX_SBT_TAPE_2: restoring datafile 00042 to +RECO
channel
ORA_AUX_SBT_TAPE_2: reading from backup piece grt92f25_1_1
channel
ORA_AUX_SBT_TAPE_3: starting datafile backup set restore
channel
ORA_AUX_SBT_TAPE_3: specifying datafile(s) to restore from backup set
channel
ORA_AUX_SBT_TAPE_3: restoring datafile 00025 to +RECO
…………
channel
ORA_AUX_SBT_TAPE_31: starting datafile backup set restore
channel
ORA_AUX_SBT_TAPE_31: specifying datafile(s) to restore from backup set
channel
ORA_AUX_SBT_TAPE_31: restoring datafile 00059 to
+RECO/DWREPDP/DATAFILE/encrypt_dwrepusr_d.94706.983188339
channel
ORA_AUX_SBT_TAPE_31: restoring section 6 of 164
channel
ORA_AUX_SBT_TAPE_31: reading from backup piece g9t92f22_6_1
channel
ORA_AUX_SBT_TAPE_32: starting datafile backup set restore
channel
ORA_AUX_SBT_TAPE_32: specifying datafile(s) to restore from backup set
channel
ORA_AUX_SBT_TAPE_32: restoring datafile 00059 to
+RECO/DWREPDP/DATAFILE/encrypt_dwrepusr_d.94706.983188339
channel
ORA_AUX_SBT_TAPE_32: restoring section 7 of 164
channel
ORA_AUX_SBT_TAPE_32: reading from backup piece g9t92f22_7_1
…………
channel
ORA_AUX_SBT_TAPE_29: piece handle=gat92f22_69_1 tag=TAG20180727T153109
channel
ORA_AUX_SBT_TAPE_29: restored backup piece 69
channel
ORA_AUX_SBT_TAPE_29: restore complete, elapsed time: 00:34:24
channel
ORA_AUX_SBT_TAPE_20: piece handle=gat92f22_71_1 tag=TAG20180727T153109
channel
ORA_AUX_SBT_TAPE_20: restored backup piece 71
channel
ORA_AUX_SBT_TAPE_20: restore complete, elapsed time: 00:33:21
Finished
restore at 03-AUG-18
contents
of Memory Script:
{
switch clone datafile all;
}
executing
Memory Script
datafile
1 switched to datafile copy
input
datafile copy RECID=73 STAMP=983208117 file
name=+RECO/DWREPDP/DATAFILE/system.71998.983188377
datafile
2 switched to datafile copy
input
datafile copy RECID=74 STAMP=983208117 file
name=+RECO/DWREPDP/DATAFILE/sysaux.65838.983188377
…………
datafile
69 switched to datafile copy
input
datafile copy RECID=141 STAMP=983208131 file
name=+RECO/DWREPDP/DATAFILE/encrypt_stateuser_d.44652.983188377
datafile
70 switched to datafile copy
input
datafile copy RECID=142 STAMP=983208131 file name=+RECO/DWREPDP/DATAFILE/encrypt_cnsi_user_mtnc.33936.983188377
contents
of Memory Script:
{
set until scn 71296471384;
recover
clone database
delete archivelog
;
}
executing
Memory Script
executing
command: SET until clause
Starting
recover at 03-AUG-18
using
channel ORA_AUX_SBT_TAPE_1
using
channel ORA_AUX_SBT_TAPE_2
…………
using
channel ORA_AUX_SBT_TAPE_31
using
channel ORA_AUX_SBT_TAPE_32
channel
ORA_AUX_SBT_TAPE_1: starting incremental datafile backup set restore
channel
ORA_AUX_SBT_TAPE_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00006: +RECO/DWREPDP/DATAFILE/dwrepusr_d.8563.983188369
destination
for restore of datafile 00026:
+RECO/DWREPDP/DATAFILE/dwrepusr_d.84128.983188339
destination
for restore of datafile 00048:
+RECO/DWREPDP/DATAFILE/dwrepusr_d.66403.983188341
channel
ORA_AUX_SBT_TAPE_1: reading from backup piece p2t953ea_1_1
channel
ORA_AUX_SBT_TAPE_2: starting incremental datafile backup set restore
channel
ORA_AUX_SBT_TAPE_2: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00001: +RECO/DWREPDP/DATAFILE/system.71998.983188377
destination
for restore of datafile 00021:
+RECO/DWREPDP/DATAFILE/dwrepusr_d.66258.983188369
destination
for restore of datafile 00041:
+RECO/DWREPDP/DATAFILE/dwrepusr_d.91171.983188373
…………
channel
ORA_AUX_SBT_TAPE_23: reading from backup piece p1t953ea_1_1
channel
ORA_AUX_SBT_TAPE_24: starting incremental datafile backup set restore
channel
ORA_AUX_SBT_TAPE_24: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00059:
+RECO/DWREPDP/DATAFILE/encrypt_dwrepusr_d.94706.983188339
channel
ORA_AUX_SBT_TAPE_24: reading from backup piece p0t953ea_1_1
…………
channel
ORA_AUX_SBT_TAPE_1: reading from backup piece 5ut9i9a7_1_1
channel
ORA_AUX_SBT_TAPE_1: piece handle=5ut9i9a7_1_1 tag=TAG20180802T153108
channel
ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel
ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:03
starting
media recovery
archived
log for thread 1 with sequence 1112361 is already on disk as file
+RECO/DWREP/ARCHIVELOG/2018_08_02/thread_1_seq_1112361.73030.983116995
archived
log for thread 1 with sequence 1112362 is already on disk as file
+RECO/DWREP/ARCHIVELOG/2018_08_02/thread_1_seq_1112362.71654.983129621
archived
log for thread 1 with sequence 1112363 is already on disk as file
+RECO/DWREP/ARCHIVELOG/2018_08_03/thread_1_seq_1112363.97526.983145665
archived
log for thread 1 with sequence 1112364 is already on disk as file
+RECO/DWREP/ARCHIVELOG/2018_08_03/thread_1_seq_1112364.35497.983160065
archived
log for thread 1 with sequence 1112365 is already on disk as file
+RECO/DWREP/ARCHIVELOG/2018_08_03/thread_1_seq_1112365.7457.983178065
archived
log for thread 1 with sequence 1112366 is already on disk as file
+RECO/DWREP/ARCHIVELOG/2018_08_03/thread_1_seq_1112366.80030.983188037
archived
log for thread 2 with sequence 1147190 is already on disk as file
+RECO/DWREP/ARCHIVELOG/2018_08_02/thread_2_seq_1147190.81649.983116995
archived
log for thread 2 with sequence 1147191 is already on disk as file
+RECO/DWREP/ARCHIVELOG/2018_08_02/thread_2_seq_1147191.84640.983141301
archived
log for thread 2 with sequence 1147192 is already on disk as file
+RECO/DWREP/ARCHIVELOG/2018_08_03/thread_2_seq_1147192.80974.983145665
archived
log for thread 2 with sequence 1147193 is already on disk as file
+RECO/DWREP/ARCHIVELOG/2018_08_03/thread_2_seq_1147193.79793.983160067
archived
log for thread 2 with sequence 1147194 is already on disk as file
+RECO/DWREP/ARCHIVELOG/2018_08_03/thread_2_seq_1147194.87628.983178065
archived
log for thread 2 with sequence 1147195 is already on disk as file
+RECO/DWREP/ARCHIVELOG/2018_08_03/thread_2_seq_1147195.40615.983188039
archived
log file name=+RECO/DWREP/ARCHIVELOG/2018_08_02/thread_2_seq_1147190.81649.983116995
thread=2 sequence=1147190
archived
log file
name=+RECO/DWREP/ARCHIVELOG/2018_08_02/thread_1_seq_1112361.73030.983116995
thread=1 sequence=1112361
archived
log file name=+RECO/DWREP/ARCHIVELOG/2018_08_02/thread_1_seq_1112362.71654.983129621
thread=1 sequence=1112362
archived
log file
name=+RECO/DWREP/ARCHIVELOG/2018_08_02/thread_2_seq_1147191.84640.983141301
thread=2 sequence=1147191
archived
log file
name=+RECO/DWREP/ARCHIVELOG/2018_08_03/thread_1_seq_1112363.97526.983145665
thread=1 sequence=1112363
archived
log file
name=+RECO/DWREP/ARCHIVELOG/2018_08_03/thread_2_seq_1147192.80974.983145665
thread=2 sequence=1147192
archived
log file
name=+RECO/DWREP/ARCHIVELOG/2018_08_03/thread_2_seq_1147193.79793.983160067
thread=2 sequence=1147193
archived
log file
name=+RECO/DWREP/ARCHIVELOG/2018_08_03/thread_1_seq_1112364.35497.983160065
thread=1 sequence=1112364
archived
log file
name=+RECO/DWREP/ARCHIVELOG/2018_08_03/thread_1_seq_1112365.7457.983178065
thread=1 sequence=1112365
archived
log file
name=+RECO/DWREP/ARCHIVELOG/2018_08_03/thread_2_seq_1147194.87628.983178065
thread=2 sequence=1147194
archived
log file
name=+RECO/DWREP/ARCHIVELOG/2018_08_03/thread_2_seq_1147195.40615.983188039
thread=2 sequence=1147195
archived
log file name=+RECO/DWREP/ARCHIVELOG/2018_08_03/thread_1_seq_1112366.80030.983188037
thread=1 sequence=1112366
media
recovery complete, elapsed time: 00:00:43
Finished
recover at 03-AUG-18
Oracle
instance started
Total
System Global Area 17179869184 bytes
Fixed
Size 5304248 bytes
Variable
Size 8455716936 bytes
Database
Buffers 8690597888 bytes
Redo
Buffers 28250112 bytes
contents
of Memory Script:
{
sql clone "alter system set db_name =
''DWREPDP'' comment=
''Reset to original value by RMAN''
scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
}
executing
Memory Script
sql
statement: alter system set db_name
= ''DWREPDP'' comment= ''Reset to
original value by RMAN'' scope=spfile
sql
statement: alter system reset
db_unique_name scope=spfile
Oracle
instance started
Total
System Global Area 17179869184 bytes
Fixed
Size 5304248 bytes
Variable
Size 8455716936 bytes
Database
Buffers 8690597888 bytes
Redo
Buffers 28250112 bytes
sql
statement: CREATE CONTROLFILE REUSE SET DATABASE "DWREPDP" RESETLOGS
ARCHIVELOG
MAXLOGFILES
192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 373760
LOGFILE
GROUP
1 SIZE 4 G ,
GROUP
2 SIZE 4 G
DATAFILE
'+RECO/DWREPDP/DATAFILE/system.71998.983188377'
CHARACTER SET WE8MSWIN1252
sql
statement: ALTER DATABASE ADD LOGFILE
INSTANCE 'i2'
GROUP
3 SIZE 4 G ,
GROUP
4 SIZE 4 G
contents
of Memory Script:
{
set newname for clone tempfile 1 to new;
set newname for clone tempfile 2 to new;
…………
set newname for clone tempfile 17 to new;
set newname for clone tempfile 18 to new;
switch clone tempfile all;
catalog clone datafilecopy
"+RECO/DWREPDP/DATAFILE/sysaux.65838.983188377",
"+RECO/DWREPDP/DATAFILE/undotbs1.9617.983188369",
"+RECO/DWREPDP/DATAFILE/users.25723.983188353",
"+RECO/DWREPDP/DATAFILE/undotbs2.66514.983188371",
"+RECO/DWREPDP/DATAFILE/dwrepusr_d.8563.983188369",
…………
"+RECO/DWREPDP/DATAFILE/dwrepusr_d.3134.983188377",
"+RECO/DWREPDP/DATAFILE/dev_mds.62246.983188377",
"+RECO/DWREPDP/DATAFILE/dev_biplatform.27507.983188377",
"+RECO/DWREPDP/DATAFILE/encrypt_dwrepusr_d.94706.983188339",
"+RECO/DWREPDP/DATAFILE/encrypt_odsdm_1.28136.983188339",
"+RECO/DWREPDP/DATAFILE/encrypt_odsdmstg_1.32091.983188377",
"+RECO/DWREPDP/DATAFILE/undotbs1.15003.983188377",
"+RECO/DWREPDP/DATAFILE/undotbs1.80520.983188377",
"+RECO/DWREPDP/DATAFILE/undotbs1.92380.983188379",
"+RECO/DWREPDP/DATAFILE/undotbs2.44579.983188377",
"+RECO/DWREPDP/DATAFILE/undotbs2.69902.983188377",
"+RECO/DWREPDP/DATAFILE/undotbs2.77418.983188377",
"+RECO/DWREPDP/DATAFILE/encrypt_hca_usr.94443.983188377",
"+RECO/DWREPDP/DATAFILE/encrypt_stateuser_d.44652.983188377",
"+RECO/DWREPDP/DATAFILE/encrypt_cnsi_user_mtnc.33936.983188377";
switch clone datafile all;
}
executing
Memory Script
executing
command: SET NEWNAME
executing
command: SET NEWNAME
…………
executing
command: SET NEWNAME
executing
command: SET NEWNAME
renamed
tempfile 1 to +RECO in control file
renamed
tempfile 2 to +RECO in control file
…………
renamed
tempfile 17 to +RECO in control file
renamed
tempfile 18 to +RECO in control file
cataloged
datafile copy
datafile
copy file name=+RECO/DWREPDP/DATAFILE/sysaux.65838.983188377 RECID=1
STAMP=983213640
cataloged
datafile copy
datafile
copy file name=+RECO/DWREPDP/DATAFILE/undotbs1.9617.983188369 RECID=2
STAMP=983213640
cataloged
datafile copy
…………
cataloged
datafile copy
datafile
copy file name=+RECO/DWREPDP/DATAFILE/encrypt_stateuser_d.44652.983188377
RECID=68 STAMP=983213642
cataloged
datafile copy
datafile
copy file name=+RECO/DWREPDP/DATAFILE/encrypt_cnsi_user_mtnc.33936.983188377
RECID=69 STAMP=983213642
datafile
2 switched to datafile copy
input
datafile copy RECID=1 STAMP=983213640 file
name=+RECO/DWREPDP/DATAFILE/sysaux.65838.983188377
datafile
3 switched to datafile copy
input
datafile copy RECID=2 STAMP=983213640 file
name=+RECO/DWREPDP/DATAFILE/undotbs1.9617.983188369
…………
datafile
69 switched to datafile copy
input
datafile copy RECID=68 STAMP=983213642 file
name=+RECO/DWREPDP/DATAFILE/encrypt_stateuser_d.44652.983188377
datafile
70 switched to datafile copy
input
datafile copy RECID=69 STAMP=983213642 file name=+RECO/DWREPDP/DATAFILE/encrypt_cnsi_user_mtnc.33936.983188377
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
Cannot
remove created server parameter file
Finished
Duplicate Db at 03-AUG-18
7.
Check the duplicate database
7.1.
Directories / files created in the ASM disk group for the duplicate DB
wapexadbadm01:grid> asmcmd ls -l reco
Type Redund Striped
Time Sys
Name
Y ASM/
Y DBFS/
Y DWPRD/
Y DWREP/
Y DWREPDP/
Y REPOEXA/
PASSWORD HIGH
COARSE AUG 03 20:00:00 N
orapwdwrepdp => +RECO/DWREPDP/PASSWORD/pwddwrepdp.42393.983220181
PARAMETERFILE MIRROR
COARSE AUG 04 13:00:00 N
spfiledwrepdp.ora =>
+RECO/DB_UNKNOWN/PARAMETERFILE/SPFILE.97691.983219757
wapexadbadm01:grid> asmcmd ls -l reco/dwrepdp/*
Type Redund
Striped Time Sys Name
+reco/dwrepdp/CONTROLFILE/:
CONTROLFILE HIGH
FINE AUG 03 18:00:00 Y
Current.89314.983188097
+reco/dwrepdp/DATAFILE/:
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DEV_BIPLATFORM.27507.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DEV_MDS.62246.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.11681.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.12265.983188373
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.16061.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.16398.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.21560.983188351
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.21756.983188373
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.25031.983188379
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.26216.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.26638.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.3134.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.31625.983188373
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.31757.983188373
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.39212.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.39237.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.4183.983188375
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.43400.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.45440.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.45594.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.46604.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.62238.983188371
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.62534.983188373
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.63526.983188375
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.640.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.64026.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.65916.983188375
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.66258.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.66403.983188341
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.66568.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.67555.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.67719.983188375
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.68865.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.69609.983188373
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.69967.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.70575.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.72304.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.74589.983188373
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.76523.983188375
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.76553.983188353
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.80518.983188375
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.82110.983188371
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.83473.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.84128.983188339
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.84406.983188375
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.84787.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.8563.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.8660.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.87254.983188375
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.87606.983188373
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.90779.983188373
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.91171.983188373
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
DWREPUSR_D.97245.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
ENCRYPT_CNSI_USER_MTNC.33936.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
ENCRYPT_DWREPUSR_D.94706.983188339
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
ENCRYPT_HCA_USR.94443.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
ENCRYPT_ODSDMSTG_1.32091.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
ENCRYPT_ODSDM_1.28136.983188339
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
ENCRYPT_STATEUSER_D.44652.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
SYSAUX.65838.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
SYSTEM.71998.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
UNDOTBS1.15003.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
UNDOTBS1.80520.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
UNDOTBS1.92380.983188379
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
UNDOTBS1.9617.983188369
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
UNDOTBS2.44579.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
UNDOTBS2.66514.983188371
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
UNDOTBS2.69902.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
UNDOTBS2.77418.983188377
DATAFILE MIRROR
COARSE AUG 03 18:00:00 Y
USERS.25723.983188353
+reco/dwrepdp/FLASHBACK/:
FLASHBACK MIRROR
COARSE AUG 03 19:00:00 Y
log_1.57945.983213681
FLASHBACK MIRROR
COARSE AUG 03 18:00:00 Y
log_2.81835.983213695
+reco/dwrepdp/ONLINELOG/:
ONLINELOG MIRROR
COARSE AUG 03 18:00:00 Y
group_1.35718.983213647
ONLINELOG MIRROR
COARSE AUG 03 18:00:00 Y
group_1.95959.983213647
ONLINELOG MIRROR
COARSE AUG 03 18:00:00 Y
group_2.20672.983213649
ONLINELOG MIRROR
COARSE AUG 03 18:00:00 Y
group_2.41764.983213649
ONLINELOG MIRROR
COARSE AUG 03 18:00:00 Y
group_3.78425.983213637
ONLINELOG MIRROR
COARSE AUG 03 18:00:00 Y
group_3.9229.983213635
ONLINELOG MIRROR
COARSE AUG 03 18:00:00 Y
group_4.49876.983213637
ONLINELOG MIRROR
COARSE AUG 03 18:00:00 Y
group_4.97691.983213639
+reco/dwrepdp/TEMPFILE/:
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
DEV_IAS_TEMP.37081.983213667
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
TEMP.10116.983213659
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
TEMP.10587.983213657
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
TEMP.13706.983213667
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
TEMP.15853.983213661
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
TEMP.36534.983213665
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
TEMP.42946.983213663
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y TEMP.5152.983213665
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
TEMP.58981.983213655
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
TEMP.63798.983213663
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
TEMP.69510.983213661
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
TEMP.71616.983213659
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
TEMP.73625.983213663
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
TEMP.78882.983213661
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
TEMP.88179.983213655
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
TEMP.90247.983213653
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
TEMP.92594.983213657
TEMPFILE MIRROR
COARSE AUG 03 18:00:00 Y
TEMP.96489.983213667
7.2.
Space used
in ASM for the duplicate DB
wapexadbadm01:grid> asmcmd du data/dwrep/datafile
Used_MB Mirror_used_MB
8711912 17423824
wapexadbadm01:grid>
asmcmd du reco/dwrepdp/datafile
Used_MB Mirror_used_MB
8711912 17423824
7.3.
DB files
and size in the duplicate DB
SQL> select db_unique_name, instance_name, host_name, open_mode,
to_char(startup_time,'HH24:MI, mm-dd-yy') started from v$database, v$instance;
DB_UNIQUE_NAME
Instance HOST_NAME Open_Mode Started
-------------- ---------
-------------- ----------- ---------------
DWREPDP DWREPDP1 wapexadbadm01
READ WRITE 18:53, 08-03-18
SQL> @dbsize_file
ID TS_Name /
FileClass Filename
SizeGB
---
----------------------
-------------------------------------------------------------- ---------
1 SYSTEM
+RECO/DWREPDP/DATAFILE/system.71998.983188377 2.93
2 SYSAUX
+RECO/DWREPDP/DATAFILE/sysaux.65838.983188377 3.81
3 UNDOTBS1
+RECO/DWREPDP/DATAFILE/undotbs1.9617.983188369 30.00
4 USERS
+RECO/DWREPDP/DATAFILE/users.25723.983188353 1.00
5 UNDOTBS2 +RECO/DWREPDP/DATAFILE/undotbs2.66514.983188371 30.00
6 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.8563.983188369 24.00
7 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.64026.983188369 24.00
8 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.97245.983188369 24.00
9 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.70575.983188369 24.00
10 DWREPUSR_D +RECO/DWREPDP/DATAFILE/dwrepusr_d.45594.983188369 24.00
11 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.11681.983188369 24.00
12 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.43400.983188369 24.00
13 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.67555.983188369 24.00
14 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.83473.983188369 24.00
15 DWREPUSR_D +RECO/DWREPDP/DATAFILE/dwrepusr_d.8660.983188369 24.00
16 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.66568.983188369 24.00
17 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.46604.983188369 24.00
18 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.640.983188369 24.00
19 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.68865.983188369 24.00
20 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.21560.983188351 24.00
21 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.66258.983188369 24.00
22 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.39237.983188369 24.00
23 DWREPUSR_D +RECO/DWREPDP/DATAFILE/dwrepusr_d.45440.983188369 24.00
24 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.16061.983188369 24.00
25 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.72304.983188369 24.00
26 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.84128.983188339 24.00
27 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.26638.983188369 24.00
28 DWREPUSR_D +RECO/DWREPDP/DATAFILE/dwrepusr_d.67719.983188375 24.00
29 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.80518.983188375 24.00
30 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.74589.983188373 24.00
31 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.87606.983188373 24.00
32 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.84406.983188375 24.00
33 DWREPUSR_D +RECO/DWREPDP/DATAFILE/dwrepusr_d.87254.983188375 24.00
34 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.63526.983188375 24.00
35 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.76523.983188375 24.00
36 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.65916.983188375 24.00
37 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.4183.983188375 24.00
38 DWREPUSR_D +RECO/DWREPDP/DATAFILE/dwrepusr_d.31757.983188373 24.00
39 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.62238.983188371 24.00
40 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.12265.983188373 24.00
41 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.91171.983188373 24.00
42 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.76553.983188353 24.00
43 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.90779.983188373 24.00
44 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.62534.983188373 24.00
45 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.69609.983188373 24.00
46 DWREPUSR_D +RECO/DWREPDP/DATAFILE/dwrepusr_d.21756.983188373 24.00
47 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.82110.983188371 24.00
48 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.66403.983188341 24.00
49 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.31625.983188373 24.00
50 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.84787.983188377 24.00
51 DWREPUSR_D +RECO/DWREPDP/DATAFILE/dwrepusr_d.69967.983188377 24.00
52 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.16398.983188377 24.00
53 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.25031.983188379 24.00
54 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.39212.983188377 24.00
55 DWREPUSR_D
+RECO/DWREPDP/DATAFILE/dwrepusr_d.26216.983188377 24.00
56 DWREPUSR_D +RECO/DWREPDP/DATAFILE/dwrepusr_d.3134.983188377 24.00
57 DEV_MDS
+RECO/DWREPDP/DATAFILE/dev_mds.62246.983188377 .10
58 DEV_BIPLATFORM
+RECO/DWREPDP/DATAFILE/dev_biplatform.27507.983188377 .06
59 ENCRYPT_DWREPUSR_D
+RECO/DWREPDP/DATAFILE/encrypt_dwrepusr_d.94706.983188339 4,920.00
60 ENCRYPT_ODSDM_1
+RECO/DWREPDP/DATAFILE/encrypt_odsdm_1.28136.983188339 2,249.00
61 ENCRYPT_ODSDMSTG_1 +RECO/DWREPDP/DATAFILE/encrypt_odsdmstg_1.32091.983188377 2.00
62 UNDOTBS1
+RECO/DWREPDP/DATAFILE/undotbs1.15003.983188377 2.42
63 UNDOTBS1
+RECO/DWREPDP/DATAFILE/undotbs1.80520.983188377 9.00
64 UNDOTBS1 +RECO/DWREPDP/DATAFILE/undotbs1.92380.983188379 9.00
65 UNDOTBS2
+RECO/DWREPDP/DATAFILE/undotbs2.44579.983188377 8.00
66 UNDOTBS2
+RECO/DWREPDP/DATAFILE/undotbs2.69902.983188377 6.00
67 UNDOTBS2
+RECO/DWREPDP/DATAFILE/undotbs2.77418.983188377 7.00
68 ENCRYPT_HCA_USR
+RECO/DWREPDP/DATAFILE/encrypt_hca_usr.94443.983188377 .49
69 ENCRYPT_STATEUSER_D +RECO/DWREPDP/DATAFILE/encrypt_stateuser_d.44652.983188377 1.00
70 ENCRYPT_CNSI_USER_MTNC
+RECO/DWREPDP/DATAFILE/encrypt_cnsi_user_mtnc.33936.983188377 1.00
DEV_IAS_TEMP
+RECO/DWREPDP/TEMPFILE/dev_ias_temp.37081.983213667 .10
TEMP
+RECO/DWREPDP/TEMPFILE/temp.10116.983213659 29.00
TEMP
+RECO/DWREPDP/TEMPFILE/temp.10587.983213657 29.00
TEMP +RECO/DWREPDP/TEMPFILE/temp.13706.983213667 29.00
TEMP
+RECO/DWREPDP/TEMPFILE/temp.15853.983213661 29.00
TEMP
+RECO/DWREPDP/TEMPFILE/temp.36534.983213665 29.00
TEMP
+RECO/DWREPDP/TEMPFILE/temp.42946.983213663 29.00
TEMP
+RECO/DWREPDP/TEMPFILE/temp.5152.983213665 29.00
TEMP +RECO/DWREPDP/TEMPFILE/temp.58981.983213655 29.00
TEMP
+RECO/DWREPDP/TEMPFILE/temp.63798.983213663 29.00
TEMP
+RECO/DWREPDP/TEMPFILE/temp.69510.983213661 29.00
TEMP
+RECO/DWREPDP/TEMPFILE/temp.71616.983213659 29.00
TEMP
+RECO/DWREPDP/TEMPFILE/temp.73625.983213663 29.00
TEMP
+RECO/DWREPDP/TEMPFILE/temp.78882.983213661 29.00
TEMP
+RECO/DWREPDP/TEMPFILE/temp.88179.983213655 29.00
TEMP
+RECO/DWREPDP/TEMPFILE/temp.90247.983213653 29.00
TEMP +RECO/DWREPDP/TEMPFILE/temp.92594.983213657 29.00
TEMP
+RECO/DWREPDP/TEMPFILE/temp.96489.983213667 29.00
[CONTROL FILE]
+RECO/DWREPDP/CONTROLFILE/current.89314.983188097
[ONLINE REDO LOG]
+RECO/DWREPDP/ONLINELOG/group_1.35718.983213647 4.00
[ONLINE REDO LOG]
+RECO/DWREPDP/ONLINELOG/group_1.95959.983213647 4.00
[ONLINE REDO LOG] +RECO/DWREPDP/ONLINELOG/group_2.20672.983213649 4.00
[ONLINE REDO LOG]
+RECO/DWREPDP/ONLINELOG/group_2.41764.983213649 4.00
[ONLINE REDO LOG]
+RECO/DWREPDP/ONLINELOG/group_5.49876.983219869 4.00
[ONLINE REDO LOG]
+RECO/DWREPDP/ONLINELOG/group_5.78425.983219871 4.00
[ONLINE REDO LOG]
+RECO/DWREPDP/ONLINELOG/group_6.68409.983219873 4.00
[ONLINE REDO LOG]
+RECO/DWREPDP/ONLINELOG/group_6.9229.983219871 4.00
---------
sum 9,031.91
97 rows selected.
8.
Convert the single instance duplicate DB to
RAC
wapexadbadm01:oracle> cp
$ORACLE_HOME/assistants/rconfig/sampleXMLs/ConvertToRAC_AdminManaged.xml
$ORACLE_BASE/admin/DWREPDP/pfile/DWREPDP_2_RAC.xml
wapexadbadm01:oracle> vi
$ORACLE_BASE/admin/DWREPDP/pfile/DWREPDP_2_RAC.xml
(Set
Convert verify="ONLY" to
check first)
<?xml
version="1.0" encoding="UTF-8"?>
<n:RConfig
xmlns:n="http://www.oracle.com/rconfig"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.oracle.com/rconfig
rconfig.xsd">
<n:ConvertToRAC>
<!--
Verify does a precheck to ensure all pre-requisites are met, before the
conversion is attempted. Allowable values are: YES|NO|ONLY -->
<n:Convert verify="ONLY">
<!--Specify
current OracleHome of non-rac database for SourceDBHome -->
<n:SourceDBHome>/u01/app/oracle/product/12.1.0.2/dbhome_1</n:SourceDBHome>
<!--Specify
OracleHome where the rac database should be configured. It can be same as
SourceDBHome -->
<n:TargetDBHome>/u01/app/oracle/product/12.1.0.2/dbhome_1</n:TargetDBHome>
<!--Specify
SID of non-rac database and credential. User with sysdba role is required to
perform conversion -->
<n:SourceDBInfo SID="DWREPDP">
<n:Credentials>
<n:User>sys</n:User>
<n:Password>xxxxxx</n:Password>
<n:Role>sysdba</n:Role>
</n:Credentials>
<!--Specify
Windows Secure Oracle Home Credentials if the Oracle Home was installed with
Secure User option -->
<!--
<n:Credentials>
<n:User>UserDomain\SecureHomeUserName</n:User>
<n:Password>oracle</n:Password>
<n:Role>windows_svc</n:Role>
</n:Credentials>
-->
</n:SourceDBInfo>
<!--Specify
the list of nodes that should have rac instances running for the Admin Managed
Cluster Database. LocalNode should be the first node in this nodelist. -->
<n:NodeList>
<n:Node name="wapexadbadm01"/>
<n:Node name="wapexadbadm02"/>
</n:NodeList>
<!--Specify
RacOneNode along with servicename to convert database to RACOne Node -->
<!--n:RacOneNode
servicename="salesrac1service"/-->
<!--Instance
Prefix tag is optional starting with 11.2. If left empty, it is derived from
db_unique_name.-->
<n:InstancePrefix>DWREPDP</n:InstancePrefix>
<!--
Listener details are no longer needed starting 11.2. Database is registered
with default listener and SCAN listener running from Oracle Grid Infrastructure
home. -->
<!--Specify
the type of storage to be used by rac database. Allowable values are CFS|ASM.
The non-rac database should have same storage type. ASM credentials are no
needed for conversion. -->
<n:SharedStorage type="ASM">
<!--Specify
Database Area Location to be configured for rac database.If this field is left
empty, current storage will be used for rac database. For CFS, this field will
have directory path. -->
<n:TargetDatabaseArea>+RECO</n:TargetDatabaseArea>
<!--Specify
Fast Recovery Area to be configured for rac database. If this field is left
empty, current recovery area of non-rac database will be configured for rac
database. If current database is not using recovery Area, the resulting rac
database will not have a recovery area. -->
<n:TargetFlashRecoveryArea>+RECO</n:TargetFlashRecoveryArea>
</n:SharedStorage>
</n:Convert>
</n:ConvertToRAC>
</n:RConfig>
wapexadbadm01:oracle> cd $ORACLE_BASE/admin/DWREPDP/pfile
wapexadbadm01:oracle> rconfig ./DWREPDP_2_RAC.xml
<?xml
version="1.0" ?>
<RConfig
version="1.1" >
<ConvertToRAC>
<Convert>
<Result
code="0" >
Operation
Succeeded
</Result>
</Response>
<ReturnValue type="object">
There is no return value for this step </ReturnValue>
</Convert>
</ConvertToRAC></RConfig>
Change Convert
verify="ONLY" to Convert verify="YES" in the .xml file for actual DB conversion.
wapexadbadm01:oracle>
rconfig ./DWREPDP_2_RAC.xml
Converting Database "DWREPDP" to Cluster
Database.
Target Oracle Home:
/u01/app/oracle/product/12.1.0.2/dbhome_1.
Database Role: PRIMARY.
Setting Data Files and Control Files
Adding Trace files
Adding Database Instances
Adding Redo Logs
Enabling threads for all Database Instances
Setting TEMP tablespace
Adding UNDO tablespaces
Setting Fast Recovery Area
Updating Oratab
Creating Password file(s)
Configuring related CRS resources
Starting Cluster Database
<?xml version="1.0" ?>
<RConfig version="1.1" >
<ConvertToRAC>
<Convert>
<Response>
<Result
code="0" >
Operation Succeeded
</Result>
</Response>
<ReturnValue
type="object">
<Oracle_Home>
/u01/app/oracle/product/11.2.0/dbhome_1
</Oracle_Home>
<Database type ="ADMIN_MANAGED"
>
<InstanceList>
<Instance SID="DWREPDP1"
Node="wapexadbadm01" >
</Instance>
<Instance SID="DWREPDP2"
Node="wapexadbadm02" >
</Instance>
</InstanceList>
</Database>
</ReturnValue>
</Convert>
</ConvertToRAC></RConfig>
9.
Verify the duplicate DB is converted to
2-node RAC DB
wapexadbadm01:grid> crsctl stat res -t
posted by Kyle H @ August 08, 2018
0 Comments
