Recovery Question 1 - 6

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?

The above question make me confusing during recovery the database.

Thanks a lot! ^^

Brian Received on Sun Jul 14 2002 - 23:15:36 CDT