This content has been marked as final. Show 3 replies
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;
Jos van den Oord
Blog : [Joords Oracle DBA blog|http://joordsblog.vandenoord.eu/]
Company : [Transfer-solutions.com|http://www.transfer-solutions.com/]
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.
"Don't believe it, test it!"