Forum Discussion

DPO's avatar
DPO
Level 6
11 years ago
Solved

Identify the last full backup start,end times , backupsize and tapes required to restore

I have got a requirement Ito dentify the last successful full backup with start,end times , backupsize and tapes required to restore for an Oracle full backup. Can you help me with a command/script ?

7.5
Backup and Recovery
Linux
NetBackup
Tip-How to
  • RamNagalla's avatar
    RamNagalla
    11 years ago

    bpimagelist command from the netabckup can help, but since you are looking for oracle Full backup, its better to find /get the backup start and end time details from Rman or DBA team and use the time range in bpimagelist command to find the rest of the details.

    because for oracle DB, all jobs looks same in netbackup end its not possible to find what is is full and incr, and with its started and ended as it also have the mutliple streams for each DB.

     

4 Replies

Sort By
  • DPO's avatar
    DPO
    Level 6
    11 years ago

    My requirement is : I want to identify the last successful full backup of an Oracle database. Backup duration of it along with the media details,size

  • RamNagalla's avatar
    RamNagalla
    Moderator
    11 years ago

    bpimagelist command from the netabckup can help, but since you are looking for oracle Full backup, its better to find /get the backup start and end time details from Rman or DBA team and use the time range in bpimagelist command to find the rest of the details.

    because for oracle DB, all jobs looks same in netbackup end its not possible to find what is is full and incr, and with its started and ended as it also have the mutliple streams for each DB.

     

  • DPO's avatar
    DPO
    Level 6
    11 years ago

    I have an external audit and their requirement is to pull the above details from NB end. I agree that bpimagelist is a nice command. But hope you understood what is my (auditor ) requirement. I guess Opscenter also doesn't show what I'm looking for. We might need to use various reports. I want something like backup start time, end time, size, media