10 Replies Latest reply: Jun 25, 2010 12:30 AM by KSG RSS

    Data Guard has been configured but the log not shipped successfully

    548150
      I am creating a 10g physical standby database on a OEL5.0 system. It seems the Data Guard configuration is successful. But some error messages listed on the alert.log file and the standby database can not receive the shipped logs.I copied the password file to stanby's host. But it shows insufficent previleges.
      SQL> startup mount
      ORACLE instance started.

      Total System Global Area 448790528 bytes
      Fixed Size 1219928 bytes
      Variable Size 130024104 bytes
      Database Buffers 314572800 bytes
      Redo Buffers 2973696 bytes
      Database mounted.
      SQL> alter database recover managed standby database disconnect from session;
      Database altered.
      SQL> select sequence#,first_time,next_time from v$archived_log order by sequence#;

      no rows selected

      SQL> archive log list;
      Database log mode Archive Mode
      Automatic archival Enabled
      Archive destination /u01/app/oracle/archive/stdby10g/
      Oldest online log sequence 0
      Next log sequence to archive 0
      Current log sequence 0
      -------------------
      The following messages comes from the alert.log file:
      Redo shipping client performing standby login
      OCISessionBegin failed -1
      .. Detailed OCI error val is 1034 and errmsg is 'ORA-01034: ORACLE not available
      '
      *** 2008-07-06 20:30:58.468 60679 kcrr.c
      Error 1034 received logging on to the standby
      Error 1034 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'stdby10g'
      Error 1034 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'stdby10g'
      ORA-01034: ORACLE not available
      *** 2008-07-06 20:30:58.469 60679 kcrr.c
      PING[ARCp]: Heartbeat failed to connect to standby 'stdby10g'. Error is 1034.
      *** 2008-07-06 20:30:58.469 58941 kcrr.c
      kcrrfail: dest:2 err:1034 force:0 blast:1
      kcrrwkx: nothing to do (end)
      *** 2008-07-06 20:31:58.468
      kcrrwkx: nothing to do (end)
      Redo shipping client performing standby login
      OCISessionBegin failed -1
      .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
      .......

      Message was edited by:
      frank.qian