《数据库(中英文翻译)》由会员分享,可在线阅读,更多相关《数据库(中英文翻译)(7页珍藏版)》请在金锄头文库上搜索。
1、原文:Planning the DatabaseIt is important to plan how the logical storage structure of the database will affect system performance and various database management operations. For example, before creating any tablespaces for your database, you should know how many data files will make up the tablespace
2、,what type of information will be stored in each tablespace, and on which disk drives the datafiles will be physically stored. When planning the overall logical storage of the database structure, take into account the effects that this structure will have when the database is actually created and ru
3、nning.You may have database objects that have special storage requirements due to type or size.In distributed database environments, this planning stage is extremely important. The physical location of frequently accessed data dramatically affects application performance.During the planning stage, d
4、evelop a backup strategy for the database. You can alter the logical storage structure or design of the database to improve backup efficiency. Backup strategies are introduced in a later lesson.These are the types of questions and considerations, which you will encounter as a DBA, and this course (i
5、n its entirety) is designed to help you answer them.Databases: ExamplesDifferent types of databases have their own specific instance and storage requirements. YourOracle database software includes templates for the creation of these different types of databases.Characteristics of these examples are
6、the following: Data Warehouse: Store data for long periods and retrieve them in read operations. Transaction Processing: Accommodate many, but usually small, transactions. General Purpose: Work with transactions and store them for a medium length of time.Database Configuration Assistant (DBCA)You ca
7、n use the Database Configuration Assistant (DBCA) to create, change the configuration of, or delete a database. You can also create a database from a list of predefined templates or use an existing database as a sample to create a new database or template. This is sometimes referred to as “database
8、cloning.”You can invoke the DBCA by performing the following steps:1. Log on to your computer as a member of the administrative group that is authorized to install the Oracle software.2. If required, set environment variables.3. Enter dbca to invoke the DBCA.4. Click Next to continue.DBCA offers you
9、 a choice of assisting with several operations, for example, creating a database.Using the DBCA to Create a DatabaseYou can use the DBCA to create a database as follows:1. Select Create a Database on the DBCA Operations page to invoke a wizard that enables you to configure and create a database.The
10、wizard prompts you to provide configuration information as outlined in the steps that follow. On most pages, the wizard provides a default setting that you can accept.2. Select the type of database template to be used in creating the database. There aretemplates for Data Warehouse, General Purpose,
11、and Transaction Processing databases that copy a preconfigured database, including data files. These data files include control files,redo log files, and data files for various included tablespaces.Click Show Details to see the configuration for each type of database.For more complex environments, y
12、ou may want to select the Custom Database option.Password ManagementAfter the DBCA finishes, note the following information for future reference: Location of installation log files (see A) Global database name (see B) System identifier (SID) (see B) Server parameter file name and location (see B) En
13、terprise Manager URL (see C)Click Password Management to unlock database accounts that you plan to use. Provide apassword when you unlock an account.Creating a Database Design TemplateA template is a predefined database definition that you use as a starting point for a new database.If you do not cre
14、ate a template as part of the database creation process, you can do it anytime by invoking the DBCA. You have three ways to create a template: From an existing template From an existing database (structure only) From an existing database (structure as well as data)The DBCA guides you through the ste
15、ps to create a database design template.Using the DBCA to Delete a DatabaseTo delete (or configure) a database in UNIX or Linux, you must setORACLE_SID in the shell from which DBCA is launched. Start the DBCA by entering dbca in a terminal window, and click Next on the Welcome page. To delete the da
16、tabase, perform the following steps:1. On the Operations page, select Delete a Database, and click Next.2. Select the database that you want to delete (in class, hist), and click Finish.3. Click Yes to confirm your deletion.Using the DBCA to Delete a Database (continued)Dropping a database involves removing its data files, redo log files, control files, and initialization parameter fi