Index

A  B  C  D  E  F  G  H  I  L  M  N  O  P  Q  R  S  T  U  V  W  Z  

Numerics

  • 24x365 1
  • 64-bit systems
    • migration from 32-bit 1

A

  • access control
    • security 1
  • Active Data Guard
    • See: Oracle Active Data Guard
  • ADD COLUMN
    • default values for columns 1
  • analysis
    • determining high availability requirements 1
  • applications
    • failover 1
    • online maintenance and upgrades 1
  • applying interim database patches 1
  • architectures
    • failures in 1
    • MAA 1
    • manageability 1
    • Oracle Fusion Middleware 1
    • Oracle WebLogic Server 1
    • requirements 1 , 2
    • roadmap 1
    • same processor platforms 1
  • ASR
    • See: Oracle Auto Service Request (ASR)
  • auditing
    • security control 1
  • authentication
    • security controls 1
  • automatic block repair 1
  • automatic corruption repair 1
  • automatic shared memory management 1
  • availability
    • about 1
    • disruptions 1
    • roadmap 1

B

  • backing out a transaction 1
  • backups
    • Oracle Secure Backup 1
  • between objects 1
  • block recovery
    • using Flashback logs 1
  • business impact analysis
    • internal knowledge management system example 1
    • semiconductor manufacturer example 1

C

  • Cluster Ready Services (CRS)
    • avoiding downtime during upgrades 1
  • columns, invisible 1
  • components
    • integrated with Oracle Restart 1
  • computer failure 1
  • corruptions
    • automatic repair 1
    • prevention and detection 1
  • costs
    • quantifying 1
  • CREATE TRIGGER statement
    • clauses for 1
  • crossedition triggers 1

D

  • databases
    • applying Oracle interim patches 1
    • dynamic reconfiguration 1
    • security 1
  • Database Server Grid
    • about 1
  • Database Storage Grid
    • about 1
  • database upgrades
    • using transportable tablespace 1
  • data corruptions
    • detecting 1
    • prevention and detection parameters 1
  • data distribution
    • Oracle GoldenGate 1
  • data encryption 1
  • datafiles, moving online 1
  • Data Guard
    • about 1
    • benefits 1 , 2
    • configuring with Oracle GoldenGate 1
    • system and cluster upgrades 1
  • data integration
    • Oracle GoldenGate 1
  • data-loss tolerance 1
  • data protection
    • maximizing 1
  • Data Recovery Advisor 1
  • DBA_FLASHBACK_TRANSACTION_STATE view 1
  • DBMS_FLASHBACK.TRANSACTION_BACKOUT() procedure 1
  • DDL with the WAIT option 1
  • dependencies 1
  • DISABLE clause
    • FOLLOWS clause
      • CREATE TRIGGER statement 1
  • disk group
    • administering with Oracle ASM 1
  • downtime
    • causes 1
    • cost 1 , 2
    • minimizing with Oracle GoldenGate 1
    • minimizing with Oracle GoldenGate and Data Guard 1
    • mitigating 1
    • reducing 1
    • solutions summary
      • planned 1
  • dynamic memory allocation 1
  • dynamic reconfiguration 1

E

  • edition-based redefinition
    • crossedition triggers 1
    • editioning view 1
    • editions 1
  • ENABLE clause
    • CREATE TRIGGER statement 1
  • encryption
    • of data 1
  • Extended Datatype Support (EDS)
    • patch set and database upgrades 1

F

  • failovers
    • applications 1
    • services 1
  • failure group
    • administering with Oracle ASM 1
    • Oracle ASM 1
  • failures
    • computer 1
    • site 1
    • storage 1
  • fast application notification (FAN)
    • for hardware upgrades 1
    • for operating system upgrades 1
  • Fast Connection Failover
    • for nonpooled connections 1
  • Fast Mirror Resync
    • Oracle ASM 1
  • fast recovery area
    • about 1
    • benefits 1
  • flashback
    • PDB 1
  • flashback logs
    • block recovery using 1
  • Flashback technology 1
    • See also: Oracle Flashback technology
  • forward crossedition triggers 1

