Hi all,
Prior to oracle 10g there were close to 200 parameter initialiasation parameters which were revelant for the proper configuration of the instance but with oracle 10g there are close to 20 parameters which are more revelant and basic for the configuration of Instance , such parameters are referred to as BASIC parameters.
the basic parameters are.
cluster_database: Boolean , set to true for RAC database
compatible: Used to ensure compatibility version
control_files: specify the location for control file or files in case of multiplexing
db_block_size: specify the standard oracle block size
db_create_file_dest: OMF feature used in conjuction with ASM and specify the deafult location of datafiles
db_create_online_log_dest_n: OMF feature that specify the default location og online redo logfiles
db_domain: specify the network domain in which the server is operation
db_name : specify the name of the database.
db_recovery_file_dest: Specify the location of flash recovery area.
db_recovery_file_dest_size : Specify the space allocated to flash recovery area.
instance_number: Used to specify instance number for RAC systems.
log_archive_dest_n: Used to specify to location for archive log as well as used in conguring dataguard
In order to place the archive logs in the flash recovery area set the log_archive_dest_1 as shown
log_archive_dest_1=’LOCATION=USE_RECOVERY_FILE_DEST’
By default log_archive_dest_10 is pointing to flash_recovery_area so if above parameter is set the archive logs will only go to flash recovery are but if log_archive_dest_1 is set to some other location then archive logs will go 2 destination one at the location specified by log_archive_dest_1 and other at log_archive_dest_10 to flash recovery area.
Also, If neither above the above parameters are set the logs go to flash recovery area due to log_archive_dest_10 pointing at flash recovery area by default.
