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 :
- 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