Backup From Log Files
Backup From Log Files
I want to restore data in a database using another computers database log files. How can I do that..........?
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
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
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
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
Who is online
Users browsing this forum: No registered users and 1 guest