Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Recovery Question 7 - 8

Recovery Question 7 - 8

From: Brian Li <brian_li_at_newyorklife.com.hk>
Date: 14 Jul 2002 21:21:20 -0700
Message-ID: <3df45b1d.0207142021.1e2601cc@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 Sun Jul 14 2002 - 23:21:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US