Skip to Content
avatar image
Former Member

Last Restration

How to check , when the last restoration done through SAP in oracle database.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 24, 2010 at 06:43 AM

    Hi,

    You can get this information from the restoration logs in the SAPBackup folder. The restoration log file will be of the format <filename>.rsb.

    Hope this helps.

    Regards,

    Varadharajan M

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 24, 2010 at 06:43 AM

    Hi, if for restoration are used any external programm (like full backup of your datafiles using Data protector or other tools) you only can check log's generated by this programms. If you use the BRRESTORE or BRRECOVERY for this try to check log's in sapbackup directory .

    P.S. from sap you can check in DB14 transaction.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Can you please check it, i checked and i am sure that it shows restore history of your SAP 'SID' database.

      if not you can also run this script against your database:

      USE MSDB 
      GO 
      
      SELECT *
      FROM RESTOREHISTORY WITH (NOLOCK)
      WHERE (DESTINATION_DATABASE_NAME = 'Change_me')
      ORDER BY RESTORE_DATE DESC

      Thanks

      Mushtaq