ORA-19618: cannot name files after RESTOREVALIDATE has been called

文档解释

ORA-19618: cannot name files after RESTOREVALIDATE has been called

Cause: A call was made to specify a file to restore from a backup set, but a previous call to RESTOREVALIDATE has already been made.

Action: You must cancel and restart the conversation if you wish to specify files to restore.

ORA-19618: 指的是在使用RESTOREVALIDATE功能对备份文件进行校验后，再来指定文件名称的操作被拒绝了。

官方解释

常见案例

SBT_TAPE=”version=”X.X.X.X.X” log=xxx.log”

RESTORE CONTROLFILE FROM ‘xxx.abc’ RESTORE VALIDATE;

RESTORE DATAFILE ‘/u00/xxx’ FROM ‘xxx.abc’

一般处理方法及步骤

1、这里要注意RESTOREVALIDATE和RESTORE DATAFILE是分开来操作的，要先RESTOREVALIDATE校验成功，再来指定文件名称；

2、正确的顺序，可以先执行以下步骤，试试是否可以：

SBT_TAPE=”version=”X.X.X.X.X” log=xxx.log”

RESTORE CONTROLFILE FROM BACKUPSET;

RESTORE CONTROLFILE FROM ‘xxx.abc’ RESTORE VALIDATE;

ALTER DATABASE MOUNT;

RESTORE DATAFILE ‘/u00/xxx’ FROM ‘xxx.abc’

3、如果仍然不行，则可以尝试使用NOCACHE参数，即：

RESTORE CONTROLFILE FROM ‘xxx.abc’ NOCACHE RESTORE VALIDATE;

RESTORE DATAFILE ‘/u00/xxx’ FROM ‘xxx.abc’