ORACLE REAL APPLICATION CLUSTERS
CONTENTS LIST OF FIGURES LIST OF TABLES PART I INTRODUCTION TO ADMINISTERING REAL APPLICATION CLUSTERS 1 1 INTRODUCTION TO REAL APPLICATION CLUSTERS ADMINISTRATION 2 2 PARAMETER MANAGEMENT IN REAL APPLICATION CLUSTERS ENVIRONMENTS 6 3 ADMINISTERING STORAGE COMPONENTS IN REAL APPLICATION CLUSTERS 28 4 ADMINISTERING REAL APPLICATION CLUSTERS DATABASES WITH SERVER CONTROL SQL AND SQL PLUS 42 PART II USING ORACLE ENTERPRISE MANAGER TO ADMINISTER REAL APPLICATION CLUSTERS 60 5 ADMINISTERING REAL APPLICATION CLUSTERS DATABASES WITH ORACLE ENTERPRISE MANAGER 62 PART III BACKUP AND RECOVERY IN REAL APPLICATION CLUSTERS 88 6 CONFIGURING RMAN FOR REAL APPLICATION CLUSTERS 90 7 BACKING UP REAL APPLICATION CLUSTERS DATABASES 18 8 DATABASE RECOVERY IN REAL APPLICATION CLUSTERS 132 PART IV SCALING YOUR REAL APPLICATION CLUSTERS ENVIRONMENT 150 9 ADDING NODES AND INSTANCES AND DELETING INSTANCES IN REAL APPLICATION CLUSTERS 152 PART I INTRODUCTION TO ADMINISTERING REAL APPLICATION CLUSTERS 1 1 INTRODUCTION TO REAL APPLICATION CLUSTERS ADMINISTRATION THIS CHAPTER PROVIDES AN OVERVIEW OF THE PROCESSES AND COMPONENTS INVOLVED IN ADMINISTERING REAL APPLICATION CLUSTERS THIS CHAPTER INCLUDES THE FOLLOWING TOPICS I ADMINISTERING REAL APPLICATION CLUSTERS DATABASES I PARAMETER MANAGEMENT IN REAL APPLICATION CLUSTERS I ADMINISTERING STORAGE IN REAL APPLICATION CLUSTERS I GENERAL ADMINISTRATION ISSUES I ORACLE ENTERPRISE MANAGER IN REAL APPLICATION CLUSTERS I BACKUP AND RECOVERY IN REAL APPLICATION CLUSTERS I SCALING YOUR REAL APPLICATION CLUSTERS ENVIRONMENT I TROUBLESHOOTING 2 ADMINISTERING REAL APPLICATION CLUSTERS DATABASES ADMINISTERING REAL APPLICATION CLUSTERS DATABASES THIS BOOK DESCRIBES REAL APPLICATION CLUSTERS SPECI C 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 SPECI C ADMINISTRATIVE ISSUES PARAMETER MANAGEMENT IN REAL APPLICATION CLUSTERS YOU CAN ESTABLISH CLUSTER WIDE PARAMETER SETTINGS AND SPECIFY INSTANCE SPECI C SETTINGS USING THE SERVER PARAMETER LE OR YOU CAN USE CLIENT SIDE PARAMETER LES TO MANAGE PARAMETER SETTINGS 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 ADMINISTERING STORAGE IN REAL APPLICATION CLUSTERS THERE ARE REAL APPLICATION CLUSTERS SPECI C STORAGE MANAGEMENT ISSUES TO CONSIDER SUCH AS DATA LE ADMINISTRATION AND UNDO TABLESPACE MANAGEMENT YOU MUST ALSO UNDERSTAND REDO LOG LE 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 GENERAL ADMINISTRATION ISSUES 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 SEE ALSO CHAPTER 2 PARAMETER MANAGEMENT IN REAL APPLICATION CLUSTERS ENVIRONMENTS SEE ALSO CHAPTER 3 ADMINISTERING STORAGE COMPONENTS IN REAL APPLICATION CLUSTERS 3