ORACLE Active Data Guard 环境下 Standby 的 AWR 创建

下面通过实际操作来演示一下在 ORACLE Active Data Guard 环境下，Standby 的 AWR 取得的具体步骤。
参照 Doc ID 2469650.1。

首先，确认一下主库和备库的状态。

■Primary
SQL> select inst_id, open_mode, database_role from gv$database order by 1;

   INST_ID OPEN_MODE            DATABASE_ROLE
---------- -------------------- ----------------
         1 READ WRITE           PRIMARY

■Standby
SQL> select inst_id, open_mode, database_role from gv$database order by 1;

   INST_ID OPEN_MODE            DATABASE_ROLE
---------- -------------------- ----------------
         1 READ ONLY WITH APPLY PHYSICAL STANDBY

在主库上，解锁 sys$umf 用户。

■Primary
SQL> alter user sys$umf identified by rmfuser account unlock;

User altered.

SQL> alter system switch logfile;

System altered.

在主库上，创建主库和备库之间的 DBLINK，并做一下测试。

■Primary
SQL> create database link dbl_primary_to_standby CONNECT TO sys$umf IDENTIFIED BY rmfuser using 'orcl12201_stby';

Database link created.

SQL> create database link dbl_standby_to_primary CONNECT TO sys$umf IDENTIFIED BY rmfuser using 'orcl12201';

Database link created.

■Primary
SQL> select instance_name from v$instance@dbl_primary_to_standby;

INSTANCE_NAME
----------------
orcl12201_stby

SQL> select instance_name from v$instance@dbl_standby_to_primary;

INSTANCE_NAME
----------------
orcl12201

■Standby
SQL> select instance_name from v$instance@dbl_primary_to_standby;

INSTANCE_NAME
----------------
orcl12201_stby

SQL> select instance_name from v$instance@dbl_standby_to_primary;
select instance_name from v$instance@dbl_standby_to_primary
                                     *
ERROR at line 1:
ORA-16000: database or pluggable database open for read-only access

分别在主库和备库上，配置数据库节点以添加到拓扑中。

■Primary
SQL> show parameter DB_UNIQUE_NAME

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_unique_name                       string      orcl12201

SQL> exec dbms_umf.configure_node ('orcl12201');

PL/SQL procedure successfully completed.

■Standby
SQL> show parameter DB_UNIQUE_NAME

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_unique_name                       string      orcl12201_stby

SQL> exec dbms_umf.configure_node ('orcl12201_stby','dbl_standby_to_primary');

PL/SQL procedure successfully completed.

在主库上，创建拓扑。

■Primary
SQL> exec DBMS_UMF.create_topology ('Topology_1');

PL/SQL procedure su