DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: STANDBY DB

  1. #1
    Join Date
    Feb 2001
    Posts
    82
    can a standby database and the primary database exist in one machine? if it's possible, how am I going to startup both db's since they both have the same SID.

    any comments would be very much appreciated....

  2. #2
    Join Date
    Aug 2001
    Posts
    20
    NO,

    The Standby Database always has to be on different machine, It can not be non the same machine, that's what the ILT says.

    Thanks..
    Certified Oracle DBA...

  3. #3
    Join Date
    Feb 2001
    Posts
    82
    is that true???

    I had attended a training in backup and recovery, we configured a standby database on the same machine, the standby database is offline and the primary db is up and running, we transact to the primary db and shutdown it, then we applied the logs to the standby db, and then startup it up.

    any more comments???

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Check Metalink

    Note:1016568.102
    CREATING PRIMARY AND STANDBY DATABASE ON THE SAME MACHINE


    Problem Summary:
    ================
    CREATING PRIMARY AND STANDBY DATABASE ON THE SAME MACHINE


    Problem Description:
    ====================
    You are setting up a Standby database environment in the same machine
    as the primary database.

    1. You issue.....
    alter database create standby controlfile as '$HOME/standby.ctl';
    alter system archive log current;

    2. copy this generated controlfile to directory where you intend to place
    the standby database

    3. Make a copy of the init.ora file to be used by the standby database
    and include the appropriate initialization parameters to point to
    where where the primary database files reside, followed by the
    directory path where the (test) standby database will reside:

    Oracle7 -- db_file_standby_name_convert and log_file_standby_name_convert
    Oracle8 -- db_file_name_convert and log_file_name_convert

    Also edit the control_files parameter to point to the standby
    controlfile

    4. With the primary database shutdown, copy the redo log files
    and database files to the standby directory

    5. With the primary database now up, you try to mount the standby:
    you receive:

    SVRMGR> alter database mount standby database;
    alter database mount standby database
    *
    ORA-01102: cannot mount database in EXCLUSIVE mode


    6. If you shut the primary database down, the command succeeds but then
    you get the same error when trying to open the primary database.

    7. Deleting the lk file made no difference - but maybe that was
    because it was not really deleted as it was being held open by some
    process.


    Problem Explanation:
    ====================
    The failure is because shared memory has already been
    created for this ORACLE SID, and you are attempting to create the same
    shared memory for the same ORACLE SID.

    Solution: SET INIT.ORA PARAMETER ON STANDBY DATABASE

    Solution Description:
    =====================
    1. Shutdown the standby database

    2. Starting with Oracle Release 7.3.3:
    add _standby_lock_name_space= in the init.ora of standby database

    Starting with Oracle Release 8.0.X:
    add lock_name_space= in the init.ora of standby database


    where is a name other than the primary's database name,
    up to 8 characters long
    .
    You can use a naming convention like:
    If Primary db_name = DB1
    set lock_name_space = DB1s

    3. startup nomount standby database

    4. alter database mount standby database


    Solution Explanation:
    =====================
    The above solution works for TESTING standby databases on the
    same machine as the Primary Database.

    Do not, however, use the same machine to keep an actual standby
    database. This defeats the purpose of a standby if your entire
    machine were to crash.


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