Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Recovery Question 7 - 8
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 Sun Jul 14 2002 - 23:21:20 CDT