Can someone suggest what is the procedure to migrate the standby database from one server to another. We take "CLOSED BACKUP" on the standby database every alternate day which is on the raw partitions.

We thought of this procedure

1) create all the raw partitions exactly the same as now in the new server.
2) Create the database from a init file of the current machine
3) restore the backup and run a recover command to restore the database.

But when we are trying to create the database it says "cannot read ssystem_01 at this time".

So can someone suggest is this the correct procedure?. If it is the correct procedure then why are we getting the error message?.

Thank you

Sreenivas Sampat


Here is the trace file output

Dump file /oracle/admin/NPICU01/udump/ora_19751_npicu01.trc
Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.0.0 - 64bit Production
ORACLE_HOME = /oracle/product/8.1.7
System name: HP-UX
Node name: porprod1
Release: B.11.11
Version: U
Machine: 9000/800
Instance name: NPICU01
Redo thread mounted by this instance: 1
Oracle process number: 9
Unix process pid: 19751, image: oracle@porprod1

*** SESSION ID:(8.1) 2002-12-17 10:16:07.764
*** 2002-12-17 10:16:07.764
ksedmp: internal or fatal error
ORA-00376: file 1 cannot be read at this time
ORA-01110: data file 1: '/npcu1/fs_dba/dbanpcu1/adm/NPICU01/dbf/NPICU01_system_01'
ORA-00376: file 1 cannot be read at this time
ORA-01110: data file 1: '/npcu1/fs_dba/dbanpcu1/adm/NPICU01/dbf/NPICU01_system_01'
ORA-01501: CREATE DATABASE failed
ORA-00604: error occurred at recursive SQL level 1
ORA-01003: no statement parsed
ORA-00604: error occurred at recursive SQL level 1
ORA-01003: no statement parsed
No current SQL statement being executed.