{"id":13460,"date":"2020-02-18T21:02:02","date_gmt":"2020-02-18T20:02:02","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/"},"modified":"2023-06-15T16:39:52","modified_gmt":"2023-06-15T14:39:52","slug":"oracle-20c-the-new-prepare-database-for-data-guard","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/","title":{"rendered":"Oracle 20c : The new PREPARE DATABASE FOR DATA GUARD"},"content":{"rendered":"

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

As you may know, Oracle 20c is in the cloud with new features. The one I have tested is the PREPARE DATABASE FOR DATA GUARD.
\nThis command configures a database for use as a primary database in a Data Guard broker configuration. Database initialization parameters are set to recommended values.
\nLet\u2019s see what this command will do for us
\nThe db_unique_name of the primary database is prod20 and in the Data Guard I will build, the db_unique_name will be changed to prod20_site1.<\/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
SQL> show parameter db_unique_name<\/code><\/div>\n
<\/div>\n
NAME<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0 VALUE<\/code><\/div>\n
------------------------------------ ----------- ------------------------------<\/code><\/div>\n
db_unique_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0 prod20<\/code><\/div>\n
SQL> <\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now let\u2019s connect to the broker can run the help to see the syntax<\/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<\/td>\n
\n
\n
[oracle@oraadserver ~]$ dgmgrl<\/code><\/div>\n
DGMGRL <\/code>for<\/code> Linux: Release 20.0.0.0.0 - Production <\/code>on<\/code> Tue Feb 18 21:36:39 2020<\/code><\/div>\n
Version 20.2.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
Welcome <\/code>to<\/code> DGMGRL, type <\/code>\"help\"<\/code> for<\/code> information.<\/code><\/div>\n
DGMGRL> <\/code>connect<\/code> \/<\/code><\/div>\n
Connected <\/code>to<\/code> \"prod20_site1\"<\/code><\/div>\n
Connected <\/code>as<\/code> SYSDG.<\/code><\/div>\n
DGMGRL> <\/code><\/div>\n
\u00a0<\/code><\/div>\n
DGMGRL> help <\/code>prepare<\/code><\/div>\n
<\/div>\n
Prepare<\/code> a <\/code>primary<\/code> database<\/code> for<\/code> a Data Guard environment.<\/code><\/div>\n
<\/div>\n
Syntax:<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>PREPARE<\/code> DATABASE<\/code> FOR<\/code> DATA GUARD<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>[<\/code>WITH<\/code> [DB_UNIQUE_NAME <\/code>IS<\/code> ]<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>[DB_RECOVERY_FILE_DEST <\/code>IS<\/code> ]<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>[DB_RECOVERY_FILE_DEST_SIZE <\/code>IS<\/code> ]<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>[BROKER_CONFIG_FILE_1 <\/code>IS<\/code> ]<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>[BROKER_CONFIG_FILE_2 <\/code>IS<\/code> ]];<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And then run the command<\/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<\/td>\n
\n
\n
DGMGRL> <\/code>PREPARE<\/code> DATABASE<\/code> FOR<\/code> DATA GUARD <\/code>with<\/code> DB_UNIQUE_NAME <\/code>is<\/code> prod20_site1;<\/code><\/div>\n
Preparing <\/code>database<\/code> \"prod20\"<\/code> for<\/code> Data Guard.<\/code><\/div>\n
Initialization parameter DB_UNIQUE_NAME <\/code>set<\/code> to<\/code> 'prod20_site1'<\/code>.<\/code><\/div>\n
Initialization parameter DB_FILES <\/code>set<\/code> to<\/code> 1024.<\/code><\/div>\n
Initialization parameter LOG_BUFFER <\/code>set<\/code> to<\/code> 268435456.<\/code><\/div>\n
Primary<\/code> database<\/code> must be restarted <\/code>after<\/code> setting <\/code>static<\/code> initialization parameters.<\/code><\/div>\n
Shutting down <\/code>database<\/code> \"prod20_site1\"<\/code>.<\/code><\/div>\n
Database<\/code> closed.<\/code><\/div>\n
Database<\/code> dismounted.<\/code><\/div>\n
ORACLE instance shut down.<\/code><\/div>\n
Starting <\/code>database<\/code> \"prod20_site1\"<\/code> to<\/code> mounted mode.<\/code><\/div>\n
ORACLE instance started.<\/code><\/div>\n
Database<\/code> mounted.<\/code><\/div>\n
Initialization parameter DB_FLASHBACK_RETENTION_TARGET <\/code>set<\/code> to<\/code> 120.<\/code><\/div>\n
Initialization parameter DB_LOST_WRITE_PROTECT <\/code>set<\/code> to<\/code> 'TYPICAL'<\/code>.<\/code><\/div>\n
RMAN configuration archivelog deletion policy <\/code>set<\/code> to<\/code> SHIPPED <\/code>TO<\/code> ALL<\/code> STANDBY.<\/code><\/div>\n
Adding standby log <\/code>group<\/code> size<\/code> 209715200 <\/code>and<\/code> assigning it <\/code>to<\/code> thread 1.<\/code><\/div>\n
Adding standby log <\/code>group<\/code> size<\/code> 209715200 <\/code>and<\/code> assigning it <\/code>to<\/code> thread 1.<\/code><\/div>\n
Adding standby log <\/code>group<\/code> size<\/code> 209715200 <\/code>and<\/code> assigning it <\/code>to<\/code> thread 1.<\/code><\/div>\n
Initialization parameter STANDBY_FILE_MANAGEMENT <\/code>set<\/code> to<\/code> 'AUTO'<\/code>.<\/code><\/div>\n
Initialization parameter DG_BROKER_START <\/code>set<\/code> to<\/code> TRUE<\/code>.<\/code><\/div>\n
Database<\/code> set<\/code> to<\/code> FORCE<\/code> LOGGING.<\/code><\/div>\n
Database<\/code> set<\/code> to<\/code> FLASHBACK <\/code>ON<\/code>.<\/code><\/div>\n
Database<\/code> opened.<\/code><\/div>\n
DGMGRL> <\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The output shows the changes done by the PREPARE command. We can do some checks<\/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<\/td>\n
\n
\n
SQL> show parameter db_unique_name<\/code><\/div>\n
<\/div>\n
NAME<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0 VALUE<\/code><\/div>\n
------------------------------------ ----------- ------------------------------<\/code><\/div>\n
db_unique_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0 prod20_site1<\/code><\/div>\n
SQL> <\/code>select<\/code> flashback_on,force_logging <\/code>from<\/code> v$<\/code>database<\/code>;<\/code><\/div>\n
<\/div>\n
FLASHBACK_ON\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FORCE_LOGGING<\/code><\/div>\n
------------------ ---------------------------------------<\/code><\/div>\n
YES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 YES<\/code><\/div>\n
<\/div>\n
SQL> <\/code><\/div>\n
<\/div>\n
SQL> show parameter standby_file<\/code><\/div>\n
<\/div>\n
NAME<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0 VALUE<\/code><\/div>\n
------------------------------------ ----------- ------------------------------<\/code><\/div>\n
standby_file_management\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0 AUTO<\/code><\/div>\n
SQL> <\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

But here I can see that I only have 3 standby redo log groups instead of 4 (as I have 3 redo log groups)<\/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<\/td>\n
\n
\n
SQL> <\/code>select<\/code> bytes,<\/code>group<\/code># <\/code>from<\/code> v$log;<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>BYTES\u00a0\u00a0\u00a0\u00a0 <\/code>GROUP<\/code>#<\/code><\/div>\n
---------- ----------<\/code><\/div>\n
\u00a0<\/code>209715200\u00a0\u00a0\u00a0\u00a0\u00a0 1<\/code><\/div>\n
\u00a0<\/code>209715200\u00a0\u00a0\u00a0\u00a0\u00a0 2<\/code><\/div>\n
\u00a0<\/code>209715200\u00a0\u00a0\u00a0\u00a0\u00a0 3<\/code><\/div>\n
<\/div>\n
SQL> <\/code><\/div>\n
<\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> group<\/code>#,bytes <\/code>from<\/code> v$standby_log;<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>GROUP<\/code>#\u00a0 BYTES<\/code><\/div>\n
---------- ----------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>4\u00a0 209715200<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>5\u00a0 209715200<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>6\u00a0 209715200<\/code><\/div>\n
<\/div>\n
SQL> <\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

After building the Data Guard I did some checks (note that steps not shown here but the same that other version)
\nFor the configuration<\/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<\/td>\n
\n
\n
DGMGRL> show configuration verbose;<\/code><\/div>\n
<\/div>\n
Configuration - prod20<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxPerformance<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>prod20_site1 - <\/code>Primary<\/code> database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>prod20_site2 - Physical standby <\/code>database<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Properties:<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>FastStartFailoverThreshold\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'30'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>OperationTimeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'30'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>TraceLevel\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'USER'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>FastStartFailoverLagLimit\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'30'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CommunicationTimeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'180'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ObserverReconnect\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'0'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>FastStartFailoverAutoReinstate\u00a0 = <\/code>'TRUE'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>FastStartFailoverPmyShutdown\u00a0\u00a0\u00a0 = <\/code>'TRUE'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>BystandersFollowRoleChange\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'ALL'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ObserverOverride\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'FALSE'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ExternalDestination1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ExternalDestination2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>PrimaryLostWriteAction\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'CONTINUE'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ConfigurationWideServiceName\u00a0\u00a0\u00a0 = <\/code>'prod20_CFG'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ConfigurationSimpleName\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'prod20'<\/code><\/div>\n
<\/div>\n
Fast-Start Failover:\u00a0 Disabled<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
SUCCESS<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

For the primary database<\/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<\/td>\n
\n
\n
DGMGRL> show <\/code>database<\/code> verbose <\/code>'prod20_site1'<\/code>;<\/code><\/div>\n
<\/div>\n
Database<\/code> - prod20_site1<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Role:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>PRIMARY<\/code><\/div>\n
\u00a0\u00a0<\/code>Intended State:\u00a0\u00a0\u00a0\u00a0\u00a0 TRANSPORT-<\/code>ON<\/code><\/div>\n
\u00a0\u00a0<\/code>Instance(s):<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>prod20<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Properties:<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>DGConnectIdentifier\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'prod20_site1'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ObserverConnectIdentifier\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>FastStartFailoverTarget\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>PreferredObserverHosts\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>LogShipping\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'ON'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>RedoRoutes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>LogXptMode\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'ASYNC'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>DelayMins\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'0'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>Binding\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'optional'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>MaxFailure\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'0'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ReopenSecs\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'300'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>NetTimeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'30'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>RedoCompression\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'DISABLE'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>PreferredApplyInstance\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ApplyInstanceTimeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'0'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ApplyLagThreshold\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'30'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>TransportLagThreshold\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'30'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>TransportDisconnectedThreshold\u00a0 = <\/code>'30'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ApplyParallel\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'AUTO'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ApplyInstances\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'0'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ArchiveLocation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>AlternateLocation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>StandbyArchiveLocation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>StandbyAlternateLocation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>InconsistentProperties\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'(monitor)'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>InconsistentLogXptProps\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'(monitor)'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>LogXptStatus\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'(monitor)'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>SendQEntries\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'(monitor)'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>RecvQEntries\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'(monitor)'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>HostName\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'oraadserver'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>StaticConnectIdentifier\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oraadserver)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=prod20_site1_DGMGRL)(INSTANCE_NAME=prod20)(SERVER=DEDICATED)))'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>TopWaitEvents\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'(monitor)'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>SidName\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'(monitor)'<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Log file locations:<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>Alert log\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : \/u01\/app\/oracle\/diag\/rdbms\/prod20_site1\/prod20\/trace\/alert_prod20.log<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>Data Guard Broker log\u00a0\u00a0 : \/u01\/app\/oracle\/diag\/rdbms\/prod20_site1\/prod20\/trace\/drcprod20.log<\/code><\/div>\n
<\/div>\n
Database<\/code> Status:<\/code><\/div>\n
SUCCESS<\/code><\/div>\n
<\/div>\n
DGMGRL> <\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

