{"id":17167,"date":"2022-04-07T15:32:41","date_gmt":"2022-04-07T13:32:41","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/"},"modified":"2023-06-20T10:13:47","modified_gmt":"2023-06-20T08:13:47","slug":"active-duplicate-from-standby-database","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/","title":{"rendered":"Active Duplicate from standby database"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

Generally we do active duplicate from primary database, but I think it should be fine to see what happen if we do active duplicate a database from a standby database. So, I do some tests and I write the results in this blog<\/p>\n

Below the actual configuration of my Data Guard environment<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
DGMGRL> show configuration<\/code><\/div>\n
<\/div>\n
Configuration - db21<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxPerformance<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>DB21_SITE1 - <\/code>Primary<\/code> database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>DB21_SITE2 - Physical standby <\/code>database<\/code><\/div>\n
<\/div>\n
Fast-Start Failover:\u00a0 Disabled<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
SUCCESS\u00a0\u00a0 (status updated 35 seconds ago)<\/code><\/div>\n
<\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The tests are done with Oracle 21c but I guess it should work for 19c<\/p>\n

Standby in Read Only Mode <\/strong><\/p>\n

The first tests I do is with the standby opened in read only mode<\/p>\n

If you do not have Active Data Duard license stop the apply process before opening the database in Read Only mode<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
oracle@oraadserver2:<\/code>\/home\/oracle\/<\/code> [DB21 (CDB$ROOT)] DB21<\/code><\/div>\n
********* dbi services Ltd. *********<\/code><\/div>\n
STATUS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : OPEN<\/code><\/div>\n
DB_UNIQUE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : DB21_SITE2<\/code><\/div>\n
OPEN_MODE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : READ ONLY<\/code><\/div>\n
LOG_MODE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : ARCHIVELOG<\/code><\/div>\n
DATABASE_ROLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : PHYSICAL STANDBY<\/code><\/div>\n
FLASHBACK_ON\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : YES<\/code><\/div>\n
FORCE_LOGGING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : YES<\/code><\/div>\n
VERSION\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 21.0.0.0.0<\/code><\/div>\n
CDB Enabled\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : YES<\/code><\/div>\n
List PDB(s)\u00a0\u00a0\u00a0 MOUNTED : PDB1, PDB2, PDB3<\/code><\/div>\n
List PDB(s)\u00a0 READ ONLY : PDB$SEED<\/code><\/div>\n
*************************************<\/code><\/div>\n
oracle@oraadserver2:<\/code>\/home\/oracle\/<\/code> [DB21 (CDB$ROOT)]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The goal is to duplicate the standby database DB21_SITE2 to DB21CLNE to a remote server. I assume that all network files are already configured. Password file, spfile are also already configured.<\/p>\n

From the source server<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n<\/td>\n
\n
\n
oracle@oraadserver2:<\/code>\/home\/oracle\/<\/code> [DB21 (CDB$ROOT)] tnsping db21_site2<\/code><\/div>\n
<\/div>\n
TNS Ping Utility <\/code>for<\/code> Linux: Version 21.0.0.0.0 - Production on 06-APR-2022 13:29:59<\/code><\/div>\n
<\/div>\n
Copyright (c) 1997, 2020, Oracle.\u00a0 All rights reserved.<\/code><\/div>\n
<\/div>\n
Used parameter files:<\/code><\/div>\n
\/u01\/app\/oracle\/network\/admin\/sqlnet<\/code>.ora<\/code><\/div>\n
<\/div>\n
<\/div>\n
Used TNSNAMES adapter to resolve the <\/code>alias<\/code><\/div>\n
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oraadserver2)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = DB21_SITE2_DGMGRL)))<\/code><\/div>\n
OK (0 msec)<\/code><\/div>\n
oracle@oraadserver2:<\/code>\/home\/oracle\/<\/code> [DB21 (CDB$ROOT)] tnsping db21clne<\/code><\/div>\n
<\/div>\n
TNS Ping Utility <\/code>for<\/code> Linux: Version 21.0.0.0.0 - Production on 06-APR-2022 13:30:05<\/code><\/div>\n
<\/div>\n
Copyright (c) 1997, 2020, Oracle.\u00a0 All rights reserved.<\/code><\/div>\n
<\/div>\n
Used parameter files:<\/code><\/div>\n
\/u01\/app\/oracle\/network\/admin\/sqlnet<\/code>.ora<\/code><\/div>\n
<\/div>\n
<\/div>\n
Used TNSNAMES adapter to resolve the <\/code>alias<\/code><\/div>\n
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oraadserver4)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = DB21CLNE)))<\/code><\/div>\n
OK (0 msec)<\/code><\/div>\n
oracle@oraadserver2:<\/code>\/home\/oracle\/<\/code> [DB21 (CDB$ROOT)]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

