It is unclear what the sequence in your step.

First, after you restored database from tape to disk, database is down at that time, how can you rename datafile using alter datatbase rename file d:\a to e:\a and alter database backup controlfile to trace;

# is not a common in sqlplus. # is a common in server manager which is desupported in oracle 9i. You have to delete the line start with # .


If you want to recreate control file, database have to be in nomount mode. You should shutdown database cleanly ( shutdown )first and run

STARTUP NOMOUNT;

feedback should be:

ORACLE instance started.


Nake sure oracle instance is up.
ERROR at line 1:
ORA-03113: end-of-file on communication channel

your instnace may not running right.

After database is in nomount mode, you can run:

CREATE CONTROLFILE REUSE DATABASE "oracle_db" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 113
LOGFILE
GROUP 1 'C:\ORACLE\ORADATA\oracle_db\REDO01.LOG' SIZE 100M,
GROUP 2 'C:\ORACLE\ORADATA\oracle_db\REDO02.LOG' SIZE 100M,
GROUP 3 'C:\ORACLE\ORADATA\oracle_db\REDO03.LOG' SIZE 100M
DATAFILE
'C:\ORACLE\ORADATA\oracle_db\SYSTEM01.DBF',
'C:\ORACLE\ORADATA\oracle_db\UNDOTBS01.DBF',
'C:\ORACLE\ORADATA\oracle_db\CWMLITE01.DBF',
'C:\ORACLE\ORADATA\oracle_db\DRSYS01.DBF',
'C:\ORACLE\ORADATA\oracle_db\EXAMPLE01.DBF',
'C:\ORACLE\ORADATA\oracle_db\INDX01.DBF',
'C:\ORACLE\ORADATA\oracle_db\TOOLS01.DBF',
'C:\ORACLE\ORADATA\oracle_db\USERS01.DBF'
CHARACTER SET WE8MSWIN1252
;

You should see feedback :
Control file created.

Then you can run
SQL> RECOVER DATABASE

If you only shutdown your database cleanly and run startup nomount and create controlfile script, then there is no need to recover database. you will get following error:

ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required

You can ignore this and go to next step.

ALTER DATABASE OPEN;

You should get feedback:

Database altered.

In your case, you get
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-03114: not connected to ORACLE

This means your oracle instance is not up at all.(startup nomount failed. Reason: I think you did not shutdwon your database first.)


Then you can run

ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\oracle_db\TEMP01.DBF' REUSE;


...................


I think you should run this step by step. Do not run it in one script.