如何手工创建数据库

这篇文章给大家分享的是有关如何手工创建数据库的内容。小编觉得挺实用的，因此分享给大家做个参考，一起跟随小编过来看看吧。

Refer Doc:Administrator’s Guide->2 Creating and Configuring an Oracle Database->Creating a Database with the CREATE DATABASE Statement

Step 1: Specify an Instance Identifier (SID)

[oracle@OCM ~]$ export ORACLE_SID=PROD3

Step 2: Ensure That the Required Environment Variables Are Set

[oracle@OCM ~]$ env |grep ORACLE

ORACLE_SID=PROD3

ORACLE_BASE=/u01/app/oracle/product

ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

Step 3: Choose a Database Administrator Authentication Method

[oracle@OCM ~]$ cd $ORACLE_HOME/dbs

[oracle@OCM dbs]$ orapwd file=orapwPROD3 password=oracle entries=30

[oracle@OCM dbs]$ ll

total 12

-rw-r--r-- 1 oracle oinstall 2851 May 15  2009 init.ora

-rw-r----- 1 oracle oinstall 5120 Dec  5 07:51 orapwPROD3

Step 4: Create the Initialization Parameter File

[oracle@OCM scripts]$ cat initPROD3.ora

db_name='PROD3'

db_recovery_file_dest=' /u01/app/oracle/product/flash_recovery_area'

db_recovery_file_dest_size=2G

[oracle@OCM product]$ mkdir –p  /u01/app/oracle/product/flash_recovery_area

Step 5: (Windows Only) Create an Instance

Step 6: Connect to the Instance

[oracle@OCM scripts]$ sqlplus / as sysdba

Step 7: Create a Server Parameter File

SQL> CREATE SPFILE FROM PFILE;

Step 8: Start the Instance

SQL>  startup nomount

ORACLE instance started.

Total System Global Area  217157632 bytes

Fixed Size                  2251816 bytes

Variable Size             159384536 bytes

Database Buffers           50331648 bytes

Redo Buffers                5189632 bytes

Step 9: Issue the CREATE DATABASE Statement

[root@OCM ~]# mkdir -p  /u01/app/oracle/oradata/PROD3/redo

[root@OCM ~]# mkdir -p /u01/logs/PROD3

[root@OCM ~]# mkdir -p /u02/logs/PROD3

[root@OCM u01]# cat createdb.sql

CREATE DATABASE PROD3

   USER SYS IDENTIFIED BY sys_password

   USER SYSTEM IDENTIFIED BY system_password

   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/PROD3/redo/redo01a.log','/u01/app/oracle/oradata/PROD3/redo/redo01b.log') SIZE 100M BLOCKSIZE 512,

       GROUP 2 ('/u01/app/oracle/oradata/PROD3/redo/redo02a.log','/u01/app/oracle/oradata/PROD3/redo/redo02b.log') SIZE 100M BLOCKSIZE 512,

       GROUP 3 ('/u01/app/oracle/oradata/PROD3/redo/redo03a.log','/u01/app/oracle/oradata/PROD3/redo/redo03b.log') SIZE 100M BLOCKSIZE 512

   MAXLOGFILES 5

   MAXLOGMEMBERS 5

   MAXLOGHISTORY 1

   MAXDATAFILES 100

   CHARACTER SET AL32UTF8

   NATIONAL CHARACTER SET AL16UTF16

   EXTENT MANAGEMENT LOCAL

   DATAFILE '/u01/app/oracle/oradata/PROD3/system01.dbf' SIZE 325M REUSE

   SYSAUX DATAFILE '/u01/app/oracle/oradata/PROD3/sysaux01.dbf' SIZE 325M REUSE

   DEFAULT TABLESPACE users

      DATAFILE '/u01/app/oracle/oradata/PROD3/users01.dbf'

      SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

   DEFAULT TEMPORARY TABLESPACE tempts1

      TEMPFILE '/u01/app/oracle/oradata/PROD3/temp01.dbf'

      SIZE 20M REUSE

   UNDO TABLESPACE undotbs

      DATAFILE '/u01/app/oracle/oradata/PROD3/undotbs01.dbf'

      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

SQL>  @/u01/createdb.sql

Database created.

Step 10: Create Additional Tablespaces

Step 11: Run Scripts to Build Data Dictionary Views

SQL> @?/rdbms/admin/catalog.sql

SQL> @?/rdbms/admin/catproc.sql

SQL> @?/rdbms/admin/utlrp.sql

Step 12: (Optional) Run Scripts to Install Additional Options

Step 13: Back Up the Database.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area  217157632 bytes

Fixed Size                  2251816 bytes

Variable Size             159384536 bytes

Database Buffers           50331648 bytes

Redo Buffers                5189632 bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

Step 14: (Optional) Enable Automatic Instance Startup

感谢各位的阅读！关于“如何手工创建数据库”这篇文章就分享到这里了，希望以上内容可以对大家有一定的帮助，让大家可以学到更多知识，如果觉得文章不错，可以把它分享出去让更多的人看到吧！