• Table of Contents

  Page III

• + Oracle DBA Checklists Pocket Reference

  Page 1

  • Introduction

    Page 1

  • + Database Management

    Page 4

    • + Performing Routine DBA Procedures

      Page 4

      • Daily DBA procedures

        Page 5

      • Weekly DBA procedures

        Page 8

      • Monthly DBA procedures

        Page 9

    • + Preparing a Database for Production

      Page 10

      • Core database

        Page 10

      • Core database checklist

        Page 11

      • Application schema

        Page 14

      • Application schema checklist

        Page 14

    • + Performing Backup and Recovery

      Page 15

      • Disk setup

        Page 16

      • Recover from loss of a single tablespace’s datafile

        Page 19

      • Recover a deleted table

        Page 20

      • Recover from loss of executables and control file

        Page 21

      • Recover from loss of datafiles and/or index files

        Page 22

      • Recover from loss of all rollback segments

        Page 23

      • Recover from loss of an active rollback segment

        Page 25

      • Recover from loss of an inactive redo log file

        Page 26

      • Recover from loss of an active redo log file

        Page 29

      • Recover from loss of archive logs

        Page 30

      • Recover from loss of all control files

        Page 31

  • + Installation and Configuration

    Page 32

    • Installing Oracle on Unix

      Page 33

    • Installing Oracle on Windows NT

      Page 37

    • Installing Oracle on VMS

      Page 40

    • + Creating a Parallel Oracle Database

      Page 52

      • Parallel database issues

        Page 52

      • Parallel database setup checklist

        Page 53

  • + Network Management

    Page 56

    • Confirming Network Availability

      Page 57

    • Confirming Net8 Connectivity

      Page 58

    • Verifying Net8 Name Resolution

      Page 59

    • Configuring Net8 Clients

      Page 62

    • Configuring Net8 Clients to Use LDAP

      Page 63

    • Configuring Net8 Clients to Use Oracle Names

      Page 65

    • Configuring Net8 on the Server

      Page 67

    • Configuring Multi-Threaded Server

      Page 71

    • Tracing Client Connections

      Page 73

    • Tracing the Listener

      Page 75

Oracle database administration is a complex and stressful job. In a series of easy-to-use checklists, this concise pocket reference summarizes the enormous number of tasks you must perform as an Oracle DBA. Each section takes a step- by-step "cookbook" approach to presenting DBA quick-reference material. The Oracle DBA Checklists Pocket Reference is divided into three major sections covering the main areas of an Oracle DBA's responsibilities: Database management. Describes how to maintain existing databases (with a checklist of daily, weekly, and monthly activities), prepare new databases for production, and back up and recover databases (with checklists for how to recover tables, data files, index files, control files, rollback segments, and active and inactive redo logs). Installation and configuration. Contains a summary of key procedures for installation on Unix, Windows NT, and VMS platforms. Also includes special steps for configuring a parallel database. Network management. Helps with installing, configuring, and testing Net8 software on server and client machines. Tasks include confirming network availability and Net8 connectivity, verifying Net8 name resolution, configuring Net8 clients (with LDAP or Oracle Names), configuring Net8 on the server, configuring the Multi-Threaded Server (MTS), tracing client connections, and tracing the Net8 listener. This book's quick-reference, step-by-step approach takes the stress out of DBA problem solving by making it easy to find the information you need --and find it fast.