standby database not in sync with primary database - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: standby database not in sync with primary database

  1. #11
    Join Date
    May 2001
    Location
    India
    Posts
    55

    standby soloution

    Hi Anand,

    This is shankar from Bangalore.
    You just verify your production init.ora file
    log_archive_start=true
    log_archive_format="arch_%s_%t.arc"
    log_archive_dest_1 = 'LOCATION=/d3_s1/test/archive/ MANDATORY REOPEN=60'
    log_archive_dest_2 = 'SERVICE=standbytest OPTIONAL REOPEN=60'
    log_archive_dest_state_1 = ENABLE
    log_archive_dest_state_2 = ENABLE

    Then Check your standby init.ora file for the following:

    #log_archive_start=true
    log_archive_format="arch_%s_%t.arc"
    standby_archive_dest=/d3_s1/test/archive
    log_archive_dest=/d3_s1/test/archive


    Primary tnsnames.ora file you should be configure the standby m/c for the following:

    standbytest =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.19.7)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = HLLRSNET)
    )
    )



    first time you have to copy the archive log files to standby archive log destination
    Then
    you have start the standby database in nomount state using following command:
    set oracle_sid
    svrmgr>connect internal
    svrmgr>startup nomount
    svrmgr>alter database mount standby database;
    svrmgr>recover standby database
    type auto

    Automatically will apply the archive logs
    finally it will give error, because that will not exist in the primary itself .

    Then immediately do the following command
    svrmgr>recover managed standby database;

    The above command will do auto matic recovery.


    Regards,

    G.Shankar.


    My id is kgshangs@yahoo.com

  2. #12
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    in Oracle 9i, if you use RECOVER MANAGED STANDBY DATABASE, it will automatically resolve archive gaps.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  3. #13
    Join Date
    Aug 2001
    Location
    uae
    Posts
    21
    anandkl ,
    can u send me an exact procedure for creating a standby db.

  4. #14
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

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