Recover problem
I transferred the files from one server to another and then created the control file in target database.
Below were the steps which I folowed
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00344: unable to re-create online log
'/qaoragridcn_01/app/oracle/product/11203/dbs/oradata/database/alfresqa/redo02.l
og'
ORA-27040: file create error, unable to create file
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 1
SQL> alter database drop logfile group 2;
Database altered.
alter database open resetlogs;
Total System Global Area 1068937216 bytes
Fixed Size 2228344 bytes
Variable Size 675286920 bytes
Database Buffers 385875968 bytes
0