Skip to main content
NetApp Knowledgebase

SnapCenter Oracle restore or clone fails with the message ORA-00308: cannot open archived log /ORA_LOG/arch1_123_456789012.arc

Views:
284
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

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

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support