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:

Anonymous said...
This comment has been removed by a blog administrator.
Unknown said...

You Sir, are the BOSS!

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

Thank you very much,
Arpan.

Unknown said...

You Sir, are the BOSS!

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

Thank you very much,
Arpan.

dharmbhai said...

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

Rahul said...

Hi,

very usefull article. Thanks for sharing.

oakleyses said...

oakley sunglasses, prada handbags, oakley sunglasses, longchamp handbags, longchamp handbags, louboutin shoes, louis vuitton handbags, coach factory outlet, tiffany and co, coach purses, louis vuitton outlet, polo ralph lauren outlet, air max, prada outlet, longchamp outlet, oakley sunglasses cheap, ray ban sunglasses, louboutin outlet, michael kors outlet, michael kors outlet, tiffany and co, burberry outlet, christian louboutin shoes, coach outlet store online, jordan shoes, polo ralph lauren outlet, louboutin, kate spade handbags, michael kors outlet, coach outlet, air max, gucci outlet, michael kors outlet, ray ban sunglasses, chanel handbags, michael kors outlet, tory burch outlet, nike free, kate spade outlet, louis vuitton outlet, burberry outlet, louis vuitton outlet stores, louis vuitton, nike shoes, michael kors outlet

oakleyses said...

abercrombie and fitch, instyler, ghd, bottega veneta, ugg boots, jimmy choo outlet, soccer shoes, ugg pas cher, herve leger, beats by dre, birkin bag, abercrombie and fitch, north face jackets, soccer jerseys, mont blanc, rolex watches, lululemon outlet, celine handbags, nike roshe run, nike trainers, giuseppe zanotti, hollister, wedding dresses, nike huarache, mcm handbags, vans shoes, chi flat iron, babyliss pro, north face outlet, nike roshe, ugg australia, ugg, marc jacobs, barbour, nfl jerseys, p90x, new balance shoes, asics running shoes, ferragamo shoes, mac cosmetics, insanity workout, uggs outlet, reebok outlet, longchamp, valentino shoes

oakleyses said...

converse, air max, gucci, canada goose, juicy couture outlet, canada goose, wedding dresses, moncler, ralph lauren, lancel, montre homme, moncler, louboutin, oakley, karen millen, vans, coach outlet store online, air max, canada goose jackets, ugg, hollister clothing store, louis vuitton, baseball bats, hollister, rolex watches, juicy couture outlet, iphone 6 cases, canada goose uk, canada goose outlet, ugg, moncler, moncler outlet, timberland boots, hollister, supra shoes, moncler, canada goose, converse shoes, toms shoes, moncler, moncler, canada goose, ugg boots, ray ban, parajumpers, canada goose

Alex Trebek said...

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.

Jetblue cancellation fees said...

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