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