Hi owise,

Your posts looked like you were asking the same question, hence I merged them. You should mention what operating system you use and how you do your backups. Since the steps will depend on what operating system you are using. You can look at http://tahiti.oracle.com to find version 9i and the install guide for your OS. You can also look at the backup and recovery guide for how to backup an Oracle database and how to restore.

It seems as though you want someone to write down all of the steps on how to be a DBA. And someone did at, http://tahiti.oracle.com.