oracle 10g DataGuard 双机搭建--创建主库

最新推荐文章于 2024-01-25 11:49:12 发布

大唐9527

最新推荐文章于 2024-01-25 11:49:12 发布

阅读量121

点赞数

CC 4.0 BY-SA版权

分类专栏：系统实战文章标签： oracle 10g DataGuard primary

本文链接：https://blog.youkuaiyun.com/wwtang9527/article/details/84264909

系统实战专栏收录该内容

21 篇文章

订阅专栏

本文详细介绍了手动创建Oracle数据库的过程，包括pfile的创建、关键参数设置、数据库启动到nomount状态、数据库创建命令及用户表空间的创建，并提供了创建数据库字典等对象的脚本路径。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

手动创建pfile，一般最少需要下面5个参数：


db_name       = prod
control_files = ('/u01/app/oracle/oradata/prod/control1.dbf',
                 '/u01/app/oracle/oradata/prod/control2.dbf',
                 '/u01/app/oracle/oradata/prod/control3.dbf')
sga_target    = 400m
undo_management   = AUTO
undo_tablespace   = undotbs

生成spfile文件，为启动到nomount准备：

create spfile from pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/initprod2.ora';

SQL> create spfile from pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/initprod2.ora';

File created.

启动数据库到nomount状态：

startup nomount;

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 419430400 bytes
Fixed Size 1219736 bytes
Variable Size 121635688 bytes
Database Buffers 289406976 bytes
Redo Buffers 7168000 bytes

创建数据库：

CREATE DATABASE prod
   USER SYS IDENTIFIED BY oracle
   USER SYSTEM IDENTIFIED BY oracle
   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/prod/redo01.log') SIZE 50M,
           GROUP 2 ('/u01/app/oracle/oradata/prod/redo02.log') SIZE 50M,
           GROUP 3 ('/u01/app/oracle/oradata/prod/redo03.log') SIZE 50M
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   MAXINSTANCES 1
   CHARACTER SET ZHS16GBK
   NATIONAL CHARACTER SET AL16UTF16
   DATAFILE '/u01/app/oracle/oradata/prod/system01.dbf' SIZE 325M REUSE
   EXTENT MANAGEMENT LOCAL
   SYSAUX DATAFILE '/u01/app/oracle/oradata/prod/sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/u01/app/oracle/oradata/prod/temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE undotbs
      DATAFILE '/u01/app/oracle/oradata/prod/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

Database created.

创建一个用户表空间：

CREATE TABLESPACE users LOGGING
     DATAFILE '/u01/app/oracle/oradata/prod/users01.dbf'
     SIZE 50M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED
     EXTENT MANAGEMENT LOCAL;

运行创建字典等对象脚步：


@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catalog.sql
@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catproc.sql