Specifying Oracle Managed Files at Database Creation

You can minimize the number of clauses and parameters that you specify in your CREATE DATABASE statement by using the Oracle Managed Files feature.

• Specify either a directory or Oracle Automatic Storage Management (Oracle ASM) disk group in which your files are created and managed by Oracle Database.

IBM infosphere datastage training courses malaysia

By including any of the initialization parameters DB_CREATE_FILE_DEST, DB_CREATE_ONLINE_LOG_DEST_n, or DB_RECOVERY_FILE_DEST in your initialization parameter file, you instruct Oracle Database to create and manage the underlying operating system files of your database. Oracle Database will automatically create and manage the operating system files for the following database structures, depending on which initialization parameters you specify and how you specify clauses in your CREATE DATABASE statement:

• Tablespaces and their data files
• Temporary tablespaces and their temp files
• Control files
• Online redo logs
• Archived redo log files
• Flashback logs
• Block change tracking files
• RMAN backups

IBM Informix training courses malaysia

The following CREATE DATABASE statement shows briefly how the Oracle Managed Files feature works, assuming you have specified required initialization parameters:

CREATE DATABASE mynewdb
USER SYS IDENTIFIED BY sys_password
USER SYSTEM IDENTIFIED BY system_password
EXTENT MANAGEMENT LOCAL
UNDO TABLESPACE undotbs1
DEFAULT TEMPORARY TABLESPACE tempts1
DEFAULT TABLESPACE users;

IBM cognos bi training courses malaysia

• The SYSTEM tablespace is created as a locally managed tablespace. Without the EXTENT MANAGEMENT LOCAL clause, the SYSTEM tablespace is created as dictionary managed, which is not recommended.
• No DATAFILE clause is specified, so the database creates an Oracle managed data file for the SYSTEM tablespace.
• No LOGFILE clauses are included, so the database creates two Oracle managed redo log file groups.
• No SYSAUX DATAFILE is included, so the database creates an Oracle managed data file for the SYSAUX tablespace.
• No DATAFILE subclause is specified for the UNDO TABLESPACE and DEFAULT TABLESPACE clauses, so the database creates an Oracle managed data file for each of these tablespaces.
• No TEMPFILE subclause is specified for the DEFAULT TEMPORARY TABLESPACE clause, so the database creates an Oracle managed temp file.
• If no CONTROL_FILES initialization parameter is specified in the initialization parameter file, then the database also creates an Oracle managed control file.
• If you are using a server parameter file (see “Managing Initialization Parameters Using a Server Parameter File”), then the database automatically sets the appropriate initialization parameters.

IBM aix system i training courses malaysia