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.)