Oracle DBA Checklists Pocket Reference

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. This reference guide is divided into three major sections covering the main areas of an Oracle DBA's responsibilities. The first, on 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). The section on installation and configuration contains a summary of key procedures for installation on Unix, Windows NT, and VMS platforms. It also includes special steps for configuring a parallel database. Finally, the section on 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 aims to take the stress out of DBA problem solving.