使用RMAN备份System Parameter File
- Automatically backed up when CONFIGURE CONTROLFILE AUTOBACK = ON
- Explicitly backed up with BACKUP SPFILE
- RMAN>BACKUP COPIES 2 DEVICE TYPE sbt SPFILE(将SPFILE文件拷贝到磁带上,并产生两份副本)
RMAN> backup spfile format '/u01/arcerzhang/sp_%U';
只要进行spfile的备份,那么control file也会自动备份;