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

来源：互联网发布：网络批发平台有哪些编辑：程序博客网时间：2024/05/29 18:36

遭遇RMAN-06564错误，如下：

?
1
2
3
4
5
6
7
8
9
10
11
12
RMAN> restore spfilefrom 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: failureof restore commandat 11/01/2016 10:33:51
RMAN-06564: must use theTO clause when the instance is started withSPFILE

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

?
1
2
3
4
5
6
7
8
9
10
RMAN> restore spfileto '/tmp/spfile_sid.ora'from autobackup;
Starting restore at 01-NOV-16
using channel ORA_DISK_1
channel ORA_DISK_1: lookingfor AUTOBACKUP on day: 20161101
channel ORA_DISK_1: AUTOBACKUP found: /u03/OTWB/20161030/ctl_spfile_c-2994357560-20161101-00
channel ORA_DISK_1: restoring spfilefrom AUTOBACKUP /u03/OTWB/20161030/ctl_spfile_c-2994357560-20161101-00
channel ORA_DISK_1: SPFILE restorefrom AUTOBACKUP complete
Finished restore at 01-NOV-16

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

参考文档： http://www.cnblogs.com/sunmengbbm/p/6018646.html

0 0