Oracle database restore times out and fails after 72 hours
Applies to
- SnapCenter Server (SC)
- SnapCenter Plug-in for Oracle (SCO)
Issue
Oracle database restore runs for 3 days (72 hours) and then fails with the following errors:
ERROR qtp489446773-390 c.n.o.c.s.d.r.DatabaseRmanService - An exception thrown during the execution of method restore and the exception message is Timeout of 72:00:00.000 occured when running command [RESTORE DATAFILE '+ABXXXX/XXXX/A2A6B86752C221XXXXXX com.netapp.oracle.core.exception.OracleCoreException: Timeout of 72:00:00.000 occured when running command [RESTORE DATAFILE NAME]
DEBUG qtp489446773-390 c.n.o.c.s.d.r.DatabaseRmanService - failed to complete method restore with JVM free memory 1.2 GB and used memory 312.2 MB.
ERROR qtp489446773-390 c.n.o.c.s.d.r.DatabaseRmanService - An exception thrown during the execution of method restore and the exception message is Timeout of 72:00:00.000 occured when running command [RESTORE DATAFILE NAME]
com.netapp.oracle.core.exception.OracleCoreException: Timeout of 72:00:00.000 occured when running command [RESTORE DATAFILE '+ABXXXX/CABXXXX/A2AXXXXXX/DATAFILE/sysaux.2213.1037798213' FROM TAG='SCO_2373';, RESTORE DATAFILE '+ABXXX/CAXXXX/A2XXXXXXXX1
at com.netapp.oracle.core.service.database.rman.DatabaseRmanService.initalizeAndRunRMANExecutorForRestore(DatabaseRmanService.java:1075)
at com.netapp.oracle.core.service.database.rman.DatabaseRmanService.restore(DatabaseRmanService.java:639)
at com.netapp.oracle.core.service.database.rman.DatabaseRmanService$$FastClassBySpringCGLIB$$30ecf74a.invoke(<generated>)