OMF - Oracle Manager File

OMF - Oracle Manager File 

 Creating a Tablespace with OMF
ALTER SYSTEM SET DB_CREATE_FILE_DEST = '/u01/oradata';
ALTER SYSTEM SET DB_CREATE_FILE_DEST = '/u01/oradata' scope=both sid='*';
or 
show parameter DB_CREATE_FILE_DEST

 CREATE TABLESPACE data_1;
CREATE TABLESPACE data_1 DATAFILE SIZE 500M;
CREATE TABLESPACE data_1 DATAFILE AUTOEXTEND ON MAXSIZE 800M;
CREATE TABLESPACE data_1 DATAFILE SIZE 200M SIZE 200M;

Creating a Undo Tablespace using OMF
CREATE UNDO TABLESPACE undotbs_1;

 Alter Tablespace
ALTER TABLESPACE data_1 ADD DATAFILE AUTOEXTEND ON MAXSIZE 500M;

Creating a Temporary Tablespace using OMF
CREATE TEMPORARY1 TABLESPACE;

 Altering Undo Tablespace
ALTER TABLESPACE TEMPORARY1 ADD TEMPFILE;

 Creating Redo Log Files using OMF
ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_1 = '/u02/redo'
ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_2 = '/u03/redo'
or 
SHOW PARAMETER DB_CREATE_ONLINE_LOG_DEST_1
SHOW PARAMETER DB_CREATE_ONLINE_LOG_DEST_2

 ALTER DATABASE ADD LOGFILE;
ALTER DATABASE ADD LOGFILE SIZE 50M;

 ALTER DATABASE DROP LOGFILE GROUP 4;
alter database DROP LOGFILE MEMBER '/u01/app/oracle/RMAN/onlinelog/o1_mf_4_dvjb8m54_.log';
note: you can only drop a member if you have more than one in the same group or you must use drop group;   

 Creating Archived Logs Using OMF
DB_RECOVERY_FILE_DEST_SIZE = 20G
DB_RECOVERY_FILE_DEST      = '/u05/FLASRECOVERY'
LOG_ARCHIVE_DEST_1         = 'LOCATION=USE_DB_RECOVERY_FILE_DEST'

 If you are using ASM with high redundancy (3 copy)  
DB_RECOVERY_FILE_DEST_SIZE = 20G
DB_RECOVERY_FILE_DEST      = '+DATA'
LOG_ARCHIVE_DEST_1         = 'LOCATION=USE_DB_RECOVERY_FILE_DEST'

 If you are using ASM with normal redundancy (2 copy)  
DB_RECOVERY_FILE_DEST_SIZE = 20G
DB_RECOVERY_FILE_DEST      = '+FRA'
LOG_ARCHIVE_DEST_1         = 'LOCATION=USE_DB_RECOVERY_FILE_DEST'

Create and Manage a Database with Multiplexed Redo Logs 
DB_CREATE_FILE_DEST = '/u01/oradata'
DB_CREATE_ONLINE_LOG_DEST_1 = '/u02/redo'
DB_CREATE_ONLINE_LOG_DEST_2 = '/u03/redo'
UNDO_MANAGEMENT = AUTO
or
DB_CREATE_FILE_DEST = '/u01/oradata'
DB_RECOVERY_FILE_DEST_SIZE = 10G
DB_RECOVERY_FILE_DEST = '/u02/oradata'
LOG_ARCHIVE_DEST_1 = 'LOCATION = USE_DB_RECOVERY_FILE_DEST'
note:The DB_CREATE_FILE_DEST and DB_RECOVERY_FILE_DEST parameters set the default directory for log file and control file creation. Each redo log and control file is multiplexed across the two directories

Creating Database agap
CREATE DATABASE agap
DEFAULT TEMPORARY TABLESPACE tmp1;

 Oracle Recommendation for High Availability  
For a ASM has been configured HIGH REDUNDANCY (3 copy)
DB_CREATE_FILE_DEST=+DATA
note: If Oracle ASM with high redundancy is used, then the data area can also contain OCR, Voting, spfiles, control files, online redo log files, standby redo log files, broker metadata files, and change tracking files used for RMAN incremental backup
or
DB_CREATE_FILE_DEST=+DATA
DB_CREATE_ONLINE_LOG_DEST_1=+FRA
note:fast recovery area: contains recovery-related files, such as a copy of the current control file, a member of each online redo log file group, archived redo log files, RMAN backups, and flashback log files 

For a ASM has been configured Normal REDUNDANCY (2 copy)
DB_CREATE_FILE_DEST=+DATA
DB_CREATE_ONLINE_LOG_DEST_1=+FRA

For a ASM has been configured External (1 copy)
DB_CREATE_FILE_DEST=+DATA
DB_CREATE_ONLINE_LOG_DEST_1=+FRA1
DB_CREATE_ONLINE_LOG_DEST_1=+FRA2

For a File System has been configured HIGH REDUNDANCY (3 copy)
DB_CREATE_FILE_DEST=/u01/oradata
or
DB_CREATE_FILE_DEST=/u01/oradata
DB_CREATE_ONLINE_LOG_DEST_1=/u03/redo

For a File System has been configured Normal REDUNDANCY (2 copy)
DB_CREATE_FILE_DEST=/u01/oradata
DB_CREATE_ONLINE_LOG_DEST_1=/u02/redo

For a File System has been configured External (1 copy)
DB_CREATE_FILE_DEST=/u01/oradata
DB_CREATE_ONLINE_LOG_DEST_1=/u02/redo
DB_CREATE_ONLINE_LOG_DEST_1=/u03/redo
Posted by