migrating standby database to another server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: migrating standby database to another server

  1. #1
    Join Date
    Oct 2002
    Posts
    9

    migrating standby database to another server



    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.
    sreenivas sampat

  2. #2
    Join Date
    Nov 2000
    Posts
    224
    Why don't you create new standby database on the new server itself. Follow the procedure to create standby database.

  3. #3
    Join Date
    Oct 2002
    Posts
    9
    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.
    sreenivas sampat

  4. #4
    Join Date
    Nov 2000
    Posts
    224
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width