2 Replies Latest reply: Apr 15, 2013 1:50 AM by Mahir M. Quluzade RSS

    Error with data gaurd setup 10g

    Rajasekaran_DBA
      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
          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
            Mahir M. Quluzade
            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