Posts

Showing posts from 2023

Dataguard Configuration steps

  Dataguard Configuration step by steps Primary Server Configurations: Primary Sever Name : TestDB <Step – 1 > Enable Archive log: <Step – 1 > Primary database is in No Archive Mode, Enable it: SQL> archive log list; Database log mode              Archive Mode Automatic archival             Enabled Archive destination            USE_DB_RECOVERY_FILE_DEST Oldest online log sequence     10 Next log sequence to archive   12 Current log sequence           12 <Step – 2 > Enable force logging with the help of following SQL command: SQL> ALTER DATABASE FORCE LOGGING; Database altered. <Step – 3 > Verify initialization parameters db_name and db_unique_name on primary, In my case those are set to: testdb SQL> show parameter db_name NAME                          ...