ORA-19618: cannot name files after RESTOREVALIDATE has been called ORACLE 报错 故障修复 远程处理
文档解释
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=.log”
RESTORE CONTROLFILE FROM ‘.abc’ RESTORE VALIDATE;
RESTORE DATAFILE ‘/u00/’ FROM ‘.abc’
一般处理方法及步骤
1、这里要注意RESTOREVALIDATE和RESTORE DATAFILE是分开来操作的，要先RESTOREVALIDATE校验成功，再来指定文件名称；
2、正确的顺序，可以先执行以下步骤，试试是否可以：
SBT_TAPE=”version=”X.X.X.X.X” log=.log”
RESTORE CONTROLFILE FROM BACKUPSET;
RESTORE CONTROLFILE FROM ‘.abc’ RESTORE VALIDATE;
ALTER DATABASE MOUNT;
RESTORE DATAFILE ‘/u00/’ FROM ‘.abc’
3、如果仍然不行，则可以尝试使用NOCACHE参数，即：
RESTORE CONTROLFILE FROM ‘.abc’ NOCACHE RESTORE VALIDATE;
RESTORE DATAFILE ‘/u00/’ FROM ‘.abc’