From the target server<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n<\/td>\n
\n
\n
oracle@oraadserver4:<\/code>\/home\/oracle\/<\/code> [DB21CLNE (CDB$ROOT)] tnsping db21_site2<\/code><\/div>\n
<\/div>\n
TNS Ping Utility <\/code>for<\/code> Linux: Version 21.0.0.0.0 - Production on 06-APR-2022 13:33:12<\/code><\/div>\n
<\/div>\n
Copyright (c) 1997, 2020, Oracle.\u00a0 All rights reserved.<\/code><\/div>\n
<\/div>\n
Used parameter files:<\/code><\/div>\n
\/u01\/app\/oracle\/network\/admin\/sqlnet<\/code>.ora<\/code><\/div>\n
<\/div>\n
<\/div>\n
Used TNSNAMES adapter to resolve the <\/code>alias<\/code><\/div>\n
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oraadserver2)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = DB21_SITE2_DGMGRL)))<\/code><\/div>\n
OK (0 msec)<\/code><\/div>\n
oracle@oraadserver4:<\/code>\/home\/oracle\/<\/code> [DB21CLNE (CDB$ROOT)] tnsping db21clne<\/code><\/div>\n
<\/div>\n
TNS Ping Utility <\/code>for<\/code> Linux: Version 21.0.0.0.0 - Production on 06-APR-2022 13:33:16<\/code><\/div>\n
<\/div>\n
Copyright (c) 1997, 2020, Oracle.\u00a0 All rights reserved.<\/code><\/div>\n
<\/div>\n
Used parameter files:<\/code><\/div>\n
\/u01\/app\/oracle\/network\/admin\/sqlnet<\/code>.ora<\/code><\/div>\n
<\/div>\n
<\/div>\n
Used TNSNAMES adapter to resolve the <\/code>alias<\/code><\/div>\n
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oraadserver4)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = DB21CLNE)))<\/code><\/div>\n
OK (10 msec)<\/code><\/div>\n
oracle@oraadserver4:<\/code>\/home\/oracle\/<\/code> [DB21CLNE (CDB$ROOT)]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

