Forum Stats

  • 3,769,801 Users
  • 2,253,023 Discussions
  • 7,875,210 Comments

Discussions

Is there a way to find out the last restore history

ANNEC
ANNEC Member Posts: 298 Bronze Badge

Is there a way to find out the most recent restore history of a database?

Like when the restore happened, and what backup it used, need to know original backup server and backup date for the backup file?


Thanks

Answers

  • evgenyg
    evgenyg Member Posts: 337 Bronze Badge

    Very much depends on how you doing your backups/restores.

    For example, immediate questions:

    What it means "original backup server"

    "Backup date" is when the backup taken or when the "backup file" got created?

    What your intention when you write "backup file"?

  • ANNEC
    ANNEC Member Posts: 298 Bronze Badge

    Our database is refreshed by duplication from prod to a dev environment.

    I know when it was restored, but I don't know what copy of backup files it used. Especially the date the backup is done.

    I would like to know the date of that copy of database, then I will use the same date for other backup/restore to another environment.

    Thanks

  • evgenyg
    evgenyg Member Posts: 337 Bronze Badge

    I like it:  "refreshed by duplication". There at least several ways to duplicate database .

    Starting with trivial RMAN, SRDF, Copy files, Data Guard, and some not so obvious like NetApp snapshot et cetera .

    But I guess whoever did for you the work can answer which files he/she used.

    ANNEC
  • ANNEC
    ANNEC Member Posts: 298 Bronze Badge

    Thanks, I found it, in the RMAN duplication log file. I can see the backup set time. and the server name

  • evgenyg
    evgenyg Member Posts: 337 Bronze Badge

    Nice, so you using rman for duplication.

This discussion has been closed.