Database state needed for the restore process
Suggest changes
PDFs
The state of the database that is to be restored depends on the type of restore process that you want to perform and the type of files that are to be included.
The following table lists the state in which the database should be depending on the restore option selected and the type of files you want to include in the restore:
| Type of restore | Files included | Database state for this instance | Database state for other instance (RAC only) |
|---|---|---|---|
Restore only |
Control files |
Shutdown |
Shutdown |
System files |
Mount or Shutdown |
Mount or Shutdown |
|
No system files |
Any state |
Any state |
|
Restore and recovery |
Control files |
Shutdown |
Shutdown |
System files |
Mount |
Mount or Shutdown |
|
No system files |
Mount or Open |
Any |
The database state required by SnapManager for a restore operation depends on the type of restore being performed (complete, partial, or control files). SnapManager does not transition the database to a lower state (for example, from Open to Mount) unless the force option is specified.
SnapManager for SAP does not verify whether SAP is running. SnapManager for SAP waits for a timeout to elapse and then shuts down the database, which can add an hour of additional restore time.