Pages

Tuesday, June 19, 2007

Oracle Data Guard: 03 physical standby database configuration

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)

10 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. You Sir, are the BOSS!

    Please keep up the good work, I will be back for more :)

    Thank you very much,
    Arpan.

    ReplyDelete
  3. You Sir, are the BOSS!

    Please keep up the good work, I will be back for more :)

    Thank you very much,
    Arpan.

    ReplyDelete
  4. Thanks for a wonderful post.
    I indeed used it to install my Oracle Dataguard on Solaris.

    My next task is to test the switchover and failover scenarios

    Can you pls provide me with simple instructions to do these 4 scenarios
    1) Switchover primary to standby and standby to primary

    2) Once the scheduled maintenance on (originally) primary and now standby, Restore their original roles, i.e Make the status of the servers as it was before the switchover in step 1)

    Failover scenarios
    1) Failover Primary , check data appearing in Standby ( now promoted to primary)

    2) Once the Dead Primary is restored, Restore their original roles, i.e Make the status of the servers as it was before the switchover in step 1)

    Thanks in advance
    Regards
    Dharmesh

    ReplyDelete
  5. Hi,

    very usefull article. Thanks for sharing.

    ReplyDelete
  6. Awesome blog, thank you so much for sharing such an amazing blog with us. According to Qatar Airways cancellation policy, you can cancel your flight in the following ways:

    Tickets booked through Qatar Airways' website, mobile app, ticket counter, or contact centre are subject to the following restrictions:
    Manage bookings or My Trips are two options.
    on the phone (to a call center).
    If you bought your tickets from a travel agent, you should contact them directly.
    Contact Privilege Club directly for prize tickets.

    ReplyDelete
  7. Many thanks for the efforts you have put into writing this site.

    ReplyDelete