oracle 10gr2 omf minimal
DESCRIPTION
Oracle 10gr2 OMF MinimalTRANSCRIPT
control_files = (/path/to/control1.ctl,/path/to/control2.ctl,/path/to/control3.ctl)undo_management = AUTOdb_name = testdb_block_size = 8192sga_max_size = 1073741824 #one gigsga_target = 1073741824 #one gigdb_create_file_dest = /path/to/datafile/location #OMFdb_create_online_log_dest_1 = /path/to/first/redo_and_control_file/location #OMFdb_create_online_log_dest_2 = /path/to/second/redo_and_control_file/location #OMFdb_recovery_file_dest = /path/to/flash/recovery/area #OMF#note it’s a good idea to also have background_dump_dest, user_dump_dest, and core_dump_dest here as well
Create a password file
$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/pwd<sid>.ora password=oracle entries=5