An Architect's vision

background_dump_dest core_dump_dest user_dump_dest commit_write cursor_space_for_time instance_groups log_archive_local_first Specifies when the archiver processes (ARCn) transmit redo data to remote standby database destinations. This parameter is deprecated and is retained for backward compatibility only plsql_debug plsql_v2_compatibility remote_os_authent REMOTE_OS_AUTHENT specifies whether remote clients will be authenticated with the value of the OS_AUTHENT_PREFIX parameter. This parameter is deprecated and is retained for backward compatibility only resource_manager_cpu_allocation standby_archive_dest STANDBY_ARCHIVE_DEST can be used to specify where archived logs received from a primary database are stored on a standby database. It is no longer necessary to set this parameter, because an appropriate location is automatically chosen. transaction_lag Attribute of the CQ_NOTIFICATION$_REG_INFO object. Can be used to specify the number of transact...

active_instance_count ACTIVE_INSTANCE_COUNT enables you to designate one instance in a two-instance cluster as the primary instance and the other instance as the secondary instance. This parameter is deprecated and is retained for backward compatibility only. parallel_io_cap_enabled This parameter is replaced by the PARALLEL_DEGREE_LIMIT when set to IO.

ddl_wait_for_locks Specifies whether DDL statements (such as ALTER TABLE ... ADD COLUMN) wait and complete instead of timing out if the statement is not able to acquire all required locks. logmnr_max_persistent_sessions Specifies the maximum number of persistent LogMiner mining  sessions that are concurrently active when all sessions are mining redo logs generated by standalone instances. plsql_compiler_flags Specifies a list of flags for the PL/SQL compiler as a comma-separated list of strings.

  drs_start Enables Oracle to determine whether or not the DRMON (Disaster Recovery Monitor) process should be started. gc_files_to_locks A RAC parameter that controls the mapping of pre-release 9.0.1 parallel cache management (PCM) locks to datafiles. max_commit_propagation_delay Used when data consistency between different RAC instances must be guaranteed and immediate i.e. if commits must be seen instantaneously on remote instances. plsql_native_library_dir Specifies the name of a directory where the shared objects produced by the native compiler are stored. plsql_native_library_subdir_count Specifies the number of subdirectories created by the database administrator in the directory specified by plsql_native_library_dir. sql_version SQL language version parameter for compatibility issues.

1. Failover Clustering You can use failover clustering to reduce system downtime and provide higher application availability. 2. Database Mirroring Database mirroring is primarily a software solution to increase database availability by supporting almost instantaneous failover The mirror database is created by restoring a database backup of the principal database with no recovery. However, you can use it indirectly for reporting by creating a database snapshot on the mirror database. The mirror server continuously brings the mirror database up to date with principal database. Database mirroring can operate synchronously or asynchronously. 1-1 only Failover:   Automatic Failover Duration:  Failover is fast, sometimes < 3 seconds but not more than 10 seconds Role Change:   Role change is fully automatic Server Limitation:   Can be applied to only one mirror server ·        ...