BLESPACE=undotbs1 UNDO_RETENTION=5400 ~ ~ ~ ~ ~ ~ ~ ~ "initPROD.ora" [New] 16L, 659C written [oracle@ocm1 dbs]$
4.使用pfile生成spfile。
[oracle@ocm1 dbs]$ export ORACLE_SID=PROD [oracle@ocm1 dbs]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Apr 14 08:33:48 2014
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
@>conn /as sysdba Connected to an idle instance. SYS@PROD>create spfile from pfile;
File created.
SYS@PROD
5.然后启动到nomount，再查看是否以spfile启动的。
SYS@PROD>startup nomount ORACLE instance started.
Total System Global Area 524288000 bytes Fixed Size 1261788 bytes Variable Size 146804516 bytes Database Buffers 373293056 bytes Redo Buffers 2928640 bytes
SYS@PROD>show parameter spfile
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /u01/app/oracle/product/10.2.0 /db_1/dbs/spfilePROD.ora
SYS@PROD>show parameter dest
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_file_dest string /u01/app/oracle/admin/PROD/adump background_dump_dest string /u01/app/oracle/admin/PROD/bdump core_dump_dest string /u01/app/oracle/admin/PROD/cdump db_create_file_dest string /u01/app/oracle/oradata/PROD/Disk1 db_create_online_log_dest_1 string /u01/app/oracle/oradata/PROD/Disk1 ... user_dump_dest string /u01/app/oracle/admin/PROD/udump
6，创建数据库脚本。
[oracle@ocm1 ~]$ pwd /home/oracle [oracle@ocm1 ~]$ vi create_database.sql
CREATE DATABASE PROD USER SYS IDENTIFIED BY oracle USER SYSTEM IDENTIFIED BY oracle LOGFILE GROUP 1 ('/u01/app/oracle/oradata/PROD/Disk1/redo01.log') SIZE 100M, GROUP 2 ('/u01/app/oracle/oradata/PROD/Disk1/redo02.log') SIZE 100M, GROUP 3 ('/u01/app/oracle/oradata/PROD/Disk1/redo03.log') SIZE 100M MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 1 MAXDATAFILES 100 MAXINSTANCES 1 CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16 DATAFILE '/u01/app/oracle/oradata/PROD/Disk1/system01.dbf' SIZE 325M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/u01/app/oracle/oradata/PROD/Disk1/sysaux01.dbf' SIZE 325M REUSE DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE '/u01/app/oracle/oradata/PROD/Disk1/temp01.dbf' SIZE 20M REUSE UNDO TABLESPACE undotbs1 DATAFILE '/u01/app/oracle/oradata/PROD/Disk1/undotbs01.dbf' SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
[oracle@ocm1 ~]$ ll total 4 -rw-r--r-- 1 oracle oinstall 885 Apr 14 08:44 create_database.sql
7.在nomount阶段运行脚本，创建数据库。
SYS@PROD>@/home/oracle/create_database
Database created.
8.创建数据库时，可以查看相关的告警日志。
[oracle@ocm1 bdump]$ tail -f alert_PROD.log
Mon Apr 14 20:43:36 2014 CREATE DATABASE PROD USER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY *LOGFILE GROUP 1 ('/u01/app/oracle/oradata/PROD/Disk1/redo01.log') SIZE 100M, GROUP 2 ('/u01/app/oracle/oradata/PROD/Disk1/redo02.log') SIZE 100M, GROUP 3 ('/u01/app/oracle/oradata/PROD/Disk1/redo03.log') SIZE 100M MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 1 MAXDATAFILES 100 MAXINSTANCES 1 CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16 DATAFILE '/u01/app/oracle/oradata/PROD/Disk1/system01.dbf' SIZE 325M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/u01/app/oracle/oradata/PROD/Disk1/sysaux01.dbf' SIZE 325M REUSE DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE '/u01/app/oracle/oradata/PROD/Disk1/temp01.dbf' SIZE 20M REUSE UNDO TAB |