Subscribe YouTube Channel For More Live Tutorials
ORA-01260: warning: END BACKUP succeeded but some files found not to be in backup mode
ORA-01260: warning: END BACKUP succeeded but some files found not to be in backup mode
When we receive the following error ? How to find to fix it or to ignore?
SQL> alter database end backup;
alter database end backup
*
ERROR at line 1:
ORA-01260: warning: END BACKUP succeeded but some files found not to be in backup mode
Situation : While trying to end the hot backup , will receive the above error.
Action:
Verify the file status from v$backup, If still any file found ACTIVE then retry the end backup or If found INACTIVE then not an issue.
SQL> select file#,status from v$backup;
FILE# STATUS
---------- ------------------
1 NOT ACTIVE
2 NOT ACTIVE
3 NOT ACTIVE
4 NOT ACTIVE
5 NOT ACTIVE
7 NOT ACTIVE
So found NOT ACTIVE , so we can ignore the error. This could be due to some waits in the database caused slow to perform end backup.