Oracle Database Discussions

When I am Practicing Restore and Recover the Database by using cold backup I got some errors .Pls suggest me how to resolve this.

1.I have taken coldbackup
2.I performed some DML Operations on the tables available in the test_del.dbf
3.I removed all datafiles,controlfiles and redologfiles.
4.Now i am doing restore and recovery of the entire database.
5.To Perform restore and recovery
I Shut down the database by using shutdown abort command.

6.Went to the operating system level and then i restored all datafiles,controlfiles,
redolog files from backup location to the original location.
7. Bring the database to mount state.
8.I issued the following command to recover the database.
sql>alter database recover automatic using backup controlfile until cancel;
9.I am getting the following errors.How to resolve this.

SQL> alter database recover automatic using backup controlfile until cancel;
alter database recover automatic using backup controlfile until cancel
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 9 is unknown - rename to correct file
ORA-01110: data file 9: '/u01/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00009'
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01111: name for data file 9 is unknown - rename to correct file
ORA-01110: data file 9: '/u01/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00009'

10.when I listed the datafiles it is displayed as follows.

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl/system01.dbf
/u01/app/oracle/oradata/orcl/undotbs01.dbf
/u01/app/oracle/oradata/orcl/sysaux01.dbf
/u01/app/oracle/oradata/orcl/users01.dbf
/u01/app/oracle/oradata/orcl/example01.dbf
/u01/app/oracle/oradata/orcl/rmandf.dbf
/u01/app/oracle/oradata/orcl/ravidf1.dbf
/u01/app/oracle/oradata/orcl/ravidf2.dbf
/u01/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00009

11.Before recovery the datafiles would be look like this.

SQL> select file_name,tablespace_name,bytes from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME BYTES
------------------------------ ----------
/u01/app/oracle/oradata/orcl/users01.dbf
USERS 5242880

/u01/app/oracle/oradata/orcl/sysaux01.dbf
SYSAUX 283115520

/u01/app/oracle/oradata/orcl/undotbs01.dbf
UNDOTBS1 26214400


FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME BYTES
------------------------------ ----------
/u01/app/oracle/oradata/orcl/system01.dbf
SYSTEM 513802240
/u01/app/oracle/oradata/orcl/example01.dbf
EXAMPLE 104857600

/u01/app/oracle/oradata/orcl/rmandf.dbf
RMANTS 52428800

FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME BYTES
------------------------------ ----------
/u01/app/oracle/oradata/orcl/test_del.dbf
TEST_DEL 2097152

/u01/app/oracle/oradata/orcl/ravidf1.dbf
RAVITBS 20971520

/u01/app/oracle/oradata/orcl/ravidf2.dbf
RAVITBS 20971520


9 rows selected.

Thanks and Regards
Babu