oracle 11g管理篇

Managing Database Control in an Oracle RAC Environment...................................................10-21 Verifying that Database Control is Running in an Oracle RAC Environment....................10-21 Backing Up the emkey.ora File...................................................................................................10-22 Deleting and Creating Database Control Objects........................................................................10-22 Deleting Database Control Objects.............................................................................................10-22 Creating Database Control Objects.............................................................................................10-24 Re-Creating Or Reconfiguring Database Control.....................................................................10-25 EMCA Troubleshooting Tips............................................................................................................10-25 Using EMCA After Changing the Database Listener Port......................................................10-25 Upgrading 11g Release 2 Grid Control Agents.........................................................................10-26 Using EMCA When the Database Host Name or IP Address Changes................................10-26 Using EMCA When the TNS Configuration Is Changed........................................................10-26 Using EMCA for Desktop Class Installations...........................................................................10-26 Handling EMCA Error Messages...............................................................................................10-27

Part II Oracle Database Structure and Storage

11Managing Control Files

What Is a Control File?.........................................................................................................................11-1 Guidelines for Control Files...............................................................................................................11-2 Provide Filenames for the Control Files......................................................................................11-2 Multiplex Control Files on Different Disks.................................................................................11-2 Back Up Control Files.....................................................................................................................11-3 Manage the Size of Control Files..................................................................................................11-3 Creating Control Files..........................................................................................................................11-3 Creating Initial Control Files.........................................................................................................11-3 Creating Additional Copies, Renaming, and Relocating Control Files .................................11-4 Creating New Control Files...........................................................................................................11-4 Troubleshooting After Creating Control Files.................................................................................11-7 Checking for Missing or Extra Files.............................................................................................11-7 Handling Errors During CREATE CONTROLFILE..................................................................11-7 Backing Up Control Files.....................................................................................................................11-8 Recovering a Control File Using a Current Copy...........................................................................11-8 Recovering from Control File Corruption Using a Control File Copy....................................11-8 Recovering from Permanent Media Failure Using a Control File Copy.................................11-8 Dropping Control Files........................................................................................................................11-9 Control Files Data Dictionary Views.................................................................................................11-9 12 Managing the Redo Log

What Is the Redo Log?..........................................................................................................................12-1 Redo Threads...................................................................................................................................12-1 Redo Log Contents..........................................................................................................................12-2 How Oracle Database Writes to the Redo Log...........................................................................12-2 Planning the Redo Log.........................................................................................................................12-4 Multiplexing Redo Log Files.........................................................................................................12-4 Placing Redo Log Members on Different Disks..........................................................................12-6 x