administration guide 11g(4)

oracle 11g管理篇

Specifying Oracle Managed Files at Database Creation............................................................2-19 Supporting Bigfile Tablespaces During Database Creation......................................................2-20 Specifying the Database Time Zone and Time Zone File..........................................................2-22 Specifying FORCE LOGGING Mode...........................................................................................2-23 Specifying Initialization Parameters.................................................................................................2-24 About Initialization Parameters and Initialization Parameter Files........................................2-24 Determining the Global Database Name.....................................................................................2-26 Specifying a Fast Recovery Area...................................................................................................2-27 Specifying Control Files ................................................................................................................2-28 Specifying Database Block Sizes...................................................................................................2-28 Specifying the Maximum Number of Processes.........................................................................2-29 Specifying the DDL Lock Timeout...............................................................................................2-30 Specifying the Method of Undo Space Management................................................................2-30 About The COMPATIBLE Initialization Parameter..................................................................2-31 Setting the License Parameter.......................................................................................................2-31 Managing Initialization Parameters Using a Server Parameter File...........................................2-32 What Is a Server Parameter File?..................................................................................................2-32 Migrating to a Server Parameter File...........................................................................................2-33 Creating a Server Parameter File..................................................................................................2-33 The SPFILE Initialization Parameter............................................................................................2-35 Changing Initialization Parameter Values..................................................................................2-35 Clearing Initialization Parameter Values.....................................................................................2-37 Exporting the Server Parameter File............................................................................................2-37 Backing Up the Server Parameter File.........................................................................................2-37 Recovering a Lost or Damaged Server Parameter File..............................................................2-38 Viewing Parameter Settings..........................................................................................................2-38 Managing Application Workloads with Database Services ........................................................2-39 About Database Services ...............................................................................................................2-39 Creating Database Services............................................................................................................2-41 Database Service Data Dictionary Views.....................................................................................2-42 Considerations After Creating a Database.......................................................................................2-42 Some Security Considerations.......................................................................................................2-42 Enabling Transparent Data Encryption.......................................................................................2-43 Creating a Secure External Password Store................................................................................2-44 Installing the Oracle Database Sample Schemas........................................................................2-44 Dropping a Database............................................................................................................................2-44 Database Data Dictionary Views.......................................................................................................2-45 3 Starting Up and Shutting Down

Starting Up a Database............................................................................................................................ 3-1 About Database Startup Options..................................................................................................... 3-1 Specifying Initialization Parameters at Startup............................................................................. 3-2 About Automatic Startup of Database Services............................................................................ 3-5 Preparing to Start Up an Instance.................................................................................................... 3-5 Starting Up an Instance..................................................................................................................... 3-6 Altering Database Availability.............................................................................................................. 3-9 Mounting a Database to an Instance............................................................................................... 3-9

v