Oracle Database Discussions

Hi,

i would like to restore a database to another server

source server: oracle 9.2.0.6.0/solaris

in destination server i installed oracle 9.2.0.1 (only software) and applied Release 2 (9.2.0.6) Patch

i restored all the datafiles, redolog files, controlfiles (cold backup) to destination server and kept all the files in required path:

in destination server:

bash-3.00$ sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.6.0 - Production on Mon Oct 13 17:24:48 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

SQL> startup nomount pfile='/oracle1/oracle/product/9.2.0/dbs/initvoipdb.ora';
ORACLE instance started.

Total System Global Area 488082184 bytes
Fixed Size 731912 bytes
Variable Size 268435456 bytes
Database Buffers 218103808 bytes
Redo Buffers 811008 bytes
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying controlfile, check alert log for more info

in alert log file:

alter database mount
Mon Oct 13 17:28:00 2008
ORA-00202: controlfile: '/oracle1/oradata/voipdb/cont
rol03.ctl'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Mon Oct 13 17:28:03 2008
ORA-205 signalled during: alter database mount...



is anything i missed suggestion is greately appreciated.


Thanks

Prakash

Edited by: prakasha4u@rediffmail.com on Oct 13, 2008 5:09 AM