Oracle Database Discussions

Hi friends,

Oracle 10g DB Linux


I have Server1(PROD) with oracle DB installed.

Then I cloned it to Server2. and I was able to startup/down the db.
All path directories are identical including the SID.

I shutdown Server1 (cold backup) copy all the dbf to Server2.

Then resume process at Server1 which is in archivelog.
I continued copying archivelog to Server2.

At Server2 I tested a manual standby with cotinuous applying of logs.
This is the steps I did:

login: oracle

$ sqlplus / as sysdba
SQL> startup mount
SQL> recover database using backup controlfile;

( it asked the logs needed available ...almos 5 of them)

then I enter CANCEL after the last applied.

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u02/oracle/PROD/db/apps_st/data/system01.dbf'



Why did I get this error? I am sure I have done it many times before :(
Anything I missed here?


Thanks a lot