cancel
Showing results for 
Search instead for 
Did you mean: 

Delta question

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

dear srinivas,

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

Reg

Former Member
0 Kudos

I have send you doc, Pls check.

*ASSIGN POINTS IF IT HELPS**

MSR

Former Member
0 Kudos

Thanks a lot Srini

I have got your document and found very useful.

Regards

Soujanya

Former Member
0 Kudos

Thanks Souji,

I appreciate your prompt replay.

Regards

MSR

Former Member
0 Kudos

hI,

Could you please send those documents to below id.

regards

raghav

raghav123.rao@gmail.com

Former Member
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

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
0 Kudos

Thanks Anil for your inputs.

Regards

Soujanya

0 Kudos

hi Soujaya,

regarding the backup, may useful following

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

hope this helps.

Former Member
0 Kudos

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
0 Kudos

Thanks Srinivas.That would be great helpful.

Pls send it to soujanya_palavi@rediffmail.com

Regards

Soujanaya

Former Member
0 Kudos

i have send you doc.

    • Assign Points if it helps**

MSR

Former Member
0 Kudos

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

Thanks

Soujanya

Former Member
0 Kudos

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

MSR

Former Member
0 Kudos

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
0 Kudos

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

Former Member
0 Kudos

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

Thanks

Soujanya