Hello all,
RHEL 5, 11g R2
DB was hung at 10:15 am; am trying to get an AWR Report from 10 to 10:30 am
but the package failed because there was a shutdown in the midle (the DB
was restarted to become online again).
Do any know if there's a way to generate the AWR Report from 10:00 am to
the time the last statistic was generated?
The files are sequencial and does not let me get it:
Using 3097553944 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 <return> 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
------------ ------------ --------- ------------------ -----
KMMMESV1P KMMMESV1 14356 11 Jul 2016 00:00 1
14357 11 Jul 2016 00:30 1
14358 11 Jul 2016 01:00 1
14359 11 Jul 2016 01:30 1
14360 11 Jul 2016 02:00 1
14361 11 Jul 2016 02:30 1
14362 11 Jul 2016 03:00 1
14363 11 Jul 2016 03:30 1
14364 11 Jul 2016 04:00 1
14365 11 Jul 2016 04:30 1
14366 11 Jul 2016 05:00 1
14367 11 Jul 2016 05:30 1
14368 11 Jul 2016 06:00 1
14369 11 Jul 2016 06:30 1
14370 11 Jul 2016 07:00 1
14371 11 Jul 2016 07:30 1
14372 11 Jul 2016 08:00 1
14373 11 Jul 2016 08:30 1
14374 11 Jul 2016 09:00 1
14375 11 Jul 2016 09:30 1
14376 11 Jul 2016 10:00 1
14377 11 Jul 2016 10:36 1
14378 11 Jul 2016 11:00 1
14379 11 Jul 2016 11:30 1
14380 11 Jul 2016 12:00 1
14381 11 Jul 2016 12:30 1
14382 11 Jul 2016 13:00 1
14383 11 Jul 2016 13:30 1
14384 11 Jul 2016 14:00 1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 14376
Begin Snapshot Id specified: 14376
Enter value for end_snap: 14377
End Snapshot Id specified: 14377
declare
*
ERROR at line 1:
ORA-20200: The instance was shutdown between snapshots 14376 and 14377
ORA-06512: at line 42
David Ramírez Reyes
Profesión: Padre de Familia y DBA en mis ratos libres
Profession: Parent and DBA in my spare time
