0

Is there a way to know until what time a point-in-time recovery of an Oracle database was performed?

I only found references to the columns RESETLOGS_CHANGE# and RESETLOGS_TIME in V$DATABASE, but these times do not necessarily indicate up to which moment the recovery was performed, but rather when the database was opened with the open resetlogs.

Improve this question
3
  • Check the SYS audit trail for the specific restore commands.
    – pmdba
    Commented Jul 8 at 14:40
  • do you mean audit trail or /u01/app/oracle/admin/$SID/adump?
    – Astora
    Commented Jul 8 at 16:47
  • the SYS audit entries are generally written to the file system, though it may depend on your specific instance and version of Oracle.
    – pmdba
    Commented Jul 8 at 17:50

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.