Before creating a physical standby database you must first ensure the primary database is properly configured. Configuration Overview Primary database: cdb1 (cdb1) Standby database: cdb1 (cdb1_stb) Physical Hardware: Must be exactly the same ( Hardware/OS/filesystem ) Oracle Home Location: Must be the same location ( can be different but not recommended ) Database open modes:- Primary - Open Mode Standby - Mount Mode Preparing the primary database for physical standby database creation On the primary database make sure you have performed the following tasks below:- Note!! Perform these tasks only once. After you have completed these steps, the database is prepared to serve as the primary database for one or more standby databases. Changes on Primary Database Enable force Logging: Place the primary database in FORCE LOGGING mode. SQL> ALTER DATABASE FORCE LOGGING; SQL> SELECT name, force_logging FROM v$database; When you issue this ...
Practical tips for smarter database work