共計 5320 個字符，預計需要花費 14 分鐘才能閱讀完成。
這篇文章主要講解了“Oracle 12.2 提供了什么功能”，文中的講解內容簡單清晰，易于學習與理解，下面請大家跟著丸趣 TV 小編的思路慢慢深入，一起來研究和學習“Oracle 12.2 提供了什么功能”吧！
Oracle 12.2 提供了收集備庫 AWR 的功能。
確定備庫角色和打開狀態
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
On Primary (CDB)
執行解鎖：
SQL alter user sys$umf identified by sysumf account unlock;
SYS$UMF 用戶默認是 locked 的；該用戶具有 Remote Management Framework (RMF) 有關的所有的視圖和表的權限。
On Primary (CDB) 創建 db_link
create database link dblk_EMNBBETA_TO_EMNBBETAPDG01 CONNECT TO sys$umf IDENTIFIED BY sysumf using LTACTESTPDG01
create database link dblk_EMNBBETAPDG01_TO_EMNBBETA CONNECT TO sys$umf IDENTIFIED BY sysumf using LTACTEST
RMF 拓撲結構中的所有節點必須有一個獨一無二的名字，默認選擇 db_unique_name
On Primary（CDB
執行 ) ,LTACTEST 是主庫 db_unique_name
exec dbms_umf.configure_node (LTACTEST
On Standby，LTACTESTPDG01 是備庫 db_unique_name
exec dbms_umf.configure_node (LTACTESTPDG01 , dblk_EMNBBETAPDG01_TO_EMNBBETA
創建 RMF 拓撲，On Primary：
exec DBMS_UMF.create_topology (EMNBBETA_Topology
驗證目前為止的操作
set line 132
col topology_name format a15
col node_name format a15
select * from dba_umf_topology;
select * from dba_umf_registration;
For example
SQL select * from dba_umf_topology;
TOPOLOGY_NAME TARGET_ID TOPOLOGY_VERSION TOPOLOGY_STATE
——————– ———- —————- ————————
EMNBBETA_Topology 798157014 1 ACTIVE
SQL select * from dba_umf_registration;
TOPOLOGY_NAME NODE_NAME NODE_ID NODE_TYPE AS_SOURCE AS_CANDIDATE_TA STATE
——————– ————— ———- ———- ————— ————— ——————–
EMNBBETA_Topology LTACTEST 798157014 0 FALSE FALSE OK
注冊備庫到 RMF 拓撲中
SQL exec DBMS_UMF.register_node (EMNBBETA_Topology , LTACTESTPDG01 , dblk_EMNBBETA_TO_EMNBBETAPDG01 , dblk_EMNBBETAPDG01_TO_EMNBBETA , FALSE , FALSE
BEGIN DBMS_UMF.register_node (EMNBBETA_Topology , LTACTESTPDG01 , dblk_EMNBBETA_TO_EMNBBETAPDG01 , dblk_EMNBBETAPDG01_TO_EMNBBETA , FALSE , FALSE END;
*
ERROR at line 1:
ORA-15766: already registered in an RMF topology
ORA-06512: at SYS.DBMS_UMF_INTERNAL , line 132
ORA-06512: at SYS.DBMS_UMF_INTERNAL , line 170
ORA-06512: at SYS.DBMS_UMF , line 822
ORA-06512: at line 1
ORA-06512: at SYS.DBMS_UMF , line 794
ORA-06512: at SYS.DBMS_UMF , line 712
ORA-06512: at line 1
解決辦法：
如果遇到了 ORA-15766，那么就執行下面：
SQL exec DBMS_UMF.unregister_node (EMNBBETA_Topology , LTACTESTPDG01
PL/SQL procedure successfully completed.
如果遇到了 ORA-13519: Database id (1730117407) exists in the workload repository，然后重新運行 DBMS_WORKLOAD_REPOSITORY.register_remote_database
exec DBMS_WORKLOAD_REPOSITORY.unregister_remote_database(LTACTESTPDG01 , EMNBBETA_Topology ,TRUE);
注冊到 AWR
exec DBMS_WORKLOAD_REPOSITORY.register_remote_database(node_name= LTACTESTPDG01
PL/SQL procedure successfully completed.
驗證
set line 132
col topology_name format a20
col node_name format a15
SQL select * from dba_umf_topology;
TOPOLOGY_NAME TARGET_ID TOPOLOGY_VERSION TOPOLOGY_STATE
——————– ———- —————- ————————
EMNBBETA_Topology 798157014 6 ACTIVE
SQL select * from dba_umf_registration;
TOPOLOGY_NAME NODE_NAME NODE_ID NODE_TYPE AS_SOURCE AS_CANDIDATE_TA STATE
——————– ————— ———- ———- ————— ————— ——————–
EMNBBETA_Topology LTACTEST 798157014 0 FALSE FALSE OK
EMNBBETA_Topology LTACTESTPDG01 524737559 0 FALSE FALSE OK
SQL select * from dba_umf_service;
TOPOLOGY_NAME NODE_ID SERVICE_ID
——————– ———- ———————
EMNBBETA_Topology 524737559 AWR
用 RMF 創建遠程 snapshot
SQL exec dbms_workload_repository.create_remote_snapshot(LTACTESTPDG01
PL/SQL procedure successfully completed.
如果遇到了 ORA-13516: AWR Operation failed: Remote source not registered for AWR，手動切 2 - 3 個歸檔
alter system switch logfile;
收集備庫 AWR 報告
@?/rdbms/admin/awrrpti.sql
注意是 awrrpti.sql，不是 awrrpt.sql
輸入 dbid 就可以了。
SQL @?/rdbms/admin/awrrpti.sql
Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
AWR reports can be generated in the following formats. Please enter the
name of the format at the prompt. Default value is html .
html HTML format (default)
text Text format
active-html Includes Performance Hub active report
Enter value for report_type: html
Type Specified: html
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
———— ———- ——— ———- ——
524737559 1 LTACTEST LTACTEST ORADB-53154.
* 4166033225 1 LTACTEST LTACTEST ORADB-53163.
Enter value for dbid: 524737559
Using 524737559 for database Id
Enter value for inst_num: 1
Using 1 for instance number
Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing return without
specifying a number lists all completed snapshots.
Enter value for num_days: 1
Listing the last day s Completed Snapshots
Instance DB Name Snap Id Snap Started Snap Level
———— ———— ———- —————— ———-
LTACTEST LTACTEST 1 04 Sep 2019 15:41 1
2 04 Sep 2019 15:42 1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 1
Begin Snapshot Id specified: 1
Enter value for end_snap: 2
End Snapshot Id specified: 2
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_1_2.html. To use this name,
press return to continue, otherwise enter an alternative.
Enter value for report_name:
Using the report name awrrpt_1_1_2.html
查看 AWR 報告：
感謝各位的閱讀，以上就是“Oracle 12.2 提供了什么功能”的內容了，經過本文的學習后，相信大家對 Oracle 12.2 提供了什么功能這一問題有了更深刻的體會，具體使用情況還需要大家實踐驗證。這里是丸趣 TV，丸趣 TV 小編將為大家推送更多相關知識點的文章，歡迎關注！