For the standby database<\/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<\/td>\n
\n
\n
DGMGRL> show <\/code>database<\/code> verbose <\/code>'prod20_site2'<\/code>;<\/code><\/div>\n
<\/div>\n
Database<\/code> - prod20_site2<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Role:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PHYSICAL STANDBY<\/code><\/div>\n
\u00a0\u00a0<\/code>Intended State:\u00a0\u00a0\u00a0\u00a0\u00a0 APPLY-<\/code>ON<\/code><\/div>\n
\u00a0\u00a0<\/code>Transport Lag:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 seconds (computed 1 <\/code>second<\/code> ago)<\/code><\/div>\n
\u00a0\u00a0<\/code>Apply Lag:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 seconds (computed 1 <\/code>second<\/code> ago)<\/code><\/div>\n
\u00a0\u00a0<\/code>Average Apply Rate:\u00a0 2.00 KByte\/s<\/code><\/div>\n
\u00a0\u00a0<\/code>Active Apply Rate:\u00a0\u00a0 0 Byte\/s<\/code><\/div>\n
\u00a0\u00a0<\/code>Maximum Apply Rate:\u00a0 0 Byte\/s<\/code><\/div>\n
\u00a0\u00a0<\/code>Real<\/code> Time<\/code> Query:\u00a0\u00a0\u00a0\u00a0 <\/code>OFF<\/code><\/div>\n
\u00a0\u00a0<\/code>Instance(s):<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>prod20<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Properties:<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>DGConnectIdentifier\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'prod20_site2'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ObserverConnectIdentifier\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>FastStartFailoverTarget\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>PreferredObserverHosts\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>LogShipping\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'ON'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>RedoRoutes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>LogXptMode\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'ASYNC'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>DelayMins\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'0'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>Binding\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'optional'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>MaxFailure\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'0'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ReopenSecs\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'300'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>NetTimeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'30'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>RedoCompression\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'DISABLE'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>PreferredApplyInstance\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ApplyInstanceTimeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'0'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ApplyLagThreshold\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'30'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>TransportLagThreshold\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'30'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>TransportDisconnectedThreshold\u00a0 = <\/code>'30'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ApplyParallel\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'AUTO'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ApplyInstances\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'0'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ArchiveLocation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>AlternateLocation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>StandbyArchiveLocation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>StandbyAlternateLocation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>''<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>InconsistentProperties\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'(monitor)'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>InconsistentLogXptProps\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'(monitor)'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>LogXptStatus\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'(monitor)'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>SendQEntries\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'(monitor)'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>RecvQEntries\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'(monitor)'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>HostName\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'oraadserver2'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>StaticConnectIdentifier\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oraadserver2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD20_SITE2_DGMGRL)(INSTANCE_NAME=prod20)(SERVER=DEDICATED)))'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>TopWaitEvents\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'(monitor)'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>SidName\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>'(monitor)'<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Log file locations:<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>Alert log\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : \/u01\/app\/oracle\/diag\/rdbms\/prod20_site2\/prod20\/trace\/alert_prod20.log<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>Data Guard Broker log\u00a0\u00a0 : \/u01\/app\/oracle\/diag\/rdbms\/prod20_site2\/prod20\/trace\/drcprod20.log<\/code><\/div>\n
<\/div>\n
Database<\/code> Status:<\/code><\/div>\n
SUCCESS<\/code><\/div>\n
<\/div>\n
DGMGRL> <\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Conclusion<\/h3>\n

