Re: OMF or not OMF? DBCA or Manual scripts
From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Mon, 24 Mar 2014 12:40:53 -0700 (PDT)
Message-ID: <1395690053.47569.YahooMailNeo_at_web124703.mail.ne1.yahoo.com>
You will need to modify the XML template to include: db_file_create_dest db_file_online_log_dest_n and set these parameters to the local locations you want to use. For example, in the InitParams section of the template I have added 4 lines to provide for OMF: <InitParamAttributes> <InitParams> <initParam name="db_name" value=""/> <initParam name="db_file_create_dest" value="/u01/oradata"/> <initParam name="db_file_online_log_dest_1" value="/u02/oralog"/> <initParam name="db_file_online_log_dest_2" value="/u03/oralog"/> <initParam name="db_file_online_log_dest_3" value="/u04/oralog"/> <initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={SID}XDB)"/> <initParam name="audit_file_dest" value="{ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\adump"/> <initParam name="compatible" value="11.2.0.0.0"/> <initParam name="remote_login_passwordfile" value="EXCLUSIVE"/> <initParam name="processes" value="150"/> <initParam name="undo_tablespace" value="UNDOTBS1"/> <initParam name="control_files" value="("{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control01.ctl", "{ORACLE_BASE}\fast_recovery_area\{DB_UNIQUE_NAME}\control02.ctl")"/> <initParam name="diagnostic_dest" value="{ORACLE_BASE}"/> <initParam name="db_recovery_file_dest" value="{ORACLE_BASE}\fast_recovery_area"/> <initParam name="audit_trail" value="db"/> <initParam name="memory_target" value="250" unit="MB"/> <initParam name="db_block_size" value="8" unit="KB"/> <initParam name="open_cursors" value="300"/> <initParam name="db_recovery_file_dest_size" value="" unit="MB"/> </InitParams> When you create a database using this modified template you should have OMF enabled. By default these entries are missing in the template; once you modify the template you should be able to save it as a new template, for example General_Purpose_OMF.dbt. You can now use it as a template to create a new database and it won't include datafiles (it will behave like the Custom database template and create the files where you specified in the db_file_*_create_* parameters). David Fitzjarrell Primary author, "Oracle Exadata Survival Guide" On Monday, March 24, 2014 12:25 PM, GG <grzegorzof_at_interia.pl> wrote: W dniu 2014-03-24 17:52, Frits Hoogland pisze: > I use dbca -silent with templates. > > Frits Hoogland Hi, would You elaborate ? I was having some issues with control files not being omf like as well as redo logs. It is easy fixable but still kind of pain So I'd appreciate any help how to make this OMF (control file, redo logs as well) in 11.2.0.3 . [oracle_at_ol6a ~]$ cat dbca_silent.txt dbca -silent -createDatabase \ -templateName General_Purpose.dbc \ -gdbName MYDB \ -sid MYDB \ -sysPassword oracle \ -systemPassword oracle \ -emConfiguration NONE \ -datafileDestination /u01/oradata \ -storageType FS \ -characterSet AL32UTF8 \ -nationalCharacterSet UTF8 \ -registerWithDirService false \ -listeners LISTENER_1521; Regards Greg -- http://www.freelists.org/webpage/oracle-l
Date: Mon, 24 Mar 2014 12:40:53 -0700 (PDT)
Message-ID: <1395690053.47569.YahooMailNeo_at_web124703.mail.ne1.yahoo.com>
You will need to modify the XML template to include: db_file_create_dest db_file_online_log_dest_n and set these parameters to the local locations you want to use. For example, in the InitParams section of the template I have added 4 lines to provide for OMF: <InitParamAttributes> <InitParams> <initParam name="db_name" value=""/> <initParam name="db_file_create_dest" value="/u01/oradata"/> <initParam name="db_file_online_log_dest_1" value="/u02/oralog"/> <initParam name="db_file_online_log_dest_2" value="/u03/oralog"/> <initParam name="db_file_online_log_dest_3" value="/u04/oralog"/> <initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={SID}XDB)"/> <initParam name="audit_file_dest" value="{ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\adump"/> <initParam name="compatible" value="11.2.0.0.0"/> <initParam name="remote_login_passwordfile" value="EXCLUSIVE"/> <initParam name="processes" value="150"/> <initParam name="undo_tablespace" value="UNDOTBS1"/> <initParam name="control_files" value="("{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control01.ctl", "{ORACLE_BASE}\fast_recovery_area\{DB_UNIQUE_NAME}\control02.ctl")"/> <initParam name="diagnostic_dest" value="{ORACLE_BASE}"/> <initParam name="db_recovery_file_dest" value="{ORACLE_BASE}\fast_recovery_area"/> <initParam name="audit_trail" value="db"/> <initParam name="memory_target" value="250" unit="MB"/> <initParam name="db_block_size" value="8" unit="KB"/> <initParam name="open_cursors" value="300"/> <initParam name="db_recovery_file_dest_size" value="" unit="MB"/> </InitParams> When you create a database using this modified template you should have OMF enabled. By default these entries are missing in the template; once you modify the template you should be able to save it as a new template, for example General_Purpose_OMF.dbt. You can now use it as a template to create a new database and it won't include datafiles (it will behave like the Custom database template and create the files where you specified in the db_file_*_create_* parameters). David Fitzjarrell Primary author, "Oracle Exadata Survival Guide" On Monday, March 24, 2014 12:25 PM, GG <grzegorzof_at_interia.pl> wrote: W dniu 2014-03-24 17:52, Frits Hoogland pisze: > I use dbca -silent with templates. > > Frits Hoogland Hi, would You elaborate ? I was having some issues with control files not being omf like as well as redo logs. It is easy fixable but still kind of pain So I'd appreciate any help how to make this OMF (control file, redo logs as well) in 11.2.0.3 . [oracle_at_ol6a ~]$ cat dbca_silent.txt dbca -silent -createDatabase \ -templateName General_Purpose.dbc \ -gdbName MYDB \ -sid MYDB \ -sysPassword oracle \ -systemPassword oracle \ -emConfiguration NONE \ -datafileDestination /u01/oradata \ -storageType FS \ -characterSet AL32UTF8 \ -nationalCharacterSet UTF8 \ -registerWithDirService false \ -listeners LISTENER_1521; Regards Greg -- http://www.freelists.org/webpage/oracle-l
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 24 2014 - 20:40:53 CET