oracle备库收集awr,Oracle 12.2 physical standby备库收集AWR报告

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