Fantastic article by Jonathan Lewis on why Oracle couldn’t just use REDO to cover the purposes of both UNDO and REDO.
Archive for February, 2010
REDO and UNDO – the ‘why’ behind them
Posted in General, How Oracle Works, tagged oracle, redo, undo on February 13, 2010 | Leave a Comment »
See all external directories in Oracle 10g
Posted in Import / Export on February 10, 2010 | Leave a Comment »
Took me a while to find this – I knew it had to be there but couldn’t find the view to query – so I thought I’d post this info. Every data pump article I found listed how to create a directory, but not how to make sure there wasn’t already one set up for [...]
My Oracle Support article
Posted in oracle on February 10, 2010 | Leave a Comment »
SearchOracle.com has a new article up on the ongoing issues with My Oracle Support, the replacement for Metalink. I know I have spent 30+ minute writing up a ticket only to lose it when one out of many Draft saves failed, as well as gotten stuck in “you haven’t filled out required fields” loops that [...]
ORA-01309: invalid session in dataguard logical standby
Posted in Dataguard, tagged Dataguard, invalid, invalid session, logical, logical standby, ORA-01309, session, standby on February 3, 2010 | 5 Comments »
We ran across a fun one today with dataguard and a logical standby. Second time we have seen it with the same fix. After making changes such as moving redo logs around or increasing TEMP (with log apply off) the redo/arch transport will correctly start and begin shipping data from the primary to the logical [...]
