Dataguard - why transport is LGWR is not good?
Hello, I new in Dataguard issues.
Recently I setup Active dataguard in lab environment this way:
tnsnames.ora (both)
PRIM_DB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ebstestfixdb)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = EBSTPF) ) )
STBY_DB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ebscapadb) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = EBSTB) ) )
Primary DB
HOST = ebstestfixdb
PORT = 1521
SID=EBSTPF
Standby DB
HOST = ebscapadb
PORT = 1521
SID=EBSTB
1) In Primary DB:
$ sqlplus / as sysdba
SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(EBSTPF,EBSTB)';
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2 = 'SERVICE=stby_db COMPRESSION=ENABLE ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=EBSTB';