oracle 10g之手工建库的方法(四)
6897664 Aug 9 17:49 control03.ctl
-rw-r----- 1 oracle oinstall 52429312 Aug 9 17:49 redo01_1.log
-rw-r----- 1 oracle oinstall 52429312 Aug 9 17:49 redo01_2.log
-rw-r----- 1 oracle oinstall 52429312 Aug 9 17:38 redo02_1.log
-rw-r----- 1 oracle oinstall 52429312 Aug 9 17:38 redo02_2.log
-rw-r----- 1 oracle oinstall 52429312 Aug 9 17:38 redo03_1.log
-rw-r----- 1 oracle oinstall 52429312 Aug 9 17:38 redo03_2.log
-rw-r----- 1 oracle oinstall 314580992 Aug 9 17:39 sysaux01.dbf
-rw-r----- 1 oracle oinstall 367009792 Aug 9 17:45 system01.dbf
-rw-r----- 1 oracle oinstall 104865792 Aug 9 17:39 temp01.dbf
-rw-r----- 1 oracle oinstall 209723392 Aug 9 17:44 undotbs01.dbf
8.创建用户表空间users
SQL> CREATE TABLESPACE "USERS" DATAFILE '/u01/oracle/oradata/ORCL/users01.dbf' SIZE 100M AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M;
Tablespace created. www.2cto.com
9.修改users表空间为用户默认表空间
SQL> alter database default tablespace users;
Database altered.
10.运行脚本，重建数据字典视图
SQL>@/u01/oracle/product/10.2.0/db_1/rdbms/admin/catalog.sql
SQL>@/u01/oracle/product/10.2.0/db_1/rdbms/admin/catproc.sql
SQL>@//u01/oracle/product/10.2.0/db_1/sqlplus/admin/pupbld.sql
如果initORCL.ora文件中设置的参数不是*.compatible='10.2.0.3.0'，则需要执行以下命令升级数据库
SQL>startup upgrade
SQL>@/u01/oracle/product/10.2.0/db_1/rdbms/admin/catupgrd.sql
11.设置listener
[oracle@oracle10g admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle10g.cluster.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
三、测试数据库
1.创建测试用户test
SQL> create user test identified by test;
User created.
SQL> grant connect,resource to test;
Grant succeeded.
SQL> select default_tablespace,temporary_tablespace from dba_users where username='TEST';
DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
------------------------------ ------------------------------
USERS TEMP
SQL> conn test/test
Connected.
SQL> show user
USER is "TEST"
SQL> create table test (id number);
Table created. www.2cto.com
SQL> insert into test values (1);
1 row created.
SQL> select id from test;
ID
----------
1
2.使用rman工具来备份数据库
[oracle@oracle10g dbs]$ rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Tue Aug 21 15:50:34 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1319428512)
RMAN> backup database;
Starting backup at 2012-08-21 15:53:55
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=142 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/oracle/oradata/ORCL/system01.dbf
input datafile fno