RMAN恢復(fù)控制文件的事件問(wèn)題，請(qǐng)大家?guī)椭�一下�?/a>

Basten

上一次備份的日期是8月30日，控制文件是使用的RMAN自動(dòng)備份。今天恢復(fù)數(shù)據(jù)的時(shí)候，系統(tǒng)提示如下：

Starting restore at 20-SEP-07

channel t1: looking for autobackup on day: 20070920
channel t1: looking for autobackup on day: 20070919
channel t1: looking for autobackup on day: 20070918
channel t1: looking for autobackup on day: 20070917
channel t1: looking for autobackup on day: 20070916
channel t1: looking for autobackup on day: 20070915
channel t1: looking for autobackup on day: 20070914
channel t1: no autobackup in 7 days found
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/20/2007 14:00:17
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

RMAN> **end-of-file**

當(dāng)然，如果通過(guò)date指令將系統(tǒng)日期設(shè)置到8月30日也可以解決這個(gè)問(wèn)題，不過(guò)，能否通過(guò)rman參數(shù)的設(shè)置來(lái)解決呢？

RobinWang

能貼一下你的RMAN參數(shù)嗎？

show all;

numenhuang

備份中有沒(méi)有包含控制文件，除了備份文件的自動(dòng)備份外。

使用自動(dòng)備份控制文件，要注意retention policy

mickky

restore spfile from '/backup-directory/control_file_backup'