RMAN-06564错误的原因及解决办法

今日在进行数据库恢复时，遭遇RMAN-06564错误，如下：

?

1 2 3 4 5 6 7 8 9 10 11 12

RMAN> restore spfile from autobackup;   Starting restore at 01-NOV-16 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=100 device type=DISK   RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 11/01/2016 10:33:51 RMAN-06564: must use the TO clause when the instance is started with SPFILE

出现RMAN-06564错误码，说明数据库已经使用SPFILE启动，在恢复SPFILE时就不能恢复到默认位置，因此rman要求通过to语句指定到其他位置，故解决办法如下：

?

1 2 3 4 5 6 7 8 9 10

RMAN> restore spfile to '/tmp/spfile_sid.ora' from autobackup;   Starting restore at 01-NOV-16 using channel ORA_DISK_1   channel ORA_DISK_1: looking for AUTOBACKUP on day: 20161101 channel ORA_DISK_1: AUTOBACKUP found: /u03/OTWB/20161030/ctl_spfile_c-2994357560-20161101-00 channel ORA_DISK_1: restoring spfile from AUTOBACKUP /u03/OTWB/20161030/ctl_spfile_c-2994357560-20161101-00 channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete Finished restore at 01-NOV-16

OK，问题已经解决。为了避免这样的错误，以后最好还是用pfile启动到nomount状态会比较好。