Category Archives: DataGuard Administration

How does it work?
In a nutshell redolog data is shipped from the source data to the target database through Oracle Net services.
SOURCE
log_archive_dest_1=’localpath/’
INSTANCE NAME:MHGTST
TARGET
log_archive_dest_1=’localpath/’
INSTANCE NAME:STDTST
Creating a Physical Standby
1. Verify that the database is in force logging mode.
SQL>SELECT FORCE_LOGGING FROM v$database;
_________
NO
2. If it is not in force logging mode set the database in force logging mode.
SQL>ALTER [...]