Oracle Resources

This page is a, hopefully easy to use, jump off point to some of my more useful posts and information about Oracle.


RMAN Part 1 – a brief introduction to RMAN outlining a few sensible configuration settings and explaining a little about the Flash Recovery Area. Just enough to get you started with RMAN.

RMAN Part 2 – here we dive straight in to a cold backup. Simple and immediately rewarding! No archive log stuff here, just a plain old fashioned cold backup.

RMAN Part 3 – equally simple, what to do when you need to recover from a cold backup.

RMAN Part 4 – a bit about running a database in noarchivelog mode and some more recoveries from a cold backup. Examples of recovery include a total loss of all files, including the control file.

RMAN Part 5 – a brief explanation of RMAN terms and nomenclature (good word that!) as well as a few words on deletion and retention policies. No backups or recoveries this time.

RMAN Part 6 – Getting interesting now. Databases in archivelog mode, database hot backups, backing up archived logs, tablespace backups, data file backups and non-default destinations for your backups. Lots of practical work this time.

RMAN Part 7 – More practical work. Recovering the database, right up to date, from a hot backup. Covers the recovery of the whole database, individual tablespaces, data files and even, single blocks.

RMAN Part 8 – Point in time recoveries. Also known as incomplete recoveries. Recovering through a resetlogs. Tablespace incomplete recoveries.

RMAN Part 9 – Incremental backups and recoveries.

RMAN Part 10 – Sneaky incremental backup tricks, file copy merges!

I still have a few bits to write on RMAN, the following is a list – subject to change – for what’s coming.

RMAN Part 11 – Cloning databases with RMAN. To the same server, to a different server, from backups or from the active database.

RMAN Part 12 – Using a catalogue.

RMAN Part 13 – Image copies – why should I bother?

RMAN Part 14 – Housekeeping, compression, encryption, listing backups, reporting files that need backups etc.

RMAN Part 15 – Cloning databases from RMAN backups created on other servers that have been copied to this one.

RMAN Part 16 – RMAN Summary, other resources etc.

RMAN Part 17 – Cheat sheet aka cookbook, full of easy to bake RMAN recipes! (Those that help you backup and restore databases that is.)

4 thoughts on “Oracle Resources”

  1. At the moment, everything from part 9 onwards is yet to be written I’m afraid. Everything up to and including part 8 is currently available.

    As I add the new bits, the links will be activated and you can obtain them then. I’m afraid you’ll just have to “keep coming back”



Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.