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';
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';
Comments
backup as copy current controlfile;
For 9i, no recovery area:
backup as copy current controlfile format '/some/destination.ctl';