I am sure that you will adopt this nice command.<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw As you may know, Oracle 20c is in the cloud with new features. The one I have tested is the PREPARE DATABASE FOR DATA GUARD. This command configures a database for use as a primary database in a Data Guard broker configuration. Database initialization parameters are set to recommended values. Let\u2019s see […]<\/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":[1834,221,458],"type_dbi":[],"class_list":["post-13460","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-oracle","tag-borker","tag-data-guard","tag-oracle-20c"],"acf":[],"yoast_head":"\nOracle 20c : The new PREPARE DATABASE FOR DATA GUARD - 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\/oracle-20c-the-new-prepare-database-for-data-guard\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 20c : The new PREPARE DATABASE FOR DATA GUARD\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw As you may know, Oracle 20c is in the cloud with new features. The one I have tested is the PREPARE DATABASE FOR DATA GUARD. This command configures a database for use as a primary database in a Data Guard broker configuration. Database initialization parameters are set to recommended values. Let\u2019s see […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-18T20:02:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-15T14:39:52+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=\"5 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\/oracle-20c-the-new-prepare-database-for-data-guard\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 20c : The new PREPARE DATABASE FOR DATA GUARD\",\"datePublished\":\"2020-02-18T20:02:02+00:00\",\"dateModified\":\"2023-06-15T14:39:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/\"},\"wordCount\":199,\"commentCount\":0,\"keywords\":[\"Borker\",\"Data Guard\",\"Oracle 20c\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/\",\"name\":\"Oracle 20c : The new PREPARE DATABASE FOR DATA GUARD - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2020-02-18T20:02:02+00:00\",\"dateModified\":\"2023-06-15T14:39:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 20c : The new PREPARE DATABASE FOR DATA GUARD\"}]},{\"@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":"Oracle 20c : The new PREPARE DATABASE FOR DATA GUARD - 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\/oracle-20c-the-new-prepare-database-for-data-guard\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 20c : The new PREPARE DATABASE FOR DATA GUARD","og_description":"By Mouhamadou Diaw As you may know, Oracle 20c is in the cloud with new features. The one I have tested is the PREPARE DATABASE FOR DATA GUARD. This command configures a database for use as a primary database in a Data Guard broker configuration. Database initialization parameters are set to recommended values. Let\u2019s see […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/","og_site_name":"dbi Blog","article_published_time":"2020-02-18T20:02:02+00:00","article_modified_time":"2023-06-15T14:39:52+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 20c : The new PREPARE DATABASE FOR DATA GUARD","datePublished":"2020-02-18T20:02:02+00:00","dateModified":"2023-06-15T14:39:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/"},"wordCount":199,"commentCount":0,"keywords":["Borker","Data Guard","Oracle 20c"],"articleSection":["Database Administration & Monitoring","Database management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/","name":"Oracle 20c : The new PREPARE DATABASE FOR DATA GUARD - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2020-02-18T20:02:02+00:00","dateModified":"2023-06-15T14:39:52+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 20c : The new PREPARE DATABASE FOR DATA GUARD"}]},{"@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\/13460","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=13460"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13460\/revisions"}],"predecessor-version":[{"id":25955,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13460\/revisions\/25955"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=13460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=13460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=13460"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=13460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}