SPFILE的备份与恢复

(1)设置控制文件自动备份
RMAN>configure controlfile autobackup on;
(2)这个设置可以在数据库中通过如下方式查询得到：
SQL>select * from v$rman_configuration;
(3)更改自动备份的位置
configure controlfile autobackup format for device type disk to '/opt/oracel/oradata/control%F';
(4)检查自动备份
SQL>select * from v$backup_spfile;
RMAN>list backup of spfile;
(5)测试
RMAN>restore spfile to '/tmp/spfileml.ora' from autobackup;
RMAN>restore controlfile to '/tmp/control01.ctl' from autobackup;
RMAN>restore controlfile to '/tmp/control01.ctl' from 'c-3152029224-20051221-00';

查看当前实例的非缺省参数
select name,value from v$parameter where isdefault='FALSE';

使用当前的参数设置在缺省位置创建一个SPFILE文件
create spfile='/tmp/spfile.ora' from memory

查看错误代码
oerr ora 30012