甜橘子，专注成都网站制作网站设计与营销型网站建设与优化

QQ :532337155
电话：028-86922220
 
成都网站建设设计

将想法与焦点和您一起共享

Oracle12.2提供了什么功能

这篇文章主要讲解了“Oracle 12.2提供了什么功能”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“Oracle 12.2提供了什么功能”吧！

创新互联公司专注于中大型企业的网站建设、网站设计和网站改版、网站营销服务，追求商业策划与数据分析、创意艺术与技术开发的融合，累计客户1000+，服务满意度达97%。帮助广大客户顺利对接上互联网浪潮，准确优选出符合自己需要的互联网运用，我们将一直专注高端网站设计和互联网程序开发，在前进的路上，与客户一起成长！

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 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

查看AWR报告：

 Oracle 12.2提供了什么功能

感谢各位的阅读，以上就是“Oracle 12.2提供了什么功能”的内容了，经过本文的学习后，相信大家对Oracle 12.2提供了什么功能这一问题有了更深刻的体会，具体使用情况还需要大家实践验证。这里是创新互联，小编将为大家推送更多相关知识点的文章，欢迎关注！


网站栏目：Oracle12.2提供了什么功能
文章出自：http://chengdu.cdxwcx.cn/article/pdggpg.html

其他资讯