How to generate AWR report in RAC

Following Scripts help us to Generate AWR Reports in Oracle RAC Databases

awrrpt.sql

This will generate the one report for the database across all the nodes(i.e for all instances) for a particular snapshot range.

awrrpti.sql

This will generate report for a particular instance, i.e for a 2 node RAC database , there will be two reports( one for each instance).

Login to Particular Instance - to Find the stats using AWR Report.

SQL> @$ORACLE_HOME/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:




Type Specified:  html





Instances in this Workload Repository schema

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


   DB Id     Inst Num DB Name      Instance     Host

------------ -------- ------------ ------------ ------------

  229213524         1 prod       prod1      rac1

* 229213524         2 prod       prod2      rac2




Enter value for dbid: 229213524

Using 229213524 for database Id

Enter value for inst_num: 1 ------------------->>> Here you need to the pass the instance number

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




                                                        Snap

Instance     DB Name        Snap Id    Snap Started    Level

------------ ------------ --------- ------------------ -----

PROD1      PROD            1344 23 Apr 2020 09:00      1

                           1345 23 Apr 2020 09:00      1

                           1346 23 Apr 2020 010:00      1

                           1347 23 Apr 2020 03:00      1

                           1348 28 Apr 2020 04:00      1

                           1349 28 Apr 2020 05:00      1

                           1350 28 Apr 2020 06:00      1

                           1351 28 Apr 2020 07:00      1

                           1352 28 Apr 2020 08:00      1

                           1353 28 Apr 2020 09:00      1

                           1354 28 Feb 2020 10:00      1

                           1355 28 Feb 2020 11:00      1



Specify the Begin and End Snapshot Ids

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Enter value for begin_snap: 1334

Begin Snapshot Id specified: 1334




Enter value for end_snap: 1335

End   Snapshot Id specified: 1335




Specify the Report Name

~~~~~~~~~~~~~~~~~~~~~~~

The default report file name is awrrpt_1_1334_1335.html.  To use this name,

press  to continue, otherwise enter an alternative.




Enter value for report_name:



Using the report name awrrpt_1_1334_1335.html