Like an Airplane, The modern database can almost run on it’s own. However, like a pilot you need someone who’s calm and collected when all the red lights are flashing. Here I break down database backup and share tons of recovery scenarios. A backup is only as good as the ability to recover from it
Introduction As an IT professional, especially one working closely with data, surely, almost definitely, you have been asked a question from the users along the lines of “Can we know what the value was of col1 in the table t1 at 25:00 on Thursday, the 30th of February 8000 years ago?” (Silly, but that’s really […]
Flashback Data Archive: Recreating History, After The Fact Read More »
I was attempting to do some work on one of the databases on a sandbox environment that had been shutdown for a few weeks; so I log on to the server, set my environment, connect as sys, issue the startup command and… I get the ORA-03113: end of file on communication channel! This was somewhat
Guaranteed Restore Points bring a welcome sense of certainty to Oracle environments, especially when you’re navigating high‑risk changes like patching, data migrations, or application rollouts. By preserving a precise, immutable point in time, they give DBAs the confidence to experiment, recover quickly, and protect business continuity without relying solely on full backups. When used thoughtfully—paired with solid monitoring and storage awareness—GRPs become a powerful safety net that transforms recovery from a stressful gamble into a predictable, controlled process.
