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

最新推荐文章于 2021-12-11 22:18:12 发布

转载最新推荐文章于 2021-12-11 22:18:12 发布 · 337 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/sunmengbbm/p/6018646.html

文章标签：

#数据库

本文介绍了一种在使用RMAN恢复Oracle数据库SPFILE时遇到RMAN-06564错误的解决方案。该错误提示必须在数据库使用SPFILE启动的情况下指定TO子句来恢复SPFILE。文章提供了正确的恢复命令示例。

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

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语句指定到其他位置，故解决办法如下：

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状态会比较好。

转载于:https://www.cnblogs.com/sunmengbbm/p/6018646.html