DISQUS

DanNorris.com: ORA-1555 after switchover to standby

  • piontekdd · 1 year ago
    How weird (or is it serendipitous) ? I have been lightly trying to figure out a similar issue on a standalone training database that is just keeping and keeping undo segments for weeks at a time. I found Metalink Doc #420525.1 which sounded right up my alley. (Okay, so it isn't the exact issue but it is very similar). I implemented work-around #1 and am now seeing the TUNED_UNDORETENTION value in v$undostat is mirroring what my undo_retention is set to. the UNEXPIREDBLKS and EXPIREDBLKS have flip-flopped as well. Now to see if the segments automatically start shrinking.

    Also, not sure when you implemented DISQUS in your blog, but kudos on that. I have been liking the service for a few months.
  • Dan Norris · 1 year ago
    I probably read that note too...there was no shortage of AUM-related
    bugs and issues when I started looking around. The hard part, as it
    turned out, was to see which of the many matches was actually an exact
    match for my issue. Sounds like you're in the same situation possibly.
    Good luck!
  • Affordable SEO Services · 1 year ago
    Let's look at a few things you'll need to do after installing Beehive, but before you start migrating users... If you haven't installed Beehive yet, check out my last post. OK, here we go.
  • Dan Norris · 1 year ago
    Huh? Did this get misposted here by mistake or something? I am familiar with Beehive, but this post certainly didn't have anything to do with it.
  • Busby SEO Test · 1 year ago
    great report, I'll take a note on this
  • rac breakdown recovery uk · 11 months ago
    i will take note of this.
    good report.
  • Data Processing · 11 months ago
    really nice information.
  • Devon Cottages · 11 months ago
    Nice work with this... you seem to have handled the request really well. Better than most.
  • hypnosis.course · 9 months ago
    I am thinking that there is a way to have CRS put the standby in managed recovery mode, but not finding it easy to find in the documentation. Why is it not made more clear, more obvious? Especially if Oracle is touting this thing called "Best Practices" for "Maximum Availability"
  • Dan Norris · 9 months ago
    I'm not sure why you almost quoted Charles Schultz, but I'm guessing you're actually a bot. Hope this comment gets you the hits you're looking for. See Charles' comment at http://www.dannorris.com/2009/03/12/start-datab...