Performing Backup and Recovery Operations and Getting Database Status

Performing Backup and Recovery Operations and Getting Database Status:

So, what kind of operations would you do given the different open or closed combinations

of the database and instance? Here are some examples:

Operations while the instance is down and the database is not open:

ü  Copy the spfile to a pfile.

ü  Copy the pfile to a spfile.

ü  Perform manual cold backups.

Operations while the instance is open and the database is not open:

ü  Create a database.

ü  Create a database control file.

ü  Restore the database control file or spfile from RMAN.

Operations while the instance is mounted and the database is not open:

ü  Cold backup with RMAN

ü  Recovery of critical datafiles (SYSTEM, UNDO tablespaces).

ü  Offline recovery of entire database.

Operations while the instance is mounted and the database is open:

ü  Online datafile or tablespace recovery of noncritical tablespaces.

ü  Online backups of the database.