Re: Recovery Question 7 - 8

Brian,

I wanted to also inform you that there some books that are available freely from Oracle Corporation and on the web. They are called Oracle manuals. You may want to read one of them out of curiosity.

Cecil

"Brian Li" <brian_li_at_newyorklife.com.hk> wrote in message news:3df45b1d.0207142019.10548824_at_posting.google.com...
> Question 7
> What is the their difference?
> ALTER DATABASE OPEN;
> ALTER DATABASE OPEN RESETLOGS;
> ALTER DATABASE OPEN NORESETLOGS;
> When use them?
> How sometimes I call ALTER DATABASE OPEN RESETLOGS;
> sometimes call ALTER DATABASE OPEN;?
>
> Question 8
> What is the their difference?
> recover database;
> recover database until cancel;
> recover database using backup controlfile;
> recover database until cancel using backup controlfile;
> recover database using backup controlfile until cancel;
> What is using backup controlfile? where/what backup controlfile it is
using?
> what until cancel means?
> Please tell me more details.
>
> The above question make me confusing during recovery the database.
>
> Thanks a lot! ^^
>
> Brian
Received on Mon Jul 15 2002 - 07:49:03 CDT