分布数据文件访问多个磁盘

1.多路复用online redo logfile;


SYS@PROD3 > col member for a50;
SYS@PROD3 > select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                                             IS_
---------- ------- ------- -------------------------------------------------- ---
         1         ONLINE  /home/oracle/app/oradata/PROD3/redo01a.log         NO
         1         ONLINE  /home/oracle/app/oradata/PROD3/redo01b.log         NO
         2         ONLINE  /home/oracle/app/oradata/PROD3/redo02a.log         NO
         2         ONLINE  /home/oracle/app/oradata/PROD3/redo02b.log         NO
         3         ONLINE  /home/oracle/app/oradata/PROD3/redo03a.log         NO
         3         ONLINE  /home/oracle/app/oradata/PROD3/redo03b.log         NO

6 rows selected.

SYS@PROD3 > alter database add logfile group 4 ('/home/oracle/app/oradata/PROD3/redo04a.log','/home/oracle/app/oradata/PROD3/redo04b.log') size 100m;

Database altered.

SYS@PROD3 > select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                                             IS_
---------- ------- ------- -------------------------------------------------- ---
         1         ONLINE  /home/oracle/app/oradata/PROD3/redo01a.log         NO
         1         ONLINE  /home/oracle/app/oradata/PROD3/redo01b.log         NO
         2         ONLINE  /home/oracle/app/oradata/PROD3/redo02a.log         NO
         2         ONLINE  /home/oracle/app/oradata/PROD3/redo02b.log         NO
         3         ONLINE  /home/oracle/app/oradata/PROD3/redo03a.log         NO
         3         ONLINE  /home/oracle/app/oradata/PROD3/redo03b.log         NO
         4         ONLINE  /home/oracle/app/oradata/PROD3/redo04a.log         NO
         4         ONLINE  /home/oracle/app/oradata/PROD3/redo04b.log         NO

8 rows selected.

SYS@PROD3 > alter database drop logfile group 4;

Database altered.

2.多路复用control files

--查询控制文件的路径
SYS@PROD3 > select name from v$controlfile;

NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/home/oracle/app/oradata/PROD3/control01.ctl
/home/oracle/app/oradata/PROD3/control02.ctl
--修改control_files参数
SYS@PROD3 > alter system set control_files='/home/oracle/app/oradata/PROD3/control01.ctl','/home/oracle/app/oradata/PROD3/control02.ctl','/home/oracle/app/oradata/PROD3/control03.ctl' scope=spfile;

System altered.
--关库
SYS@PROD3 > shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
--拷贝到指定路径
[oracle@gridcontrol ~]$ cp /home/oracle/app/oradata/PROD3/control01.ctl /home/oracle/app/oradata/PROD3/control03.ctl
--重启实例
SYS@PROD3 > startup
ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size                  2229944 bytes
Variable Size             398461256 bytes
Database Buffers          113246208 bytes
Redo Buffers                7999488 bytes
Database mounted.
Database opened.

3.分布数据文件
建立表空间不同的数据文件放在不同的磁盘

SYS@PROD3 > select file_name,tablespace_name from dba_data_files;

FILE_NAME                                                    TABLESPACE_NAME
------------------------------------------------------------ ------------------------------
/home/oracle/app/oradata/PROD3/system01.dbf                  SYSTEM
/home/oracle/app/oradata/PROD3/sysaux01.dbf                  SYSAUX
/home/oracle/app/oradata/PROD3/undotbs01.dbf                 UNDOTBS
/home/oracle/app/oradata/PROD3/users01.dbf                   USERS
--创建表空间
SYS@PROD3 > create tablespace lob_data
  2  datafile '/home/oracle/app/oradata/PROD3/lob_data01.dbf' size 20m autoextend on;

Tablespace created.
--新增数据文件,这里是在相同的磁盘
SYS@PROD3 > alter tablespace lob_data add datafile '/home/oracle/app/oradata/PROD3/lob_data02.dbf' size 20m autoextend on;

Tablespace altered.

SYS@PROD3 > select file_name,tablespace_name from dba_data_files;

FILE_NAME                                                    TABLESPACE_NAME
------------------------------------------------------------ ------------------------------
/home/oracle/app/oradata/PROD3/system01.dbf                  SYSTEM
/home/oracle/app/oradata/PROD3/sysaux01.dbf                  SYSAUX
/home/oracle/app/oradata/PROD3/undotbs01.dbf                 UNDOTBS
/home/oracle/app/oradata/PROD3/users01.dbf                   USERS
/home/oracle/app/oradata/PROD3/lob_data01.dbf                LOB_DATA
/home/oracle/app/oradata/PROD3/lob_data02.dbf                LOB_DATA

6 rows selected.

SYS@PROD3 > drop tablespace lob_data including contents and datafiles;

Tablespace dropped.

SYS@PROD3 > select file_name,tablespace_name from dba_data_files;

FILE_NAME                                                    TABLESPACE_NAME
------------------------------------------------------------ ------------------------------
/home/oracle/app/oradata/PROD3/system01.dbf                  SYSTEM
/home/oracle/app/oradata/PROD3/sysaux01.dbf                  SYSAUX
/home/oracle/app/oradata/PROD3/undotbs01.dbf                 UNDOTBS
/home/oracle/app/oradata/PROD3/users01.dbf                   USERS

–本文乃原创文章,请勿转载。如须转载请详细标明转载出处

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值