Monday, July 02, 2007

Controlfile backups

Almost everbody knows how to create backups of the controlfile.

Usually a

alter database backup controlfile to trace;

is used.

And now for the 64000$ question:

Which information is not backed up by this command?

The answer is:

THE BACKUP RECORDS!

In order to prevent the loss of this information you can better use the following command:

alter database backup controlfile to '/a_real/location/inyour/system';


1 comment:

lfreitas34 said...

With RMAN and a flash recovery area you can use:

backup as copy current controlfile;

For 9i, no recovery area:

backup as copy current controlfile format '/some/destination.ctl';