reset password
Author Message
HelloWorld
Posts: 88
Posted 22:43 Aug 12, 2009 |

Can the DBMS recover from a system crash using Redo-only Recovery? If the answer is no, use an example to explain why.

When it says "recover", does it have to recover everything? or for example, it's ok for it not to be able to recover the commit, since anyway the data has been written to the disk?

Thanks

cysun
Posts: 2935
Posted 08:05 Aug 13, 2009 |
HelloWorld wrote:
...

or for example, it's ok for it not to be able to recover the commit, since anyway the data has been written to the disk?

Thanks

That case is OK.

cysun
Posts: 2935
Posted 08:14 Aug 13, 2009 |
cysun wrote:
HelloWorld wrote:
...

or for example, it's ok for it not to be able to recover the commit, since anyway the data has been written to the disk?

Thanks

That case is OK.

Well, after thinking about it a little bit more, I think that case may not be OK because my interpretation of "not to be able to recover the commit" may be different from yours. If you can show a more concrete example, I can tell you for certain.