Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Archive log gap resolution


In order to resolve the archive log gap, oracle has introduced FAL(Fetch Archive Log). For this we need to set the following parameters :
1.fal_client
2.fal_server
In order to reflect the structural changes as it is(creating tablespaces,adding datafiles) we need to set the parameter
"standby_file_management=auto"
Upto 11g, we can configure 9 physical standby's and from 11g we can configure 30 physical standby's.
In 10gR2, oracle has introduced a primitive version of snapshot standby.
In 11g, oracle has introduced a full fledged snapshot standby and we can also convert this to active dataguard but requires separate licencing.
Related Posts Plugin for WordPress, Blogger...

Flag Counter