2017-07-20

Using NetBackup's BPRESTORE command for File Restoration

Got a request today to restore files on /opt/oracle/diag/rdbms/pasx06p/PASX06P/trace and placing them to /data/ora_fra01/diag and since I am a bit lazy and lots of work to do, I did not do it on the GUI.

I used this reference as guide: How to run bprestore

On the destination server I prepared the following files (I am doing the restore on same source and target machine).

$ cat restorefiles.in
change /opt/oracle/diag/rdbms/pasx06p/PASX06P/trace/* to /data/ora_fra01/diag

$ cat filelist.in
/opt/oracle/diag/rdbms/pasx06p/PASX06P/trace

$ sudo /usr/openv/netbackup/bin/bprestore -s 05/19/2017 00:00:00 -e 05/27/2017 00:00:00 -L /tmp/restore-170719.log -R /tmp/restorefiles.in -f /tmp/filelist.in 

Now I am checking on the NetBackup Master Server the status of the job.

# bpdbjobs | grep uxmach01 | head -1
232661         Backup  Done      0                       BRMC_ORACLE_ARCHIVE_SILVER    pasx06tp_archive      uxmach01.np.lan       nbubkmast01      28589      No        

Done!  Files have been restored.

$ ls -l /data/ora_fra01/diag | wc -l
1076


No comments:

Post a Comment