migrating standby database to another server

:confused:

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.

Why don't you create new standby database on the new server itself. Follow the procedure to create standby database.

That is what we were doing Mr sharma. We were creating the database on the new server when we encountered the error. So we were wondering if we were doing the right thing or not.

I am sorry I got confused as your wrote you want to migrate standby database from one machine to another. I thought you are takinga backup of standby database using that to migrate. Any way, I will follow the following steps to create the standby database,

Try to use the same init.ora file as on primary database

1) Backup the datafiles for the primary database
2) Create standby database controlfile
3) Archive the primary database's current online redo logs
4) Transfer the archived logs, data files and control file to standby machine
5) Mount the standby database. (alter database mount standby database)
6) recover standby database.

At want point you are getting the error.