Shulou(Shulou.com)05/31 Report--

This article mainly explains "what function does Oracle 12.2 provide". The content of the explanation in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn what function Oracle 12.2 provides.

Oracle 12.2 provides the ability to collect repository AWR.

Determine the role and open status of the standby library

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) performs unlocking:

SQL > alter user sys$umf identified by sysumf account unlock

The SYS$UMF user defaults to locked; this user has permissions for all views and tables related to Remote Management Framework (RMF).

On Primary (CDB) create 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'

All nodes in the RMF topology must have a unique name. Db_unique_name is selected by default.

On Primary (CDB execution), LTACTEST is the main library db_unique_name

Exec dbms_umf.configure_node ('LTACTEST')

On Standby,LTACTESTPDG01 is the repository db_unique_name.

Exec dbms_umf.configure_node ('LTACTESTPDG01','dblk_EMNBBETAPDG01_TO_EMNBBETA')

Create a RMF topology, On Primary:

Exec DBMS_UMF.create_topology ('EMNBBETA_Topology')

Verify the operation so far

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

Register the repository to the RMF topology

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

Solution:

If ORA-15766 is encountered, execute the following:

SQL > exec DBMS_UMF.unregister_node ('EMNBBETA_Topology',' LTACTESTPDG01')

PL/SQL procedure successfully completed.

If you encounter ORA-13519: Database id (1730117407) exists in the workload repository, then rerun DBMS_WORKLOAD_REPOSITORY.register_remote_database

Exec DBMS_WORKLOAD_REPOSITORY.unregister_remote_database ('LTACTESTPDG01',' EMNBBETA_Topology',TRUE)

Register with AWR

Exec DBMS_WORKLOAD_REPOSITORY.register_remote_database (node_name= > 'LTACTESTPDG01')

PL/SQL procedure successfully completed.

Verification

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

Create a remote snapshot with RMF

SQL > exec dbms_workload_repository.create_remote_snapshot ('LTACTESTPDG01')

PL/SQL procedure successfully completed.

If you encounter ORA-13516: AWR Operation failed: Remote source not registered for AWR, manually cut 2-3 archives

Alter system switch logfile

Collect and prepare AWR reports

@? / rdbms/admin/awrrpti.sql

Note that it is awrrpti.sql, not awrrpt.sql

Just type 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 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 to continue, otherwise enter an alternative.

Enter value for report_name:

Using the report name awrrpt_1_1_2.html

View the AWR report:

Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.