Oracle Resources

PDF24    Send article as PDF   

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.