Re: Backup en Caliente

From: <frank.van.bortel_at_gmail.com>
Date: 6 Apr 2006 01:50:19 -0700
Message-ID: <1144313419.471393.16480@g10g2000cwb.googlegroups.com>

Completely ignoring any naming conventions or storage options, this should do the trick:

Cold:

rman target /
shutdown immediate;
startup mount
backup database include current controlfile; sql 'alter system archive log current';
alter database open;

Hot:
rman target /
backup database include current controlfile; backup archivelog;

Restore:
You must find your own here; too many scenarions are possible. You generally want to restore only what's needed.

I'd suggest to switch on controlfile autobackup (lookup the configure command); Oracle has some more incomprehensable defaults (export: compress=y is one), and not having controlfile autobackup is another. Received on Thu Apr 06 2006 - 03:50:19 CDT