Please enable JavaScript.

Coggle requires JavaScript to display documents.

Backup Recovery Concepts (categories of failure (network failure (typical…

- - - - NIC fails
        
        configure multiple network cards
      - network connect fails
        
        configure a backup network connection
      - listener fails
        
        configure backup listener and connect-time failover
  - - - user inadvertently deletes or modifies data
        
        solution: rollback transaction and dependent transactions or rewind table
      - user drops table
        
        solution:recover from recycle bin
  - - - a users session is abnormally terminated
      - a user experiences a program error that terminates session
      - a user performs an abnormal disconnect
        
        solution: a dba's action is not usually needed to resolve user process failures. Instance background processes roll back un committed changes and release locks.
  - - - power outage
      - hardware failure
      - when db instance shutdown before db files are synchronized
      - failure of one of the critical background processes
      - emergency shutdown procedures
  - - - attempts to perform operations with insufficient privileges
        
        solution: provide appropriate object or system privileges
      - attempts to allocate space that fail
        
        solution: enable resumable space allocation, increase owner quota, add space to tablespace
      - attempts to enter invalid data into a table
        
        solution: work with users to validate and correct data
      - logic errors in applications
        
        solution: work with developers to correct program errors
  - - - failure of disk drive
        
        solution: restore affected file from backup
      - failure of disk controller
        
        solution:inform db about new file location
      - deletion or corruption of a file needed for db operation
        
        solution: recover file by applying redo information