- adding/dropping a new tablespace or datafile
- altering the state of a tablespace or datafile (online/offline/read only)
- adding a new online redo log,
- renaming a file
- adding a new redo thread
- and many more...
RMAN target=sys/password@dbset directory and format of backup files:
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'C:\Backup\%F';In name of autbackup file you have to use %F. It will be expanded to C-XXXXXXXXX-YYYYMMDD-NN, where:
- XXXXXXXXX – database id
- YYYYMMDD – day, when backuped
- NN – change number during day, starts with 00, and represented in hexadecimal
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;Now autobackups are active, and every time you change database structure controlfile will be automatically backed up.
If you use RMAN for backups it will create copy of SPFILE or CONTROLFILE also after each backup operation.
I've tested it on Oracle 10g (10.2) but it should work in Oracle since version 8i. Next time i'll write how to restore SPFILE or CONTROLFILE from these backup.
Update: How to restore CONTROLFILE and SPFILE from RMAN autobackups