Oracle DBA

1. Primary Database Preparation Ensure the primary database is configured for Data Guard. Check Database Mode SELECT log_mode FROM v$database; Database must be in ARCHIVELOG mode. If not: shutdown immediate;startup mount;alter database archivelog;alter database open; Enable FORCE LOGGING Ensures all operations generate redo. ALTER DATABASE FORCE LOGGING; Verify: SELECT force_logging FROM v$database; Create Standby Redo […]

When building a physical standby database in Oracle Database using Oracle Data Guard, the initialization parameter file (initSTBYDB.ora) defines how the standby database identifies itself and communicates with the primary database.Each parameter orchestrates redo transport, recovery, and file management. Below is a clear explanation of each parameter in your configuration. 1. DB_NAME=PRIMDB Purpose This parameter […]