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

MOSC Banner

Oracle 19c Active Data Guard

Hi


I have configured Oracle 19c Data Guard in Oracle Linux 7.8 environment.

I have opened it in read only mode as under :


SQL> alter database recover managed standby database using current logfile disconnect;

SQL> SELECT dest_id,status,database_mode,recovery_mode FROM v$archive_dest_status WHERE status <> 'INACTIVE';


  DEST_ID STATUS  DATABASE_MODE  RECOVERY_MODE

---------- --------- --------------- ----------------------------------

     1 VALID   OPEN_READ-ONLY MANAGED REAL TIME APPLY

     2 VALID   UNKNOWN     IDLE

    32 VALID   UNKNOWN     IDLE


I faced two problems :

  1. I cannot login other than sys user in standby server to check my data.

SQL> conn test1/test321

ERROR:

ORA-01017: invalid username/password; logon denied

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