Hi,
I'm stuck with an AWR snapshot generation problem in restricted mode.
During the system releases, I put the database in restricted mode, so the AWR stops generating the snapshots.
I followed these steps, using the solution proposed in (https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=18ecrigqor_4&_afrLoop=402937535786983#FIX)
--------------------------------------------------------------------------------------------------------------------------------------
--1. decrease the interval time to test the snaps
EXECUTE DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS (interval => 10)
--2. Set the parameter _AWR_RESTRICT_MODE = TRUE
alter system set "_AWR_RESTRICT_MODE" = TRUE scope = spfile;
- 3. Restart the database
--4. Put the bank in restricted mode
ALTER SYSTEM ENABLE RESTRICTED SESSION;
-- 5. Wait more than 10 minutes in order to the awr automatically generate the snapshots
--6 Also try to generate the snapshot manually
EXEC dbms_workload_repository.create_snapshot;
--7 set the parameter _AWR_RESTRICT_MODE = FALSE
alter system set "_AWR_RESTRICT_MODE" = FALSE scope = spfile;
--8. Restart the database (this will disable the restricted mode)
--9. Run query to see if any snap was taken during restricted mode
SELECT MAX (begin_interval_time) FROM dba_hist_snapshot;
--------------------------------------------------------------------------------------------------------------------------------------
In step 6, I received the error message:
ora-13516: AWR Operation failed: AWR Schema not initialized
In step 9, there was no snapshot while the database was in restricted mode.
NOTE: I have the option to shut down the listener during the releases, but I'm not sure if this will work (ie the release will run safely and awr will continue to generate the snapshots)
How can I make AWR generate Snapshots in Restricted mode?
OR
How can I execute system releases without using the restricted mode of the database, in order to let the AWR generating the snapshots?
Thanks in advance.
Vitor Humia Fontoura