Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DB2 restore using physical datafiles.

Hi all,

We are facing a problem to restore BWQ's database using BWP's backup. We are using netbackup and this tool calls a script to perform backup daily. Db2 command looks like this in script "CMD_LINE="db2 BACKUP DATABASE $MY_DB2 ONLINE $MY_SCHED LOAD $MY_LIB OPEN 4 SESSIONS BUFFER 1024"".

However Netbackup only restore datafiles eg. /db2/BWQ/sapdata2/db2bwq/NODE0000/BWQ/T0000023/C0000004.LRG. It restored all BWP's physical files into BWQ's directory and we are not able to bring BWQ's database UP.

My problem here was, is it possible to restore BWQ using only those datafiles?? i've gone thru alot of sites & forum hence nothing was being helpful. Please let me know if this is possible?

I've started to worried with the way we are taking backup now. Need to figure out the proper way of taking backup after this.



Not what you were looking for? View more on this topic or Ask a question