RSS:
Publications
Comments

Category Archives: DataGuard Administration

Standby – Primary and Logical Standby Database version

Standby – Primary and Logical Standby Database version

Standby Database

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 [...]

DataGuard Switch Over

DataGuard Switch Over

Switch from Standby to Primary

Switch from Standby to Primary

Data Guard Operation Modes

Data Guard Operation Modes