The following initialization parameters allow the database server to use the Oracle-managed files feature:
The file system directory specified by either of these parameters must already exist: the database does not create it. The directory must also have permissions to allow the database to create the files in it.
The default location is used whenever a location is not explicitly specified for the operation creating the file. The database creates the filename, and a file thus created is an Oracle-managed file.
Both of these initialization parameters are dynamic, and can be set using the ALTER SYSTEM or ALTER SESSION statement.
Setting the DB_CREATE_FILE_DEST Initialization Parameter
Include the DB_CREATE_FILE_DEST initialization parameter in your initialization parameter file to identify the default location for the database server to create:
Youspecify the name of a file system directory that becomes the default location for the creation of the operating system files for these entities. The following example sets /u01/oradata as the default directory to use when creating Oracle-managed files:
DB_CREATE_FILE_DEST = '/u01/oradata'Setting the DB_RECOVERY_FILE_DEST Parameter
Include the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE parameters in your initialization parameter file to identify the default location in which Oracle Database should create:
You specify the name of file system directory that becomes the default location for creation of the operating system files for these entities. For example:
Setting the DB_CREATE_ONLINE_LOG_DEST_n Initialization Parameter
Include the DB_CREATE_ONLINE_LOG_DEST_n initialization parameter in your initialization parameter file to identify the default location for the database server to create:
You specify the name of a file system directory that becomes the default location for the creation of the operating system files for these entities. You can specify up to five multiplexed locations.
For the creation of redo log files and control files only, this parameter overrides any default location specified in the DB _CREATE _FILE _DEST and DB _RECOVERY _Creating Oracle-Managed Files FILE_DEST initialization parameters. If you do not specify a DB _CREATE _FILE _ DEST parameter, but you do specify the DB _CREATE _ONLINE _LOG _DEST_n parameter, then only redo log files and control files can be created as Oracle-managed files.
It is recommended that you specify at least two parameters. For example: DB _CREATE _ONLINE _LOG _DEST _1 = '/u02/oradata'
DB_CREATE_ONLINE_LOG_DEST_2 = '/u03/oradata'This allows multiplexing, which provides greater fault-tolerance for the redo log and control file if one of the destinations fails.
|
|
Oracle 10g Related Tutorials |
|
---|---|
Oracle 9i Tutorial | Oracle 8i Tutorial |
Informatica Tutorial | Oracle 11g Tutorial |
Oracle 10g Related Interview Questions |
|
---|---|
Oracle 10g Interview Questions | Oracle 9i Interview Questions |
Oracle 8i Interview Questions | Informatica Interview Questions |
PL/SQL Interview Questions | Oracle 11g Interview Questions |
SQL Interview Questions | Oracle apps Interview Questions |
Sybase Interview Questions | Oracle Apps ERP Interview Questions |
Oracle 7.3 Interview Questions | Oracle Access Manager Interview Questions |
Oracle Application Framework Interview Questions | Oracle Apps DBA Interview Questions |
Oracle 10g Related Practice Tests |
|
---|---|
Oracle 10g Practice Tests | Oracle 9i Practice Tests |
Oracle 8i Practice Tests | Informatica Practice Tests |
PL/SQL Practice Tests | Oracle 11g Practice Tests |
SQL Practice Tests | Oracle apps Practice Tests |
Sybase Practice Tests | Oracle Apps ERP Practice Tests |
Oracle 7.3 Practice Tests |
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.