Monthly Archives: May 2019

Create a database using OMF (Oracle Managed Files)

— Create the destination folders, root and subfolders /u01/oradata/ folder1 | folder2 | flash_recovery_area | diag — Create the PFILE DB_NAME=orcl600 DB_UNIQUE_NAME=orcl600 DB_CREATE_FILE_DEST=’/u01/oradata/folder1′ DB_CREATE_ONLINE_LOG_DEST_2=’/u01/oradata/folder2′ MEMORY_TARGET=2048m PGA_AGGREGATE_TARGET=130m UNDO_TABLESPACE=undotbs01 CONTROL_FILES=’/u01/oradata/control01.ctl’,’/u01/oradata/control02.ctl’ DB_RECOVERY_FILE_DEST=’/u01/oradata/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g DIAGNOSTIC_DEST=’/u01/oradata/diag’ — Export the SID export ORACLE_SID=orcl600 export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 — Connect and startup the instance [oracle@rman bin]$ sqlplus / as sysdba SQL> startup …