sqlplus / as sysdba

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~  This script will extract the AWR data for a range of snapshots  ~
~  into a dump file.  The script will prompt users for the   ~
~  following information:   ~
~     (1) database id   ~
~     (2) snapshot range to extract   ~
~     (3) name of directory object   ~
~     (4) name of dump file   ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Databases in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   DB Id     DB Name  Host
------------ ------------ ------------
* 4088169774 S19C  
* 4088169774 S19C  
* 4088169774 S19C  
* 4088169774 S19C  

The default database id is the local one: '4088169774'.  To use this
database id, press <return> to continue, otherwise enter an alternative.

Enter value for dbid: 4088169774

Using 4088169774 for Database ID

Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed.  Pressing <return> without
specifying a number lists all completed snapshots.

Enter value for num_days: 

Listing all Completed Snapshots

DB Name        Snap Id  Snap Started
------------ --------- ------------------
STORE19C 33570 14 Jan 2025 01:00
 33571 14 Jan 2025 02:00
 33572 14 Jan 2025 03:00
 33573 14 Jan 2025 04:00
 33574 14 Jan 2025 05:00
 33575 14 Jan 2025 06:00
 33576 14 Jan 2025 07:00
 33577 14 Jan 2025 08:00
 33578 14 Jan 2025 09:00
 33579 14 Jan 2025 10:00
 33580 14 Jan 2025 11:00

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 33581
Begin Snapshot Id specified: 33581

Enter value for end_snap: 33583
End   Snapshot Id specified: 33583

Specify the Directory Name
~~~~~~~~~~~~~~~~~~~~~~~~~~
Directory Name       Directory Path
------------------------------ -------------------------------------------------
DATA_PUMP_DIR         /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/log/
DBMS_OPTIM_ADMINDIR   /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/admin
DBMS_OPTIM_LOGDIR     /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs

Choose a Directory Name from the above list (case-sensitive).

Enter value for directory_name: EM_IMP_WKLD_1736858329638

Using the dump directory: EM_IMP_WKLD_1736858329638

Specify the Name of the Extract Dump File
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The prefix for the default dump file name is awrdat_33581_33583.
To use this name, press <return> to continue, otherwise enter
an alternative.

Enter value for file_name: 

Using the dump file prefix: awrdat_33581_33583
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|  The AWR extract dump file will be located
|  in the following directory/file:
|   /temp/REPOSITORIO
|   awrdat_33581_33583.dmp
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|  *** AWR Extract Started ...
|
|  This operation will take a few moments. The
|  progress of the AWR extract operation can be
|  monitored in the following directory/file:
|   /temp/REPOSITORIO
|   awrdat_33581_33583.log
|

End of AWR Extract