Skip to main content
Oracle PBS backup failing with error ORACLE31
Updated over a week ago

Problem description

Oracle PBS backup failing with error ORACLE31

Cause

RMAN referencing old mount points during backups which is no longer present on the PBS.

Traceback

The Oracle PBS backup Fails with the error ORACLE31. Check the RMAN logs rman_full_backup_UID_***.log for below error message.
***************************************************************************************

RMAN-03002: failure of recover command at 03/07/2023 02:40:32
ORA-19870: error while restoring backup piece \\192.***.***.**\PHOENIX\******.RBK
ORA-19625: error identifying file \\192.***.***.**\PHOENIX\******.RBK 
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.


**************************************************************************************

Resolution

Kindly run the below RMAN crosscheck commands on the source database and delete all the control file metadata that is being referenced from the old backups from the deleted PBS mount.
Also, run a level 0 backup.

rman target /
Crosscheck copy;
Crosscheck copy of archivelog all;
Crosscheck archivelog all;
Crosscheck backup;
Delete force noprompt expired copy;
Delete force noprompt expired archivelog all;
Delete force noprompt expired backup;
Delete force noprompt obsolete;
  • We have disabled and enabled the BCT in order to trigger the level-0 backup.

Did this answer your question?