G

  • Global Data Services 1 , 2
  • grid computing 1

H

  • hangs or slow down 1
  • hardware upgrades
    • avoiding downtime during 1
    • using FAN during 1
  • high availability
    • 24x365 1
    • about 1
    • applications 1
    • architectures 1 , 2 , 3
    • business impact analysis 1
    • determining requirements 1
    • importance 1
    • maximizing 1
    • Oracle Fusion Middleware 1
    • planned downtime 1
    • setting manageability goals 1
    • single-instance databases 1
    • solutions 1
    • unplanned downtime 1
  • human errors 1

I

  • indexes
    • invisible 1
  • indexes, multiple on same set of columns 1
  • instance failure 1
  • interblock corruption 1
  • intrablock corruption 1
  • invisible columns 1
  • invisible indexes 1

L

  • load balancing
    • advisory 1
    • run-time connection 1
  • load balancing advisory 1
  • logical corruption 1
  • lost writes 1

M

  • making data changes 1
  • manageability
    • goals 1
    • overhead (MO) 1
  • Maximum Availability Architecture
    • See: Oracle Maximum Availability Architecture (MAA)
  • media corruption
    • physical corruption 1
  • memory
    • automatic management of 1
  • metadata
    • dependencies 1
  • migrating storage
    • avoiding downtime 1
  • migrations
    • 32-bit to 64-bit systems 1
    • storage 1
  • mirroring
    • Oracle ASM native 1
  • multitenant architecture 1

N

  • network bonding 1

O

  • offloading database activity 1
  • one-off patches 1
  • online, moving datafiles 1
  • online maintenance
    • application 1
  • online redefinition
    • of tables 1
  • online table redefinition 1
  • OPatch utility
    • patch upgrades for Oracle RAC 1
  • operating systems
    • upgrades 1
    • using FAN during upgrades 1
  • Oracle Active Data Guard
    • benefits of standby databases 1
    • for physical standby databases 1
  • Oracle ASM Cluster File System (ACFS) 1
  • Oracle Automatic Storage Management (Oracle ASM)
    • about 1
    • benefits 1
    • distribution of files 1
    • failure group 1
    • Fast Mirror Resync 1
    • native mirroring 1
    • storage migration 1
    • upgrading 1
  • Oracle Automatic Storage Management Cluster File System (Oracle ACFS) 1
  • Oracle Auto Service Request (ASR) 1
  • Oracle Call Interface (OCI) 1
  • Oracle Clusterware
    • avoiding downtime when upgrading 1
    • cold cluster failover 1
  • Oracle Database File System (DBFS) 1 , 2
  • Oracle Data Guard
    • See: Data Guard
  • Oracle Data Provider for .NET (ODP.NET) 1
  • Oracle Enterprise Manager 1
  • Oracle Exadata Database Machine 1
  • Oracle Exadata Storage Server Software
    • combined with Oracle Database Machine 1
    • upgrading 1
  • Oracle Flashback Data Archive 1
  • Oracle Flashback Database 1
  • Oracle Flashback Drop 1
  • Oracle Flashback Query 1
  • Oracle Flashback Table 1
  • Oracle Flashback technology
    • block recovery using Flashback logs 1
  • Oracle Flashback Transaction 1
  • Oracle Flashback Transaction Query 1
  • Oracle Flashback Version Query 1
  • Oracle GoldenGate
    • about 1
    • configure to minimize downtime 1
    • rolling upgrades 1
    • upgrades 1
  • Oracle interim (one-off) patches
    • applying 1
    • avoiding downtime during 1
  • Oracle Maximum Availability Architecture (MAA)
    • about 1
    • architectures 1
    • roadmap 1
  • Oracle Multitenant 1 , 2
  • Oracle Quality of Service (QoS) Management 1
  • Oracle RAC One Node 1
  • Oracle Real Application Clusters 1
  • Oracle Real Application Clusters (Oracle RAC)
    • applying Oracle interim database patches 1
    • benefits 1
    • operating system and hardware upgrades 1
  • Oracle Real Application Clusters One Node
    • See Oracle RAC One Node 1
  • Oracle Restart 1
  • Oracle Secure Backup
    • about 1
    • benefits 1
  • Oracle Sharding
    • overview 1
    • reference architecture 1
  • Oracle Solaris ZFS Storage Appliance Replication 1
  • Oracle UCP run-time connection load balancing 1
  • Oracle VM
    • Domain Live Migration 1
  • Oracle WebLogic Server
    • high availability architectures 1
  • outages
    • types of 1

