Delta question

[Former Member]

Dear Gurus,

Pls help me with your inputs on the below question asked by our client.

We are taking backup of BI production on two days once.Assume that today on 27th BI production server is crashed after the daily dataload.

Now,We have no other option and have to restore the of 25th backup.But deltas are already loaded into BW on 26th and 27th.So now we have lost two days delta records.

How we can get/recover the delta records into BW for 26th and 27th dates?.

Pls help

Thanks in advance

Soujanya

[Former Member · Accepted solution]

dear srinivas,

can you please send me the document to ramanath.kumar@gmail.com.

Reg

[Former Member · Accepted solution]

I have send you doc, Pls check.

*ASSIGN POINTS IF IT HELPS**

MSR

[Former Member · Accepted solution]

Thanks a lot Srini

I have got your document and found very useful.

Regards

Soujanya

[Former Member · Accepted solution]

Thanks Souji,

I appreciate your prompt replay.

Regards

MSR

[Former Member · Accepted solution]

hI,

Could you please send those documents to below id.

regards

raghav

raghav123.rao@gmail.com

[Former Member · Accepted solution]

Hi,

Could you please send this documents at talktoneeraj@gmail.com. It would be a great help for me becuse this type of problem may come in my project.

Thanks ain advance

Neeraj

[Former Member]

Hi,

Repair request can help us to bring the records which were created on 25,26 and 27th. But this will not help us to bring the modifications occured on 25,26 and 27th of the documents whose creation date <25th.

So you better to plan go for backup every day.Other wise you need to go for delta init in case of crash, which is a big execercise.

With rgds,

Anil Kumar Sharma .P

[Former Member]

Thanks Anil for your inputs.

Regards

Soujanya

[edwin_harpino]

hi Soujaya,

regarding the backup, may useful following

Note 731682 - Backup in BW and OLTP: Experiences, risks & recommendations

hope this helps.

[Former Member]

hi SoujayA,

Give your ID, i will send a document which i have prepared my Last project same issues.

Hope that will help you..?

Regards

MSR

[Former Member]

Thanks Srinivas.That would be great helpful.

Pls send it to soujanya_palavi@rediffmail.com

Regards

Soujanaya

[Former Member]

i have send you doc.

• Assign Points if it helps**

MSR

[Former Member]

Still I haven't recd yet.Could you pls resent again to soujanya_palavi@rediffmail.com.

Thanks

Soujanya

[Former Member]

You must receve the document, Let me know you comments on this.

MSR

[Former Member]

Hi Srini,

Sorry to trouble you..I just rechecked my mail box.Still I didn't receive the document.

Could you pls forward again to soujanya_palavi@rediffmail.com?

Regards

Soujanya

Message was edited by:

Soujanya

[Former Member]

I dont think you have a choice but to do a selective full load for those two days.

[Former Member]

Do you mean that we should go for Repair full request?..

Thanks

Soujanya