I then create a simple duplicate rman script<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n<\/td>\n
\n
\n
oracle@oraadserver4: [DB21CLNE (CDB$ROOT)] <\/code>cat<\/code> duplicate_from_standby.rcv<\/code><\/div>\n
connect target sys\/******@db21_site2<\/code><\/div>\n
connect auxiliary\u00a0 sys\/****@db21clne<\/code><\/div>\n
run {<\/code><\/div>\n
duplicate target database to DB21CLNE from active database nofilenamecheck;<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

After starting the target database DB21CLNE in NOMOUNT state, I run the script to create DB21CLNE<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
oracle@oraadserver4: [DB21CLNE (CDB$ROOT)] <\/code>nohup<\/code> rman cmdfile=duplicate_from_standby.rcv log=duplicate_standby_`<\/code>date<\/code> +<\/code>\"%Y-%m-%d_%H%M%S\"<\/code>`.log &<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

A few minutes later the duplicate went fine (output truncated)<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n
49<\/div>\n
50<\/div>\n
51<\/div>\n
52<\/div>\n
53<\/div>\n
54<\/div>\n
55<\/div>\n
56<\/div>\n
57<\/div>\n
58<\/div>\n
59<\/div>\n
60<\/div>\n
61<\/div>\n
62<\/div>\n
63<\/div>\n
64<\/div>\n
65<\/div>\n
66<\/div>\n
67<\/div>\n
68<\/div>\n
69<\/div>\n
70<\/div>\n
71<\/div>\n
72<\/div>\n
73<\/div>\n
74<\/div>\n
75<\/div>\n
76<\/div>\n
77<\/div>\n
78<\/div>\n
79<\/div>\n
80<\/div>\n
81<\/div>\n
82<\/div>\n
83<\/div>\n
84<\/div>\n
85<\/div>\n
86<\/div>\n
87<\/div>\n
88<\/div>\n
89<\/div>\n
90<\/div>\n
91<\/div>\n
92<\/div>\n
93<\/div>\n
94<\/div>\n
95<\/div>\n
96<\/div>\n<\/td>\n
\n
\n
Recovery Manager: Release 21.0.0.0.0 - Production <\/code>on<\/code> Wed Apr 6 14:51:56 2022<\/code><\/div>\n
Version 21.1.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2020, Oracle <\/code>and<\/code>\/<\/code>or<\/code> its affiliates.\u00a0 <\/code>All<\/code> rights reserved.<\/code><\/div>\n
<\/div>\n
RMAN> <\/code>connect<\/code> target *<\/code><\/div>\n
2> <\/code>connect<\/code> auxiliary *<\/code><\/div>\n
3> run {<\/code><\/div>\n
4> duplicate target <\/code>database<\/code> to<\/code> DB21CLNE <\/code>from<\/code> active <\/code>database<\/code> nofilenamecheck;<\/code><\/div>\n
5> }<\/code><\/div>\n
6> <\/code><\/div>\n
connected <\/code>to<\/code> target <\/code>database<\/code>: DB21 (DBID=1137202071)<\/code><\/div>\n
<\/div>\n
connected <\/code>to<\/code> auxiliary <\/code>database<\/code>: DB21CLNE (<\/code>not<\/code> mounted)<\/code><\/div>\n
<\/div>\n
Starting Duplicate Db <\/code>at<\/code> 06-APR-2022 14:51:57<\/code><\/div>\n
using target <\/code>database<\/code> control file <\/code>instead<\/code> of<\/code> recovery catalog<\/code><\/div>\n
allocated channel: ORA_AUX_DISK_1<\/code><\/div>\n
channel ORA_AUX_DISK_1: SID=25 device type=DISK<\/code><\/div>\n
current<\/code> log archived <\/code>at<\/code> primary<\/code> database<\/code><\/div>\n
current<\/code> log archived <\/code>at<\/code> primary<\/code> database<\/code><\/div>\n
duplicating Online logs <\/code>to<\/code> Oracle Managed File (OMF) location<\/code><\/div>\n
duplicating Datafiles <\/code>to<\/code> Oracle Managed File (OMF) location<\/code><\/div>\n
<\/div>\n
contents <\/code>of<\/code> Memory Script:<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>sql clone <\/code>\"alter system set\u00a0 control_files = <\/code><\/div>\n
\u00a0\u00a0<\/code>''\/u01\/app\/oracle\/oradata\/DB21CLNE\/controlfile\/o1_mf_k4v3hqr1_.ctl'', ''\/u01\/app\/oracle\/fast_recovery_area\/DB21CLNE\/controlfile\/o1_mf_k4v3hqr7_.ctl'' comment=<\/code><\/div>\n
\u00a0<\/code>''Set by RMAN'' scope=spfile\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>sql clone <\/code>\"alter system set\u00a0 db_name = <\/code><\/div>\n
\u00a0<\/code>''DB21'' comment=<\/code><\/div>\n
\u00a0<\/code>''Modified by RMAN duplicate'' scope=spfile\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>sql clone <\/code>\"alter system set\u00a0 db_unique_name = <\/code><\/div>\n
\u00a0<\/code>''DB21CLNE'' comment=<\/code><\/div>\n
\u00a0<\/code>''Modified by RMAN duplicate'' scope=spfile\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>shutdown clone immediate;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>startup clone <\/code>force<\/code> nomount<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>restore clone <\/code>from<\/code> service\u00a0 <\/code>'db21_site2'<\/code> primary<\/code> controlfile;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>alter<\/code> clone <\/code>database<\/code> mount;<\/code><\/div>\n
}<\/code><\/div>\n
executing Memory Script<\/code><\/div>\n
<\/div>\n
sql statement: <\/code>alter<\/code> system <\/code>set<\/code>\u00a0 control_files =\u00a0\u00a0 <\/code>''<\/code>\/u01\/app\/oracle\/oradata\/DB21CLNE\/controlfile\/o1_mf_k4v3hqr1_.ctl<\/code>''<\/code>, <\/code>''<\/code>\/u01\/app\/oracle\/fast_recovery_area\/DB21CLNE\/controlfile\/o1_mf_k4v3hqr7_.ctl<\/code>''<\/code> comment= <\/code>''<\/code>Set<\/code> by<\/code> RMAN<\/code>''<\/code> scope=spfile<\/code><\/div>\n
<\/div>\n
sql statement: <\/code>alter<\/code> system <\/code>set<\/code>\u00a0 db_name =\u00a0 <\/code>''<\/code>DB21<\/code>''<\/code> comment= <\/code>''<\/code>Modified <\/code>by<\/code> RMAN duplicate<\/code>''<\/code> scope=spfile<\/code><\/div>\n
<\/div>\n
sql statement: <\/code>alter<\/code> system <\/code>set<\/code>\u00a0 db_unique_name =\u00a0 <\/code>''<\/code>DB21CLNE<\/code>''<\/code> comment= <\/code>''<\/code>Modified <\/code>by<\/code> RMAN duplicate<\/code>''<\/code> scope=spfile<\/code><\/div>\n
<\/div>\n
Oracle instance shut down<\/code><\/div>\n
<\/div>\n
Oracle instance started<\/code><\/div>\n
<\/div>\n
Total System <\/code>Global<\/code> Area\u00a0\u00a0\u00a0 1577057624 bytes<\/code><\/div>\n
<\/div>\n
Fixed <\/code>Size<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9686360 bytes<\/code><\/div>\n
Variable <\/code>Size<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 385875968 bytes<\/code><\/div>\n
Database<\/code> Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 889192448 bytes<\/code><\/div>\n
Redo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 292302848 bytes<\/code><\/div>\n
<\/div>\n
Starting restore <\/code>at<\/code> 06-APR-2022 14:56:46<\/code><\/div>\n
allocated channel: ORA_AUX_DISK_1<\/code><\/div>\n
channel ORA_AUX_DISK_1: SID=333 device type=DISK<\/code><\/div>\n
<\/div>\n
channel ORA_AUX_DISK_1: starting datafile backup <\/code>set<\/code> restore<\/code><\/div>\n
channel ORA_AUX_DISK_1: using network backup <\/code>set<\/code> from<\/code> service db21_site2<\/code><\/div>\n
channel ORA_AUX_DISK_1: restoring control file<\/code><\/div>\n
channel ORA_AUX_DISK_1: restore complete, elapsed <\/code>time<\/code>: 00:00:01<\/code><\/div>\n
output<\/code> file <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/DB21CLNE\/controlfile\/o1_mf_k4v3hqr1_.ctl<\/code><\/div>\n
output<\/code> file <\/code>name<\/code>=\/u01\/app\/oracle\/fast_recovery_area\/DB21CLNE\/controlfile\/o1_mf_k4v3hqr7_.ctl<\/code><\/div>\n
Finished restore <\/code>at<\/code> 06-APR-2022 14:56:49<\/code><\/div>\n
<\/div>\n
database<\/code> mounted<\/code><\/div>\n
\u2026<\/code><\/div>\n
\u2026<\/code><\/div>\n
<\/div>\n
Executing: <\/code>alter<\/code> database<\/code> force<\/code> logging<\/code><\/div>\n
<\/div>\n
contents <\/code>of<\/code> Memory Script:<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>Alter<\/code> clone <\/code>database<\/code> open<\/code> resetlogs;<\/code><\/div>\n
}<\/code><\/div>\n
executing Memory Script<\/code><\/div>\n
<\/div>\n
database<\/code> opened<\/code><\/div>\n
Executing: <\/code>alter<\/code> database<\/code> flashback <\/code>on<\/code><\/div>\n
<\/div>\n
contents <\/code>of<\/code> Memory Script:<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>sql clone <\/code>\"alter pluggable database all open\"<\/code>;<\/code><\/div>\n
}<\/code><\/div>\n
executing Memory Script<\/code><\/div>\n
<\/div>\n
sql statement: <\/code>alter<\/code> pluggable <\/code>database<\/code> all<\/code> open<\/code><\/div>\n
Finished Duplicate Db <\/code>at<\/code> 06-APR-2022 15:02:41<\/code><\/div>\n
<\/div>\n
Recovery Manager complete.<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And DB21CLNE is created and opened in READ WRITE and ready to be used<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n<\/td>\n
\n
\n
oracle@oraadserver4:\/u01\/app\/oracle\/admin\/DB21CLNE\/<\/code>create<\/code>\/ [DB21CLNE (CDB$ROOT)] DB21CLNE<\/code><\/div>\n
********* dbi services Ltd. *********<\/code><\/div>\n
STATUS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : <\/code>OPEN<\/code><\/div>\n
DB_UNIQUE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : DB21CLNE<\/code><\/div>\n
OPEN_MODE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : <\/code>READ<\/code> WRITE<\/code><\/div>\n
LOG_MODE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : ARCHIVELOG<\/code><\/div>\n
DATABASE_ROLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : <\/code>PRIMARY<\/code><\/div>\n
FLASHBACK_ON\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : YES<\/code><\/div>\n
FORCE_LOGGING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : YES<\/code><\/div>\n
VERSION\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 21.0.0.0.0<\/code><\/div>\n
CDB Enabled\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : YES<\/code><\/div>\n
List PDB(s)\u00a0 <\/code>READ<\/code> ONLY<\/code> : PDB$SEED<\/code><\/div>\n
List PDB(s) <\/code>READ<\/code> WRITE : PDB1, PDB2, PDB3<\/code><\/div>\n
*************************************<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Standby in MOUNT Mode <\/strong><\/p>\n

I decide to do the same tests , but with the source standby database in MOUNT state<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
oracle@oraadserver2:\/home\/oracle\/ [DB21 (CDB$ROOT)] DB21<\/code><\/div>\n
********* dbi services Ltd. *********<\/code><\/div>\n
STATUS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : MOUNTED<\/code><\/div>\n
DB_UNIQUE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : DB21_SITE2<\/code><\/div>\n
OPEN_MODE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : MOUNTED<\/code><\/div>\n
LOG_MODE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : ARCHIVELOG<\/code><\/div>\n
DATABASE_ROLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : PHYSICAL STANDBY<\/code><\/div>\n
FLASHBACK_ON\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : YES<\/code><\/div>\n
FORCE_LOGGING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : YES<\/code><\/div>\n
CDB Enabled\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : YES<\/code><\/div>\n
List PDB(s)\u00a0\u00a0\u00a0 MOUNTED : PDB$SEED, PDB1, PDB2, PDB3<\/code><\/div>\n
*************************************<\/code><\/div>\n
oracle@oraadserver2:\/home\/oracle\/ [DB21 (CDB$ROOT)]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

In this case the starts fine, but the recovery process was asking for a archived and was not able to finish. There was no error returned, but the duplicate is asking, asking the missing archived<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n
49<\/div>\n
50<\/div>\n
51<\/div>\n
52<\/div>\n
53<\/div>\n<\/td>\n
\n
\n
RMAN> <\/code>connect<\/code> target *<\/code><\/div>\n
2> <\/code>connect<\/code> auxiliary *<\/code><\/div>\n
3> run {<\/code><\/div>\n
4> duplicate target <\/code>database<\/code> to<\/code> DB21CLNE <\/code>from<\/code> active <\/code>database<\/code> nofilenamecheck;<\/code><\/div>\n
5> }<\/code><\/div>\n
6><\/code><\/div>\n
connected <\/code>to<\/code> target <\/code>database<\/code>: DB21 (DBID=1137202071, <\/code>not<\/code> open<\/code>)<\/code><\/div>\n
<\/div>\n
connected <\/code>to<\/code> auxiliary <\/code>database<\/code>: DB21CLNE (<\/code>not<\/code> mounted)<\/code><\/div>\n
<\/div>\n
Starting Duplicate Db <\/code>at<\/code> 06-APR-2022 14:12:28<\/code><\/div>\n
using target <\/code>database<\/code> control file <\/code>instead<\/code> of<\/code> recovery catalog<\/code><\/div>\n
allocated channel: ORA_AUX_DISK_1<\/code><\/div>\n
channel ORA_AUX_DISK_1: SID=23 device type=DISK<\/code><\/div>\n
current<\/code> log archived <\/code>at<\/code> primary<\/code> database<\/code><\/div>\n
current<\/code> log archived <\/code>at<\/code> primary<\/code> database<\/code><\/div>\n
duplicating Online logs <\/code>to<\/code> Oracle Managed File (OMF) location<\/code><\/div>\n
duplicating Datafiles <\/code>to<\/code> Oracle Managed File (OMF) location<\/code><\/div>\n
<\/div>\n
contents <\/code>of<\/code> Memory Script:<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>sql clone <\/code>\"alter system set\u00a0 control_files =<\/code><\/div>\n
\u00a0\u00a0<\/code>''\/u01\/app\/oracle\/oradata\/DB21CLNE\/controlfile\/o1_mf_k4v15kz7_.ctl'', ''\/u01\/app\/oracle\/fast_recovery_area\/DB21CLNE\/controlfile\/o1_mf_k4v15l04_.ctl'' comment=<\/code><\/div>\n
\u00a0<\/code>''Set by RMAN'' scope=spfile\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>sql clone <\/code>\"alter system set\u00a0 db_name =<\/code><\/div>\n
\u00a0<\/code>''DB21'' comment=<\/code><\/div>\n
\u00a0<\/code>''Modified by RMAN duplicate'' scope=spfile\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>sql clone <\/code>\"alter system set\u00a0 db_unique_name =<\/code><\/div>\n
\u00a0<\/code>''DB21CLNE'' comment=<\/code><\/div>\n
\u00a0<\/code>''Modified by RMAN duplicate'' scope=spfile\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>shutdown clone immediate;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>startup clone <\/code>force<\/code> nomount<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>restore clone <\/code>from<\/code> service\u00a0 <\/code>'db21_site2'<\/code> primary<\/code> controlfile;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>alter<\/code> clone <\/code>database<\/code> mount;<\/code><\/div>\n
}<\/code><\/div>\n
executing Memory Script<\/code><\/div>\n
<\/div>\n
\u2026<\/code><\/div>\n
\u2026<\/code><\/div>\n
<\/div>\n
starting media recovery<\/code><\/div>\n
<\/div>\n
archived log file <\/code>name<\/code>=\/u01\/app\/oracle\/fast_recovery_area\/DB21_SITE2\/archivelog\/2022_04_06\/o1_mf_1_35_k4v156k8_.arc thread=1 <\/code>sequence<\/code>=35<\/code><\/div>\n
archived log file <\/code>name<\/code>=\/u01\/app\/oracle\/fast_recovery_area\/DB21_SITE2\/archivelog\/2022_04_06\/o1_mf_1_35_k4v156k8_.arc thread=1 <\/code>sequence<\/code>=35<\/code><\/div>\n
archived log file <\/code>name<\/code>=\/u01\/app\/oracle\/fast_recovery_area\/DB21_SITE2\/archivelog\/2022_04_06\/o1_mf_1_35_k4v156k8_.arc thread=1 <\/code>sequence<\/code>=35<\/code><\/div>\n
...<\/code><\/div>\n
...<\/code><\/div>\n
archived log file <\/code>name<\/code>=\/u01\/app\/oracle\/fast_recovery_area\/DB21_SITE2\/archivelog\/2022_04_06\/o1_mf_1_35_k4v156k8_.arc thread=1 <\/code>sequence<\/code>=35<\/code><\/div>\n
archived log file <\/code>name<\/code>=\/u01\/app\/oracle\/fast_recovery_area\/DB21_SITE2\/archivelog\/2022_04_06\/o1_mf_1_35_k4v156k8_.arc thread=1 <\/code>sequence<\/code>=35<\/code><\/div>\n
archived log file <\/code>name<\/code>=\/u01\/app\/oracle\/fast_recovery_area\/DB21_SITE2\/archivelog\/2022_04_06\/o1_mf_1_35_k4v156k8_.arc thread=1 <\/code>sequence<\/code>=35<\/code><\/div>\n
archived log file <\/code>name<\/code>=\/u01\/app\/oracle\/fast_recovery_area\/DB21_SITE2\/archivelog\/2022_04_06\/o1_mf_1_35_k4v156k8_.arc thread=1 <\/code>sequence<\/code>=35<\/code><\/div>\n
<\/div>\n
\u2026.<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

As a workaround from the standby server I manually copy the requested archive to the remote source server<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
oracle@oraadserver2 ] scp o1_mf_1_35_k4v156k8_.arc oraadserver4:\/u01\/app\/oracle\/fast_recovery_area\/DB21_SITE2\/archivelog\/2022_04_06<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And the duplicate process went fine<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n<\/td>\n
\n
\n
\u2026<\/code><\/div>\n
\u2026<\/code><\/div>\n
contents <\/code>of<\/code> Memory Script:<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>Alter<\/code> clone <\/code>database<\/code> open<\/code> resetlogs;<\/code><\/div>\n
}<\/code><\/div>\n
executing Memory Script<\/code><\/div>\n
<\/div>\n
database<\/code> opened<\/code><\/div>\n
Executing: <\/code>alter<\/code> database<\/code> flashback <\/code>on<\/code><\/div>\n
<\/div>\n
contents <\/code>of<\/code> Memory Script:<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>sql clone <\/code>\"alter pluggable database all open\"<\/code>;<\/code><\/div>\n
}<\/code><\/div>\n
executing Memory Script<\/code><\/div>\n
<\/div>\n
sql statement: <\/code>alter<\/code> pluggable <\/code>database<\/code> all<\/code> open<\/code><\/div>\n
Finished Duplicate Db <\/code>at<\/code> 06-APR-2022 14:34:39<\/code><\/div>\n
<\/div>\n
Recovery Manager complete.<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

So we can see that duplicate can be done from a standby database like a primary one. Just when the standby is mounted, you may have to manually copy some archived.<\/p>\n

Note that I repeat the duplicate a second time with the database mount and I had the same behavior, I had to manually copy a missing archived log.<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw Generally we do active duplicate from primary database, but I think it should be fine to see what happen if we do active duplicate a database from a standby database. So, I do some tests and I write the results in this blog Below the actual configuration of my Data Guard environment […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,59],"tags":[2529,137,270,2530],"type_dbi":[],"class_list":["post-17167","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-oracle","tag-duplicate-from-active","tag-oracle-21c","tag-rman","tag-standbydatabase"],"acf":[],"yoast_head":"\nActive Duplicate from standby database - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Active Duplicate from standby database\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw Generally we do active duplicate from primary database, but I think it should be fine to see what happen if we do active duplicate a database from a standby database. So, I do some tests and I write the results in this blog Below the actual configuration of my Data Guard environment […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-07T13:32:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-20T08:13:47+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Active Duplicate from standby database\",\"datePublished\":\"2022-04-07T13:32:41+00:00\",\"dateModified\":\"2023-06-20T08:13:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/\"},\"wordCount\":345,\"commentCount\":1,\"keywords\":[\"duplicate from active\",\"Oracle 21C\",\"RMAN\",\"standbydatabase\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/\",\"name\":\"Active Duplicate from standby database - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2022-04-07T13:32:41+00:00\",\"dateModified\":\"2023-06-20T08:13:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Active Duplicate from standby database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Active Duplicate from standby database - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/","og_locale":"en_US","og_type":"article","og_title":"Active Duplicate from standby database","og_description":"By Mouhamadou Diaw Generally we do active duplicate from primary database, but I think it should be fine to see what happen if we do active duplicate a database from a standby database. So, I do some tests and I write the results in this blog Below the actual configuration of my Data Guard environment […]","og_url":"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/","og_site_name":"dbi Blog","article_published_time":"2022-04-07T13:32:41+00:00","article_modified_time":"2023-06-20T08:13:47+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Active Duplicate from standby database","datePublished":"2022-04-07T13:32:41+00:00","dateModified":"2023-06-20T08:13:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/"},"wordCount":345,"commentCount":1,"keywords":["duplicate from active","Oracle 21C","RMAN","standbydatabase"],"articleSection":["Database Administration & Monitoring","Database management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/","url":"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/","name":"Active Duplicate from standby database - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-04-07T13:32:41+00:00","dateModified":"2023-06-20T08:13:47+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/active-duplicate-from-standby-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Active Duplicate from standby database"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=17167"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17167\/revisions"}],"predecessor-version":[{"id":26137,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17167\/revisions\/26137"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=17167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=17167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=17167"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=17167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}