Hi,

I backup my database everynight from EM, Database-differential and once a week for Database-complete in tape.

I don't know why if I try to restore the Database-differential from the EM, it gives me an error message: I select the Recovery completion state at "Leave database operational. No additional transactional logs can be restored." However, when I restore the tape from the Database-complete, it works. I just want to know can anyone tells me what did I do wrong?


Also, can I just restore one table instead of the whole datbase? If so, how can I do it?

Finally, can anyone tell me what is the right way to backup my database or any suggest books that I can read for this particular topic?

Thanks a lot.