Results 1 to 3 of 3

Thread: dgmgrl setting

  1. #1
    Join Date
    Dec 2006
    Posts
    2

    Question Unanswered: dgmgrl setting

    hi all,

    iam new in data guarding in 10G R2 i read oracle book about broker and configuration but whole configuration fail
    i have to windows server to copy of oracle and i install
    to database
    primary :
    GLOBAL NAME: DGPRIM
    SID : DGPRIM

    standby :

    GLOBAL NAME: DGSTAND
    SID : DGSTAND

    both initial parameter set as below
    primary :
    dg_broker_start=true
    standby_management = auto
    remote_archive_enable=false (when i set it true it make a crash as well as log_archive_start)
    log_archive_dest_1= location=c:\temp\archivce(server1)
    i did not configure the dest_2 coz it not mintion in the book
    standby:
    dg_broker_start=true
    standby_management = auto
    remote_archive_enable=false (when i set it true it make a crash as well as log_archive_start)
    log_archive_dest_1= location=c:\temp\archivce (server2)
    standby_archive_destination=c:\temp\archivce (server2)
    also i did not configure the dest_2 coz it not mintion in the book

    i restart the both database then i run the dgmgrl in the primary
    and both of them in open
    and i configure the lsnr and it work prop.
    and i add the services in both
    dgmgrl>
    1- create the configuration
    2- add the standby database
    maxpefromence
    since i enable the configuration
    i have this error
    ora16009 remote arhive log destination must be standby database

    sorry i wrote alote but just to make sure what i did is right
    or i have to do some thing which is not in the book
    and pllllz i need a hand coz realy i lost and i have to submit anfter 1 week
    plz a some details and thanx in advance

  2. #2
    Join Date
    Dec 2006
    Posts
    2
    Quote Originally Posted by 200112262
    hi all,

    iam new in data guarding in 10G R2 i read oracle book about broker and configuration but whole configuration fail
    i have to windows server to copy of oracle and i install
    to database
    primary :
    GLOBAL NAME: DGPRIM
    SID : DGPRIM

    standby :

    GLOBAL NAME: DGSTAND
    SID : DGSTAND

    both initial parameter set as below
    primary :
    dg_broker_start=true
    standby_management = auto
    remote_archive_enable=false (when i set it true it make a crash as well as log_archive_start)
    log_archive_dest_1= location=c:\temp\archivce(server1)
    i did not configure the dest_2 coz it not mintion in the book
    standby:
    dg_broker_start=true
    standby_management = auto
    remote_archive_enable=false (when i set it true it make a crash as well as log_archive_start)
    log_archive_dest_1= location=c:\temp\archivce (server2)
    standby_archive_destination=c:\temp\archivce (server2)
    also i did not configure the dest_2 coz it not mintion in the book

    i restart the both database then i run the dgmgrl in the primary
    and both of them in open
    and i configure the lsnr and it work prop.
    and i add the services in both
    dgmgrl>
    1- create the configuration
    2- add the standby database
    maxpefromence
    since i enable the configuration
    i have this error
    ora16009 remote arhive log destination must be standby database

    sorry i wrote alote but just to make sure what i did is right
    or i have to do some thing which is not in the book
    and pllllz i need a hand coz realy i lost and i have to submit anfter 1 week
    plz a some details and thanx in advance






    plz i need ur help

  3. #3
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Sorry, I have litle (almost none) knowledge of DataGuard (I have done a standby DB configuration once), but here's what the error has to say:
    Code:
    $ oerr ora 16009
    16009, 00000, "remote archive log destination must be a STANDBY database"
    // *Cause:  The database associated with the archive log destination service
    //          name is other than the required STANDBY type database.
    //          Remote archival of redo log files is not allowed to non-STANDBY
    //          database instances.
    // *Action: Take the necessary steps to create the required compatible STANDBY
    //          database before retrying the ARCHIVE LOG processing.
    $
    It looks like the standby_archive_destination needs to be the STANDBY DB archive log destination.

Posting Permissions

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