oracle 11g管理篇

Planning the Size of Redo Log Files.............................................................................................12-7 Planning the Block Size of Redo Log Files..................................................................................12-7 Choosing the Number of Redo Log Files....................................................................................12-8 Controlling Archive Lag ...............................................................................................................12-9 Creating Redo Log Groups and Members......................................................................................12-10 Creating Redo Log Groups..........................................................................................................12-10 Creating Redo Log Members.......................................................................................................12-11 Relocating and Renaming Redo Log Members ............................................................................12-11 Dropping Redo Log Groups and Members...................................................................................12-12 Dropping Log Groups..................................................................................................................12-13 Dropping Redo Log Members.....................................................................................................12-13 Forcing Log Switches..........................................................................................................................12-14 Verifying Blocks in Redo Log Files.................................................................................................12-14 Clearing a Redo Log File....................................................................................................................12-15 Redo Log Data Dictionary Views ....................................................................................................12-16 13 Managing Archived Redo Logs

What Is the Archived Redo Log?........................................................................................................13-1 Choosing Between NOARCHIVELOG and ARCHIVELOG Mode...........................................13-2 Running a Database in NOARCHIVELOG Mode.....................................................................13-2 Running a Database in ARCHIVELOG Mode............................................................................13-3 Controlling Archiving..........................................................................................................................13-4 Setting the Initial Database Archiving Mode..............................................................................13-4 Changing the Database Archiving Mode ...................................................................................13-4 Performing Manual Archiving......................................................................................................13-5 Adjusting the Number of Archiver Processes............................................................................13-5 Specifying Archive Destinations.......................................................................................................13-6 Setting Initialization Parameters for Archive Destinations......................................................13-6 Understanding Archive Destination Status................................................................................13-9 Specifying Alternate Destinations..............................................................................................13-10 About Log Transmission Modes.......................................................................................................13-10 Normal Transmission Mode........................................................................................................13-10 Standby Transmission Mode ......................................................................................................13-10 Managing Archive Destination Failure..........................................................................................13-11 Specifying the Minimum Number of Successful Destinations...............................................13-11 Rearchiving to a Failed Destination...........................................................................................13-12 Controlling Trace Output Generated by the Archivelog Process..............................................13-13 Viewing Information About the Archived Redo Log..................................................................13-14 Archived Redo Logs Views.........................................................................................................13-14 The ARCHIVE LOG LIST Command.........................................................................................13-15 14 Managing Tablespaces

Guidelines for Managing Tablespaces..............................................................................................14-1 Using Multiple Tablespaces...........................................................................................................14-2 Assigning Tablespace Quotas to Users........................................................................................14-2 Creating Tablespaces............................................................................................................................14-2

xi