Re: "closing" never ends in v$managed_standby...

You probably want to do a sanity-check to be sure you don't delete anything not yet used, but delete based on an arbitrary time value, perhaps based on your SLA. For example, you may not want anything to go away during a 3 week vacation :-)

As you have surmised, there still may be bugs in managed recovery, so you may want to keep a larger time-frame of logs than a simple reading of the docs would suggest - for example, if you discover you need to go to a backup when the current recovery can't be bought up.

In an Openworld presentation, Michael Abbey suggested bringing the standby into read-only mode every _hour_, just to be sure you _can_. I'm considering that very seriously (though my req's aren't _that_ tough, and I've already thrown out managed recovery).

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20041220/news_1n20india.html