High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

strange results in backup

 Hi,

    In primary I see the following results after running dg_prim_diag.sql but after few minutes the arc files get copied to standby. Standby DG_phy_stby_diag.sql script does not return errors.

 a) I see following messages in primary  

SQL> select dest_id "ID",destination,status,target,
          schedule,process,mountid  mid
  from v$archive_dest order by dest_id;

  PRODBCK          ERROR     STANDBY ACTIVE   LGWR       0
                                 INACTIVE  PRIMARY INACTIVE ARCH      0

SQL> select dest_id,status,error from v$archive_dest;

 DEST_ID STATUS    ERROR
-------- --------- -------------------------------------------------------
       1 VALID
       2 ERROR     ORA-03135: Á¬½ÓʧȥÁªÏµ

SQL> select message, timestamp
  2  from v$dataguard_status

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center