使用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也会自动备份;

原文地址:https://www.cnblogs.com/arcer/p/2977917.html