Oracle 10g startup error: ORA-01113:file 1 needs media recovery

See more:

Oracle

Hello Dear friends,

thank you for paying attention.

some days ago, i tried to make a cold backup of my Oracle 10g database, its about 131GB. I just copied the Oradata(Datafiles), oracleHome\database folder and the flash recovery folder when the database was in backup mode and archivelog was enabled.

Now, I'm tring to restore the database, I've installed a new instance of oracle, replaced the oradata folder(datafiles), and oraclehome\Database (contains the spfile and pfile) and I changed all the datafile location with 'alter database rename' and then tried to startup the database, it have been mounted now, but not opened,

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1468006400 bytes
Fixed Size                  1251172 bytes
Variable Size            1065355420 bytes
Database Buffers          394264576 bytes
Redo Buffers                7135232 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF'

I've searched this error a lot, I used the

Recover datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\<datafilename> 

for all the datafiles I have, even I tried the

Recover database;

and all the scripts done well, but at the end, I got this Error:

CSS

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

about recreating the control files and recover them, i should say i tried them all, any idea please experts....