{"id":11737,"date":"2018-09-25T14:43:05","date_gmt":"2018-09-25T12:43:05","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/"},"modified":"2023-07-20T08:35:16","modified_gmt":"2023-07-20T06:35:16","slug":"oracle-18c-active-data-guard-and-awr-reports","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/","title":{"rendered":"Oracle 18c : Active Data Guard and AWR Reports"},"content":{"rendered":"

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

Since Oracle Database 12c Release 2 (12.2), Automatic Workload Repository (AWR) data can be captured for Active Data Guard (ADG) standby databases. This feature enables analyzing any performance-related issues for ADG standby databases
\nAWR snapshots for ADG standby databases are called remote snapshots. A database node, called destination, is responsible for storing snapshots that are collected from remote ADG standby database nodes, called sources.
\nThe AWR data captures for Active Data Guard require certain steps that I am trying to describe here. I am using Oracle 18c with following 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<\/td>\n
\n
\n
DGMGRL> show configuration<\/code><\/div>\n
<\/div>\n
Configuration - NONC18C_DR<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxPerformance<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>NONC18C_SITE1 - <\/code>Primary<\/code> database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>NONC18C_SITE2 - Physical standby <\/code>database<\/code><\/div>\n
<\/div>\n
Fast-Start Failover: DISABLED<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
SUCCESS\u00a0\u00a0 (status updated 30 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 primary is opened in Read Write mode and the standby in Read Only Mode With Apply<\/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
SQL> <\/code>select<\/code> db_unique_name,open_mode, database_role <\/code>from<\/code> v$<\/code>database<\/code>;<\/code><\/div>\n
<\/div>\n
DB_UNIQUE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OPEN_MODE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DATABASE_ROLE<\/code><\/div>\n
------------------------------ -------------------- ----------------<\/code><\/div>\n
NONC18C_SITE2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> ONLY<\/code> WITH<\/code> APPLY PHYSICAL STANDBY<\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> db_unique_name,open_mode, database_role <\/code>from<\/code> v$<\/code>database<\/code>;<\/code><\/div>\n
<\/div>\n
DB_UNIQUE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OPEN_MODE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DATABASE_ROLE<\/code><\/div>\n
------------------------------ -------------------- ----------------<\/code><\/div>\n
NONC18C_SITE1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> WRITE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>PRIMARY<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The feature uses the Remote Management Framework which comes with a New Oracle built-in user called SYS$UMF. This user is locked by default and should be unlocked before configuring the RMF.<\/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<\/td>\n
\n
\n
SQL> <\/code>select<\/code> username,common,account_status <\/code>from<\/code> dba_users <\/code>where<\/code> username <\/code>like<\/code> 'SYS%'<\/code>;<\/code><\/div>\n
<\/div>\n
USERNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 COM ACCOUNT_STATUS<\/code><\/div>\n
------------------------------ --- --------------------------------<\/code><\/div>\n
SYS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 YES <\/code>OPEN<\/code><\/div>\n
SYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 YES <\/code>OPEN<\/code><\/div>\n
SYSBACKUP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 YES EXPIRED & LOCKED<\/code><\/div>\n
SYSRAC\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 YES EXPIRED & LOCKED<\/code><\/div>\n
SYSKM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 YES EXPIRED & LOCKED<\/code><\/div>\n
SYS$UMF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 YES EXPIRED & LOCKED<\/code><\/div>\n
SYSDG\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 YES EXPIRED & LOCKED<\/code><\/div>\n
<\/div>\n
7 <\/code>rows<\/code> selected.<\/code><\/div>\n
<\/div>\n
SQL> <\/code>alter<\/code> user<\/code> sys$umf identified <\/code>by<\/code> root account unlock;<\/code><\/div>\n
<\/div>\n
User<\/code> altered.<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

For the configuration we need in our case 2 database links. Indeed each source must have two database links, a destination-to-source database link and a source-to-destination database link. So connecting on the primary, let\u2019s create 2 database links
\n=><\/strong>prima_to_stand: from the primary to the standby
\n=><\/strong>stand_to_prima: from standby to the primary<\/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<\/td>\n
\n
\n
SQL> <\/code>create<\/code> database<\/code> link prima_to_stand <\/code>CONNECT<\/code> TO<\/code> sys$umf IDENTIFIED <\/code>BY<\/code> root using <\/code>'STBY_NONC'<\/code>;<\/code><\/div>\n
<\/div>\n
Database<\/code> link created.<\/code><\/div>\n
<\/div>\n
SQL> <\/code>create<\/code> database<\/code> link stand_to_prima <\/code>CONNECT<\/code> TO<\/code> sys$umf IDENTIFIED <\/code>BY<\/code> root using <\/code>'PRIMA_NONC'<\/code>;<\/code><\/div>\n
<\/div>\n
Database<\/code> link created.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n
SQL> <\/code>select<\/code> * <\/code>from<\/code> dual@prima_to_stand;<\/code><\/div>\n
<\/div>\n
D<\/code><\/div>\n
-<\/code><\/div>\n
X<\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> * <\/code>from<\/code> dual@stand_to_prima;<\/code><\/div>\n
<\/div>\n
D<\/code><\/div>\n
-<\/code><\/div>\n
X<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The RMF topology is a centralized architecture that consists of all the participating database nodes along with their metadata and connection information. So let\u2019s configure the nodes. We will call them “site_prim” for primary and “site_stby” for standby
\nWhile connecting on the primary we execute<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>exec<\/code> dbms_umf.configure_node (<\/code>'site_prim'<\/code>);<\/code><\/div>\n
<\/div>\n
PL\/SQL <\/code>procedure<\/code> successfully completed.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

On the standby side we do the same but here we give the database link. Be sure that the database links were created in the right direction, otherwise you will get errors later.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>exec<\/code> dbms_umf.configure_node(<\/code>'site_stby'<\/code>,<\/code>'stand_to_prima'<\/code>);<\/code><\/div>\n
<\/div>\n
PL\/SQL <\/code>procedure<\/code> successfully completed.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And now from the primary, we can then create the RMF topology.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>exec<\/code> DBMS_UMF.create_topology (<\/code>'Topology_1'<\/code>);<\/code><\/div>\n
<\/div>\n
PL\/SQL <\/code>procedure<\/code> successfully completed.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

To verify the status of the configuration we can use following UMF views on the primary<\/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
SQL> <\/code>select<\/code> * <\/code>from<\/code> dba_umf_topology;<\/code><\/div>\n
<\/div>\n
TOPOLOGY_NAME\u00a0\u00a0\u00a0 TARGET_ID TOPOLOGY_VERSION TOPOLOGY<\/code><\/div>\n
--------------- ---------- ---------------- --------<\/code><\/div>\n
Topology_1\u00a0\u00a0\u00a0\u00a0\u00a0 1530523744\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 ACTIVE<\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> * <\/code>from<\/code> dba_umf_registration;<\/code><\/div>\n
<\/div>\n
TOPOLOGY_NAME\u00a0\u00a0 NODE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NODE_ID\u00a0 NODE_TYPE AS_SO AS_CA STATE<\/code><\/div>\n
--------------- --------------- ---------- ---------- ----- ----- --------------------<\/code><\/div>\n
Topology_1\u00a0\u00a0\u00a0\u00a0\u00a0 site_prim\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1530523744\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 <\/code>FALSE<\/code> FALSE<\/code> OK<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Everything seems fine, so we can register the standby in the topology. On the primary let\u2019s excute the register_node procedure.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>exec<\/code> DBMS_UMF.register_node (<\/code>'Topology_1'<\/code>, <\/code>'site_stby'<\/code>, <\/code>'prima_to_stand'<\/code>, <\/code>'stand_to_prima'<\/code>, <\/code>'FALSE'<\/code>, <\/code>'FALSE'<\/code>);<\/code><\/div>\n
<\/div>\n
PL\/SQL <\/code>procedure<\/code> successfully completed.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

If we do not have errors then we can enable the AWR service.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>exec<\/code> DBMS_WORKLOAD_REPOSITORY.register_remote_database(node_name=><\/code>'site_stby'<\/code>);<\/code><\/div>\n
<\/div>\n
PL\/SQL <\/code>procedure<\/code> successfully completed.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Using UMF views, we can again verify our 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<\/td>\n
\n
\n
SQL> <\/code>select<\/code> * <\/code>from<\/code> dba_umf_topology;<\/code><\/div>\n
<\/div>\n
TOPOLOGY_NAME\u00a0\u00a0\u00a0 TARGET_ID TOPOLOGY_VERSION TOPOLOGY<\/code><\/div>\n
--------------- ---------- ---------------- --------<\/code><\/div>\n
Topology_1\u00a0\u00a0\u00a0\u00a0\u00a0 1530523744\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 ACTIVE<\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> * <\/code>from<\/code> dba_umf_registration;<\/code><\/div>\n
<\/div>\n
TOPOLOGY_NAME\u00a0\u00a0 NODE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NODE_ID\u00a0 NODE_TYPE AS_SO AS_CA STATE<\/code><\/div>\n
--------------- --------------- ---------- ---------- ----- ----- --------------------<\/code><\/div>\n
Topology_1\u00a0\u00a0\u00a0\u00a0\u00a0 site_prim\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1530523744\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 <\/code>FALSE<\/code> FALSE<\/code> OK<\/code><\/div>\n
Topology_1\u00a0\u00a0\u00a0\u00a0\u00a0 site_stby\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3265600723\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 <\/code>FALSE<\/code> FALSE<\/code> OK<\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> * <\/code>from<\/code> dba_umf_service;<\/code><\/div>\n
<\/div>\n
TOPOLOGY_NAME\u00a0\u00a0\u00a0\u00a0\u00a0 NODE_ID SERVICE<\/code><\/div>\n
--------------- ---------- -------<\/code><\/div>\n
Topology_1\u00a0\u00a0\u00a0\u00a0\u00a0 3265600723 AWR<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> * <\/code>from<\/code> dba_umf_link;<\/code><\/div>\n
<\/div>\n
TOPOLOGY_NAME\u00a0\u00a0 FROM_NODE_ID TO_NODE_ID LINK_NAME<\/code><\/div>\n
--------------- ------------ ---------- --------------------<\/code><\/div>\n
Topology_1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1530523744 3265600723 PRIMA_TO_STAND<\/code><\/div>\n
Topology_1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3265600723 1530523744 STAND_TO_PRIMA<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

It\u2019s now time to generate remote snapshots for the standby. While connecting to the primary. Two snapshots are at least required to be able to generate an AWR report.<\/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<\/td>\n
\n
\n
SQL> <\/code>set<\/code> time<\/code> on<\/code><\/div>\n
16:01:22 SQL> <\/code>exec<\/code> dbms_workload_repository.create_remote_snapshot(<\/code>'site_stby'<\/code>);<\/code><\/div>\n
<\/div>\n
PL\/SQL <\/code>procedure<\/code> successfully completed.<\/code><\/div>\n
<\/div>\n
16:21:41 SQL> <\/code>exec<\/code> dbms_workload_repository.create_remote_snapshot(<\/code>'site_stby'<\/code>);<\/code><\/div>\n
<\/div>\n
PL\/SQL <\/code>procedure<\/code> successfully completed.<\/code><\/div>\n
<\/div>\n
16:21:50 SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And we can generate the report as we usually do<\/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<\/td>\n
\n
\n
SQL> @?\/rdbms\/admin\/awrrpti.sql<\/code><\/div>\n
<\/div>\n
Specify the Report Type<\/code><\/div>\n
~~~~~~~~~~~~~~~~~~~~~~~<\/code><\/div>\n
AWR reports can be generated <\/code>in<\/code> the following formats.\u00a0 Please enter the<\/code><\/div>\n
name<\/code> of<\/code> the format <\/code>at<\/code> the prompt. <\/code>Default<\/code> value <\/code>is<\/code> 'html'<\/code>.<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0<\/code>'html'<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 HTML format (<\/code>default<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>'text'<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Text format<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>'active-html'<\/code>\u00a0\u00a0 Includes Performance Hub active report<\/code><\/div>\n
<\/div>\n
Enter value <\/code>for<\/code> report_type: text<\/code><\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
Type Specified: text<\/code><\/div>\n
<\/div>\n
<\/div>\n
Instances <\/code>in<\/code> this Workload Repository <\/code>schema<\/code><\/div>\n
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<\/code><\/div>\n
\u00a0\u00a0<\/code>DB Id\u00a0\u00a0\u00a0\u00a0\u00a0 Inst Num\u00a0\u00a0 DB <\/code>Name<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0 Instance\u00a0\u00a0\u00a0\u00a0 Host<\/code><\/div>\n
------------ ---------- ---------\u00a0\u00a0\u00a0 ----------\u00a0\u00a0 ------<\/code><\/div>\n
\u00a0\u00a0<\/code>2315634502\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0 NONC18C\u00a0\u00a0\u00a0\u00a0\u00a0 NONC18C\u00a0\u00a0\u00a0\u00a0\u00a0 standserver1<\/code><\/div>\n
\u00a0\u00a0<\/code>3265600723\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0 NONC18C\u00a0\u00a0\u00a0\u00a0\u00a0 NONC18C\u00a0\u00a0\u00a0\u00a0\u00a0 standserver1<\/code><\/div>\n
* 2315634502\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0 NONC18C\u00a0\u00a0\u00a0\u00a0\u00a0 NONC18C\u00a0\u00a0\u00a0\u00a0\u00a0 primaserver.<\/code><\/div>\n
<\/div>\n
Enter value <\/code>for<\/code> dbid: 3265600723<\/code><\/div>\n
Using 3265600723 <\/code>for<\/code> database<\/code> Id<\/code><\/div>\n
Enter value <\/code>for<\/code> inst_num: 1<\/code><\/div>\n
Using 1 <\/code>for<\/code> instance number<\/code><\/div>\n
<\/div>\n
<\/div>\n
Specify the number <\/code>of<\/code> days <\/code>of<\/code> snapshots <\/code>to<\/code> choose <\/code>from<\/code><\/div>\n
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<\/code><\/div>\n
Entering the number <\/code>of<\/code> days (n) will result <\/code>in<\/code> the most recent<\/code><\/div>\n
(n) days <\/code>of<\/code> snapshots being listed.\u00a0 Pressing\u00a0 without<\/code><\/div>\n
specifying a number lists <\/code>all<\/code> completed snapshots.<\/code><\/div>\n
<\/div>\n
<\/div>\n
Enter value <\/code>for<\/code> num_days:<\/code><\/div>\n
<\/div>\n
Listing <\/code>all<\/code> Completed Snapshots<\/code><\/div>\n
Instance\u00a0\u00a0\u00a0\u00a0 DB <\/code>Name<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0 Snap Id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Snap Started\u00a0\u00a0\u00a0 Snap <\/code>Level<\/code><\/div>\n
------------ ------------ ---------- ------------------ ----------<\/code><\/div>\n
<\/div>\n
NONC18C\u00a0\u00a0\u00a0\u00a0\u00a0 NONC18C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0 24 Sep 2018 16:01\u00a0\u00a0\u00a0 1<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\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>2\u00a0 24 Sep 2018 16:21\u00a0\u00a0\u00a0 1<\/code><\/div>\n
<\/div>\n
<\/div>\n
Specify the <\/code>Begin<\/code> and<\/code> End<\/code> Snapshot Ids<\/code><\/div>\n
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<\/code><\/div>\n
Enter value <\/code>for<\/code> begin_snap: 1<\/code><\/div>\n
Begin<\/code> Snapshot Id specified: 1<\/code><\/div>\n
<\/div>\n
Enter value <\/code>for<\/code> end_snap: 2<\/code><\/div>\n
End<\/code>\u00a0\u00a0 Snapshot Id specified: 2<\/code><\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
Specify the Report <\/code>Name<\/code><\/div>\n
~~~~~~~~~~~~~~~~~~~~~~~<\/code><\/div>\n
The <\/code>default<\/code> report file <\/code>name<\/code> is<\/code> awrrpt_1_1_2.txt.\u00a0 <\/code>To<\/code> use this <\/code>name<\/code>,<\/code><\/div>\n
press\u00a0 <\/code>to<\/code> continue<\/code>, otherwise enter an alternative.<\/code><\/div>\n
<\/div>\n
Enter value <\/code>for<\/code> report_name:<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And viewing the generated report, we can see that the database role is PHYSICAL STANDBY<\/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
WORKLOAD REPOSITORY report <\/code>for<\/code><\/div>\n
<\/div>\n
DB <\/code>Name<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB Id\u00a0\u00a0\u00a0 <\/code>Unique<\/code> Name<\/code> DB Role\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Edition Release\u00a0\u00a0\u00a0 RAC CDB<\/code><\/div>\n
------------ ----------- ----------- ---------------- ------- ---------- --- ---<\/code><\/div>\n
NONC18C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3265600723 NONC18C_SIT PHYSICAL STANDBY\u00a0\u00a0 EE\u00a0\u00a0\u00a0\u00a0\u00a0 18.0.0.0.0 <\/code>NO<\/code>\u00a0 NO<\/code><\/div>\n
<\/div>\n
Instance\u00a0\u00a0\u00a0\u00a0 Inst Num Startup <\/code>Time<\/code><\/div>\n
------------ -------- ---------------<\/code><\/div>\n
NONC18C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 24-Sep-18 15:49<\/code><\/div>\n
<\/div>\n
Host <\/code>Name<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Platform\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CPUs Cores Sockets Memory(GB)<\/code><\/div>\n
---------------- -------------------------------- ---- ----- ------- ----------<\/code><\/div>\n
standserver1.loc Linux x86 64-<\/code>bit<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2.96<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Conclusion<\/strong>
\nIn this blog we have shown how we can use UMF to generate AWR reports in Active Data Guard Instance. The framework UMF use the package DBMS_UMF which has many subprograms. The following note How to Generate AWRs in Active Data Guard Standby Databases (Doc ID 2409808.1)<\/em> and Oracle documentation will help.<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw Since Oracle Database 12c Release 2 (12.2), Automatic Workload Repository (AWR) data can be captured for Active Data Guard (ADG) standby databases. This feature enables analyzing any performance-related issues for ADG standby databases AWR snapshots for ADG standby databases are called remote snapshots. A database node, called destination, is responsible for storing […]<\/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":[59],"tags":[],"type_dbi":[],"class_list":["post-11737","post","type-post","status-publish","format-standard","hentry","category-oracle"],"acf":[],"yoast_head":"\nOracle 18c : Active Data Guard and AWR Reports - dbi Blog<\/title>\n<meta name=\"description\" content=\"Oracle 18c, Active DataGuard, Awr Reports, Diagnostic Pack\" \/>\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-18c-active-data-guard-and-awr-reports\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 18c : Active Data Guard and AWR Reports\" \/>\n<meta property=\"og:description\" content=\"Oracle 18c, Active DataGuard, Awr Reports, Diagnostic Pack\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-25T12:43:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-20T06:35:16+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=\"6 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-18c-active-data-guard-and-awr-reports\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 18c : Active Data Guard and AWR Reports\",\"datePublished\":\"2018-09-25T12:43:05+00:00\",\"dateModified\":\"2023-07-20T06:35:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/\"},\"wordCount\":465,\"commentCount\":2,\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/\",\"name\":\"Oracle 18c : Active Data Guard and AWR Reports - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2018-09-25T12:43:05+00:00\",\"dateModified\":\"2023-07-20T06:35:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"Oracle 18c, Active DataGuard, Awr Reports, Diagnostic Pack\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 18c : Active Data Guard and AWR Reports\"}]},{\"@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 18c : Active Data Guard and AWR Reports - dbi Blog","description":"Oracle 18c, Active DataGuard, Awr Reports, Diagnostic Pack","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-18c-active-data-guard-and-awr-reports\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 18c : Active Data Guard and AWR Reports","og_description":"Oracle 18c, Active DataGuard, Awr Reports, Diagnostic Pack","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/","og_site_name":"dbi Blog","article_published_time":"2018-09-25T12:43:05+00:00","article_modified_time":"2023-07-20T06:35:16+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 18c : Active Data Guard and AWR Reports","datePublished":"2018-09-25T12:43:05+00:00","dateModified":"2023-07-20T06:35:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/"},"wordCount":465,"commentCount":2,"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/","name":"Oracle 18c : Active Data Guard and AWR Reports - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-09-25T12:43:05+00:00","dateModified":"2023-07-20T06:35:16+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"Oracle 18c, Active DataGuard, Awr Reports, Diagnostic Pack","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-active-data-guard-and-awr-reports\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 18c : Active Data Guard and AWR Reports"}]},{"@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\/11737","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=11737"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11737\/revisions"}],"predecessor-version":[{"id":25785,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11737\/revisions\/25785"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11737"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}