如何手工创建数据库

共计 3328 个字符，预计需要花费 9 分钟才能阅读完成。

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

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

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