Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Recovery Question
I'm a newbie using Oracle 9i.
I have some questions in the followings, please kindly answer the question.
Question 1
If I lost a control file (no backup),
how can I startup a database?
how can I recover a control file?
Question 2
If I lost all archive log,
how can I recover the database?
Question 3
If I lost all redo log,
how can I recover the database?
Question 4
If I lost all control file, redo log and archive log,
how can I recover the database?
Question 5
About Offline Backup Procedure,
shutdown normal;
copy all datafile to backup folder
copy all control file to backup folder
copy all redo logs to backup folder
copy all archive logs to backup folder
Is it a correct procedure?
Why I have to need to backup redo log only?
Why NOT I have to need to backup archive log?
Question 6
Why NOT I have to backup init.ora?
How can I recover init.ora if I lost it?
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:09:29 CDT