12c, storage, tablespaces

Oracle 12c – Manage database Structures

Leave a comment

Management of Oracle database storage structures provides the ability to persistently store data for long term retrieval and recovery processes.   The management of this structures can be done both from the command line, via EM Express and EM cloud control.    EM Express and EM Cloud control gives the administrator the ability to view, create, and alter various storage structures in the database in a Graphical User Interface through the STORAGE page.   Command line option requires that the administrator knows the syntax of DDL statements to perform the same tasks.  Oracle data structure of concern of storage are:

  • Tablespaces: create, drop, add datafiles, and change status of tablespace
  • Undo Management – shows current status of undo tablespaces and gives validation that it is sized correctly.
  • Redo Log Groups – allows you to create, drop, add members to redo log groups.
  • Archive Logs – Allows you view info about archive logs.
  • Control Files: – see content of control files and allows you to backup control files to trace.

OMF – Oracle Managed Files are intends to simplify the management of files associated with database.  When OMF is in use, the administrator specifies a directory for different file types.  OMF cannot be used with RAW devices.    OMF can be used for the following storage structures:

  • Tablespaces
  • Redo log files
  • control files
  • archive logs
  • block change tracking files
  • Flashback logs
  • RMAN backups.

OMF does nothing with administrative file like trace files, audit files, alert logs, and core files.   OMF requires three initialization parameter to be set

  • DB_CREATE_FILE_DEST – defines directory where data files and temp files are stored, Also used or redo logs and control files if DB_CREATE_ONLINE_LOG_DEST_n is not defined.
  • DB_CREATE_ONLINE_LOG_DEST_n – Defines directory for redo log files and control files.   You can specify up to 5 multiplex locations.
  • DB_RECOVERY_FILE_DEST – Define Fast Recovery Area. , Also used or redo logs and control files if DB_CREATE_ONLINE_LOG_DEST_n is not defined.

 

Larry Catt

OCP

 

 

 

 

 

Leave a Reply