文档解释
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’