(Les03 DB_DBCA) [20180206]

Source: Internet
Author: User
Tags dedicated server

Learning goals     using Database Configuration Assistant (DBCA) to create databases     using DBCA to generate database creation scripts      Use DBCA to manage database design templates     Perform other tasks with DBCA   Planning database     database logical storage structure and its physical implementation         Number of disks? Use the type of storage?         How many data files are needed? (Plan to consider future growth)         How many table spaces are used?         What types of data are stored?         Are there special types of storage requirements?     Overall database design     Database backup strategy   Database example     Universal database (OLAP) and transaction processing database (OLTP)         Online transaction processing (OLTP) systems     Customization         Multipurpose databases (combined with OLTP and database warehouse capabilities)     Data Warehouse ( Require long-term storage of data)         Research and marketing data         aggregated data         Professional Certification data   Select the appropriate character set     Oracle DB supports multiple character encodings (three, single-byte/variable-width multibyte, and universal)             Single-byte character set                -7-bit                -8-bit             Multi-byte character set, Including the unicode    character set is selected when the database is created, it is difficult to change after the selected character set     Generally, it is recommended to select Unicode because it is the most flexible character set          7-bit character set         7-bit US Information Interchange Standard Code (ASCII) (US7ASCII)     8-bit character set         Western European Standards Organization (ISO) 8859-1 (WE8ISO8859P1)         8-bit western Europe Dec (WE8DEC)         8-bit Italian extended binary encoded Decimal Interchange Code (EBCDIC) code page 1144 (i8i8ebcdic1144)                multibyte Character set             Wide-variable multibyte character set, where each character is represented by one or more bytes.             Unicode is a universal coded character set that supports the habit of storing any one language using a single character set.                 Wide-variable multi-byte                  16-digit Japanese Shift-jis (ja16sjis)               &nbsP   Using the Hong Kong supplementary character set HKSCS-2001 MS Windows code page 950 (ZHT16HKSCS)                  Unicode 4.0 UTF-8 Universal Character Set (Al32utf8)-A variable-width encoding type, also a strict superset of ASCII                  Unicode (ALI16UTF16)-microsoft 16-bit Unicode encoding used by Windows 2000 and Windows XP           If using character set                 Oracle NET compares the Nls_lang settings on the client to the character set on the server.                 Automatic transparent conversion if required (the server character set is a superset of the client character set or the same does not perform validation or conversion, Others are transparently converted).         Issues to avoid    NLS in              Client _lang parameter is not set correctly, invalid data is entered in the database.                     Nls_lang parameters are set correctly, The database can automatically convert incoming data from the client operating system.                     Nls_lang parameters are set incorrectly, Input data will not be converted correctly database configuration Assistant (DBCA) database Config Assistant             Invoke dbca            Select actions to perform using the Oracle Software Installation account                     Create a database creating databases              Select database Templates                     General Purpose or Transaction procession (generic or transactional)                      Custom database (custom databases)                      data Warehouse (database warehouse)             DB identification (Database ID)                     Enter database name and system identifier sid            Management Options (tube                    Oracle Enterprise Manager Management Database (OEM)                      Start automatic maintenance tasks, such as optimizing program statistics, collecting and preventative guidance reports.             Database Credentials (DB certification)                      SYS and system password designation             Database file Locations (db files location)                     Automatic Storage Management (ASM) automatic storage Management                & nbsp;    File System (FileSystem)                      Multiplex Redo Logs and Control files (multiplexing redo logs and controls)            & nbsp;                Adjustment oracle_base/oracle_home/db_name/db_unique_name/sid            Recovery configuration (Restore config)                     Configuring the quick Recovery Zone             Database content (DB contents)                      includes sample objects such as HR and other test materials             Initialization Parameters (initialization parameters)                      memory Ram                          Typical typical or custion customization            & nbsp;        Sizing resizing                          Specify data block size                     Character sets character set                      Best tips: Oracle Corporation recommends using Unicode as the database character set.                     Connect mode connection modes                          Dedicated Server mode dedicated server modes                          Shared server mode share servers modes                 Note: Some initialization parameters are constant throughout the database life cycle, such as db_block_size parameters                  Storage (Database storage)                 Create Options (Create options)                 Database creation summary                  Schema password management                  DBCA The following information to be recorded after completion                          Location of installation log files                         Global database name                    & nbsp;    System identifiers sid                   & nbsp;            Server parameter file name and location                          Oracle Enterprise manager URL (OEM management)      Create a database template             Three ways to create modeled                  Based on existing templates                 Based on existing database (structure only)                 Delete a database based on an existing database (structure and data)          using DBCA             Note: The database to be deleted must be valid and running so that DBCA can connect to the database to determine the file location.             Manually deleting a database drop database         & nbsp      must meet the following conditions                     The database must be mounted and closed                     The database must be loaded exclusively                     database must already be started in restrict mode                         STARTUP RESTRICT Force mount;                    & nbsp   DROP database; &nbsp                  DROP DATABASE statements do not work on archive files, nor do backups of databases.                     Best use of recovery Manager (RMAN) to remove backups and archives.      Complete other tasks with DBCA             Oracle Label Security Administrator's Guide              Oracle Database Vault Administrator ' s Guide                 

(Les03 DB_DBCA) [20180206]

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.