This discussion is archived
3 Replies Latest reply: Mar 18, 2013 1:28 AM by UweHesse RSS

Sapshot standby

933241 Newbie
Currently Being Moderated
Hello,

Till Oralce 10g, Using a combination of Data Guard, restore points, and Flashback Database, a physical standby database can be opened temporarily in read/write mode. From Oracle 11g, we can use snapshot standby. What is the difference
between 10g method and snapshot standby?

With regards
  • 1. Re: Sapshot standby
    user11982706 Newbie
    Currently Being Moderated
    I think they are same with only difference is that in 10g you need to create guaranted restore point manually and in 11g this is done automatically when you convert physical standby to snapshot database.


    Thanks

    Yogesh
    http://orasteps.wordpress.com/
  • 2. Re: Sapshot standby
    Jos van den Oord Newbie
    Currently Being Moderated
    Hi,

    The functionality is the same , How te do it is not. In 10 g you need global 10 steps to create a snapshot standby and after testing go back. In 11g this is much simpler.

    Stop redo apply

    ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;

    Convert back to standby

    ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

    Cheers,

    Jos van den Oord
    Blog : [Joords Oracle DBA blog|http://joordsblog.vandenoord.eu/]
    Company : [Transfer-solutions.com|http://www.transfer-solutions.com/]
  • 3. Re: Sapshot standby
    UweHesse Expert
    Currently Being Moderated
    Apart from the easier way to get that Snapshot Standby in 11g, there is one big difference:
    In 10g, the Redo Transport from Primary to Standby had to be stopped during the 'Snapshot Standby' (the term did not exist in 10g), leaving the Primary at risk in case of a disaster.

    This is no longer the case with 11g: We can ship redo to the Standby during its Snapshot Standby role.

    Kind regards
    Uwe Hesse

    "Don't believe it, test it!"
    http://uhesse.com

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points