|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
Structural changes that require a backup
The following structural changes require a backup if the DBA relies on hot backups:
How the backup must be taken depends on the archive log mode that the database is running in.
Archive log mode
The controlfiles must be backed up:
alter database backup controlfile ...
Noarchive log mode
A consistent backup must be made after the modification.