Page 1 of 1
Backup From Log Files
Posted: Thu Sep 13, 2007 2:57 am
by mazhar_83
I want to restore data in a database using another computers database log files. How can I do that..........?
Posted: Mon Oct 01, 2007 12:18 am
by amirtai
Hi
Can you please elaborate your question. Are you trying to apply logs from primary database to standby database? or it's a raplication issue.
Thanks
Posted: Thu Oct 18, 2007 1:57 am
by mazhar_83
Hi,
e.g. I install my database on D:\ and my OS on C:\. Some how my OS crashes, I have log files on D:\. I need to get back all the data stored in my database which is actually in those files. If I install database and replace these log files my database can't work. I guess there must some way to solve this problem. So please reply if any one knows
Thanks
Posted: Mon Nov 12, 2007 2:45 am
by amirtai
Hi there,
You need to perform PIT (point in time) Recovery. As long as you provide your correct archive log files required by database you'll be able to recover as much as data. That's called roll forward and once you are finished with all of your archive log files it'll perform rollback of all uncommited transaction from redo log files.
Have fun.
Amir