This discussion is archived
2 Replies Latest reply: Apr 14, 2013 11:50 PM by MahirM.Quluzade RSS

Error with data gaurd setup 10g

Rajasekaran_DBA Newbie
Currently Being Moderated
Hi All,

i am new to oracle DBA. for practice purpose i am try to create a Datagaurd. i am getting following error in the alert log as below. please guide me to configure the data gaurd.

log as below:-


Errors in file /u01/app/oracle/product/10.2.0/db_1/admin/ourdb/udump/ourdb_rfs_3790.trc:
ORA-16009: remote archive log destination must be a STANDBY database
Fri Dec 2 16:09:02 2005
Errors in file /u01/app/oracle/product/10.2.0/db_1/admin/ourdb/bdump/ourdb_arch_3752.trc:
ORA-16009: remote archive log destination must be a STANDBY database
Fri Dec 2 16:09:02 2005
PING[ARCh]: Heartbeat failed to connect to standby 'ourdb'. Error is 16009.

Regards, Raja
  • 1. Re: Error with data gaurd setup 10g
    saratpvv Journeyer
    Currently Being Moderated
    Don't forgot to provide your database version number..?

    The Basic cause of this error is
    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.
    Also post your configuration of log_archive_dest_n parameter from your PRIMARY & STANDBY DATABASE
  • 2. Re: Error with data gaurd setup 10g
    MahirM.Quluzade Guru
    Currently Being Moderated
    Can you check you standby side database role?

    On standby side:
    select database_role from v$database; 
    and can you paste here your pfiles ?


    Regards
    Mahir M. Quluzade

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points