SPFILE的备份和恢复(深入解析ORACLE笔记1)
1. 启用控制文件的自动备份,会同时备份CONTROLFILE和SPFILE
RMAN > CONFIGURE CONTROLFILE AUTOBACKUP ON;
更改自动备份的位置
RMAN > CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/opt/oracle/obak/control%F';
检查自动备份
SQL > select * from v$backup_spfile;
2. SPFILE恢复
1) 有备份的情况
$ rman target /
RMAN > list backup of spfile; --确认是否有备份的SPFILE
- 可以MOUNT
RMAN > startup mount
RMAN > restore spfile to '<PATH_SPFILE NAME>' from autobackup;
- 无法MOUNT
$