|Oracle9i Real Application Clusters Administration
Release 1 (9.0.1)
Part Number A89869-02
This chapter provides an overview of the processes and components involved in administering Real Application Clusters. This chapter includes the following topics:
This book describes Real Application Clusters-specific administrative duties. These tasks are in addition to those described in the Oracle9i Database Administrator's Guide which you should read before you use this book to administer Real Application Clusters. The following is an overview of the Real Application Clusters-specific administrative issues.
There are also three types of parameters in Real Application Clusters. Some parameters can have different values for one or more instances while others must be either the same for all instances or unique among all instances. Parameter settings also have unique effects on instance startup within Real Application Clusters databases.
There are Real Application Clusters-specific storage management issues to consider such as data file administration and undo tablespace management. You must also understand redo log file management and the use of threads of redo in Real Application Clusters instances.
Storage management also involves associating instances, users, and resources with free list groups. Controlling extent allocation and using sequence number generators are other storage management issues you must consider.
You can start and stop Real Application Clusters instances and databases using SQL, SQL*Plus, and command-line utilities. You can also set and connect to remote instances and perform administrative operations by way of Oracle Net. However, SQL and SQL*Plus commands can have both local and global effects on instances.
You can also use the SRVCTL utility to perform many administrative duties in Real Application Clusters databases. You can also use SRVCTL to perform other tasks such as managing configuration information, and to delete, rename, and move instances.
You can use Oracle Enterprise Manager to perform most administrative duties in Real Application Clusters. Use Oracle Enterprise Manager to start and stop instances, monitor their performance, schedule jobs, and to perform backup and recovery operations.
You can use RMAN or operating system commands to perform both open and closed backups in Real Application Clusters. Your recovery options in Real Application Clusters include complete, incomplete, and block media recovery. You can also use parallel recovery.
To meet increased system demands or replace failed hardware, you can add nodes and instances and delete instances in Real Application Clusters. Use the Oracle Universal Installer (OUI) and the Oracle Database Configuration Assistant (DBCA) to dynamically add nodes and to add and remove instances.
Oracle records processing information in various trace and log files. You can refer to these files for troubleshooting information and you should regularly copy these files to avoid overwriting them.
Chapter A, "Troubleshooting" for more information about these files