Oracle Data Guard: 03 physical standby database configuration

Tweet

Click here to read the previous post

Now from the primary database start the listener, typing (see the picture below):
lsnrctl start



Then mount the database (see the picture below).



Now you can verify that the listener is listening for the PRIMARY service (see the picture below).



Also from the standby database start the listener, typing (see the picture below):
lsnrctl start



Then mount the database (see the picture below).



Now you can verify that the listener is listening for the STANDBY service (see the picture below).



We have just few work to complete the configuration... From the standby database, in the mount state, type (see the picture below):
selecr sequence#, first_time, next_time from v$archived_log order by sequence#;

Then
alter database recover managed standby database disconnect;



From the primary database type (see the picture below):
alter database open;

and then:
alter system set log_archive_dest_state_2=enable scope=both;

and
select status, error from v$archived_dest where dest_id=2;



Now force a log switch (see the picture below)
alter system switch logfile;



And view that something happened into the standby database :))) (see the picture below)
select sequence#, first_time, next_time from v$archived_log order by sequence#;



And again ...
(see the picture below)



the same results :)))
(see the picture below)