Database state needed for the restore process

Contributors Download PDF of this page

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.