1,如下表明:控制文件完完情况下,恢复控制文件从autobackup去找对应备份,所以你一定要形成配置spfile和controlfile自动备份的好习惯,不然,呵呵
RMAN> restore controlfile;
Starting restore at 30-JAN-10
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/30/2010 20:55:50
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP
2,再次证明,还是另外配置一个catalog库吧,不然你直接用生产库跑rman,哪就玩完了,呵呵,一旦生产库的控制文件没了,而且你呢,没搞备份,哈哈,你所作的所有备份没有一点用
3,再次引录一节我的小测试
RMAN> set dbid=3005679176;
executing command: SET DBID
RMAN> restore spfile to '/oracle/spfilecentos.ora' from autobackup;
Starting restore at 30-JAN-10
using channel ORA_DISK_1
recovery area destination: /oracle/flash_recovery_area
database name (or database unique name) used for search: CENTOS
channel ORA_DISK_1: no autobackups found in the recovery area
channel ORA_DISK_1: looking for autobackup on day: 20100130
channel ORA_DISK_1: looking for autobackup on day: 20100129
channel ORA_DISK_1: looking for autobackup on day: 20100128
channel ORA_DISK_1: looking for autobackup on day: 20100127
channel ORA_DISK_1: looking for autobackup on day: 20100126
channel ORA_DISK_1: looking for autobackup on day: 20100125
channel ORA_DISK_1: looking for autobackup on day: 20100124
channel ORA_DISK_1: no autobackup in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/30/2010 20:55:00
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
4,以上所作皆与data guard有关,为模拟主库控制文件完完,但之前对控制文件作了备份
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9240380/viewspace-626461/
,如需转载,请注明出处,否则将追究法律责任。