Generate remote database AWR reports locally
1. Connect to oracle database on the local command line
Sqlplus / nolog
SQL > conn system/oracle@98149
2. Execute the command to generate AWR report
SQL > @? / rdbms/admin/awrrpt.sql
Current Instance
~
DB Id DB Name Inst Num Instance
--
1244647887 ORAL 1 oral
Specify the Report Type
~ ~ ~
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or' text' for plain text
Defaults to 'html'
-enter html here
Enter the value of report_type: html
Type Specified: html
Instances in this Workload Repository schema
~
DB Id Inst Num DB Name Instance Host
--
* 1244647887 1 ORAL oral s11ora11
Using 1244647887 for database Id
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 the number of days to view the report here
Enter a value for num_days: 1
Listing the last day's Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
--
Oral ORAL 17512 23 March 2018 00:00 1
17513 23 March 2018 00:30 1
17514 23 March 2018 01:00 1
17515 23 March 2018 01:30 1
17516 23 March 2018 02:00 1
17517 23 March 2018 02:30 1
17518 23 March 2018 03:00 1
17519 23 March 2018 03:30 1
17520 23 March 2018 04:00 1
17521 23 March 2018 04:30 1
17522 23 March 2018 05:00 1
17523 23 March 2018 05:30 1
17524 23 March 2018 06:00 1
17525 23 March 2018 06:30 1
17526 23 March 2018 07:00 1
17527 23 March 2018 07:30 1
17528 23 March 2018 08:00 1
17529 23 March 2018 08:30 1
17530 23 March 2018 09:00 1
-enter the snap_id of the corresponding time
Specify the Begin and End Snapshot Ids
~ ~
Enter the value of begin_snap: 17529
Begin Snapshot Id specified: 17529
Enter the value of end_snap: 17530
End Snapshot Id specified: 17530
Specify the Report Name
~ ~ ~
The default report file name is awrrpt_1_17529_17530.html. To use this name
Press to continue, otherwise enter an alternative.
-enter directly and generate a report under the command line startup directory path
Enter a value for report_name:
