Could you guys please let us know that Is it possible to generate the awr report when database is down? And why?
Kindly share your views here.
Thanks in advance.
The answer is No. Reason. Oracle records AWR data in awr related tables in sysaux tablespace. This data comes from v$sysstat and v$sys_time_model views. When instance stops and restarted , these views data starts from zero.
Sign up for STechies