SnapCenter Oracle restore or clone fails with the message ORA-00308: cannot open archived log /ORA_LOG/arch1_123_456789012.arc
- Views:
- 1,271
- Visibility:
- Public
- Votes:
- 0
- Category:
- snapcenter
- Specialty:
- snapx
- Last Updated:
- 12/2/2021, 10:55:28 AM
Applies to
- SnapCenter 4.0, 4.1, and P-releases
- Supported Linux RHEL, OHEL or SLES versions
- Supported Oracle version
- SnapCenter Plug-in for Oracle
Issue
The dialog shows the following errors (1):
Failed on 'Hostname': Activity 'Post Restore' failed with error:
PL-SCO-25000: SCO_POSTRESTORE of database files failed with error:
ORACLE-30036: Recovery of ORADBSID failed due to the following error(s):
[ORA-00308: cannot open archived log '/ORA_LOG/arch1_123_456789012.arc',
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below,
ORA-01195: online backup of file 1 needs more recovery to be consistent]
or (2):
ORA-00279: change 626960289 generated at 02/12/2019 09:47:37 needed for thread 1
ORA-00289: suggestion : /var/opt/snapcenter/scu/clones/u06_scu_clone_1/fast_recovery_area/1_263679_767212381.arc
ORA-00280: change 626960289 for thread 1 is in sequence #263679
ORA-00278: log file '/var/opt/snapcenter/scu/clones/u06_scu_clone_1/fast_recovery_area/1_263679_767212381.arc' no longer needed for this recovery
ORA-00308: cannot open archived log '/var/opt/snapcenter/scu/clones/u06_scu_clone_1/fast_recovery_area/1_263679_767212381.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
