Question: how to awr report manually?
Answer: At the SQL prompt, enter: @$ORACLE_HOME/rdbms/admin/awrddrpi.sql. Specify whether you want an HTML or a text report: Enter value for report_type: text.