P

  • patching
    • rolling 1
  • physical corruption 1
  • physical standby databases
    • real-time query 1
  • planned downtime
    • online patching 1
  • planned outages
    • minimizing with Oracle GoldenGate 1
    • minimizing with Oracle GoldenGate and Data Guard 1
  • Plug and Play 1
  • pluggable databases 1
  • policy-based cluster management 1
  • policy management
    • security 1
  • portable databases 1
  • prioritizing
    • high availability investment 1
  • Program Global Area (PGA)
    • automatic management 1

Q

  • quarantine, state object 1

R

  • real-time query 1
  • reconfiguring
    • databases dynamically 1
  • Recovery Manager (RMAN)
    • about 1
    • benefits 1
  • recovery point objective (RPO)
    • about 1
  • recovery time objective (RTO)
    • about 1
  • reference architectures
    • data protection attributes 1
    • gold 1
    • high availability attributes 1
    • Oracle Sharding 1 , 2
    • overview 1
    • platinum 1
    • silver 1
  • reference architrectures
    • bronze 1
  • replication
    • Oracle GoldenGate 1
  • restore points
    • Oracle Flashback 1
  • return on investment (ROI) 1
  • reverse crossedition triggers 1
  • roadmap to Maximum Availability Architecture (MAA) 1
  • rollback
    • transactions 1
  • rolling patching 1
  • rolling upgrades
    • Oracle GoldenGate 1
  • row level security
    • virtual private database 1
  • run-time connection load balancing 1 , 2

S

  • scalability
    • with Oracle RAC 1
  • SCAN 1
  • security
    • about 1
    • benefits 1
    • data encryption 1
    • Oracle ASM 1
    • RMAN 1
  • services
    • failover 1
  • simple database rolling upgrades 1
  • single-instance databases
    • Oracle Restart 1
  • site failure 1
  • SQL Apply 1 , 2
  • standby databases
    • active 1
    • benefits 1
    • Oracle Active Data Guard 1
  • standby reader farms 1
  • state object quarantine 1
  • storage
    • failures 1 , 2
    • migration 1
    • Oracle ASM protection 1
  • System Global Area (SGA)
    • automatic management 1
  • system upgrades
    • avoiding downtime during 1

T

  • tables
    • editionable 1
  • tape backups
    • with Oracle Secure Backup 1
  • total cost of ownership (TCO) 1
  • transactions
    • backing out with Flashback Transaction 1
  • transportable tablespace
    • upgrading the database 1

U

  • unplanned downtime
    • causes 1
    • solutions summary 1
  • upgrade
    • simple rolling 1
    • using Oracle GoldenGate 1
  • upgrades
    • application 1
    • cluster 1
    • database 1
    • hardware 1
    • operating system 1 , 2
    • Oracle ASM 1
    • Oracle Clusterware 1
    • Oracle Exadata Storage Server Software 1
    • Oracle Real Application Clusters (Oracle RAC) 1
    • patches 1
    • rolling 1
    • rolling with Oracle GoldenGate 1
    • SQL Apply 1
    • using crossedition triggers 1
    • using transportable tablespace 1

V

  • virtual IP (VIP) address
    • managed by Oracle Clusterware 1
  • virtualization
    • with Oracle VM Domain Live Migration 1
  • virtual private database
    • security 1

W

  • WAIT option
    • specifying DDL with 1
  • web scalability
    • using standby reader farms 1
  • workload
    • offloading 1
  • workload management 1

Z

  • zero data loss 1