Wednesday, April 11, 2007

Oracle 11g Online Query Capability of Physical Standby Database

Online Query Capability of Physical Standby Database( Oracle 11g New Features)

It is now possible to query a physical standby database while Redo Apply is active.This new capability increases your return on investment in Data Guard technology because a physical standby database can now be used to offload queries from the primary database in addition to providing data protection.

( We can do same with logical standby , what is diffrent here , well redo apply method is faster in physical stand by ie redo apply methode is diffrent in physical standby)

  • Stop log apply

    Alter database recover managed standby database cancel;
  • open database for read-only access

    alter database open
  • Once daabase open start redo apply

    alter database recover managed standby database
    using current logfile disconnect from session;

2 comments:

  1. Good to see lots of 11g information. Do you know when 11g releasing?

    ReplyDelete
  2. When the Wow Gold wolf finally found the wow gold cheap hole in the chimney he crawled cheap wow gold down and KERSPLASH right into that kettle of water and that was cheapest wow gold the end of his troubles with the big bad wolf.

    game4power.
    The next day the Buy Wow Goldlittle pig invited hisbuy gold wow mother over . She said "You see it is just as Cheapest wow goldI told you. The way to get along in the world is to do world of warcraft gold things as well as you can." Fortunately for that little pig, he buy cheap wow gold learned that lesson. And he just wow gold lived happily ever after!.

    ReplyDelete

Google