OMS数据库调整1
一、增加2T存储空间
1、 对磁盘进行分区并格式化
[root@oms-db01 ~]# fdisk -l
Disk /dev/sda: 322.1 GB, 322122547200 bytes
255 heads, 63 sectors/track, 39162 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sda1 * 1 13 104391 83 Linux
/dev/sda2 14 39162 314464342+ 8e Linux LVM
Disk /dev/sdb: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk /dev/sdb doesn't contain a valid partition table
[root@oms-db01 ~]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.
The number of cylinders for this disk is set to 267349.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)
WARNING: The size of this disk is 2.2 TB (2199023255552 bytes).
DOS partition table format can not be used on drives for volumes
larger than 2.2 TB (2199023255040 bytes). Use parted(1) and GUID
partition table format (GPT).
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-267349, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-267349, default 267349):
Using default value 267349
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@oms-db01 ~]# fdisk -l
Disk /dev/sda: 322.1 GB, 322122547200 bytes
255 heads, 63 sectors/track, 39162 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sda1 * 1 13 104391 83 Linux
/dev/sda2 14 39162 314464342+ 8e Linux LVM
WARNING: The size of this disk is 2.2 TB (2199023255552 bytes).
DOS partition table format can not be used on drives for volumes
larger than 2.2 TB (2199023255040 bytes). Use parted(1) and GUID
partition table format (GPT).
Disk /dev/sdb: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdb1 1 267349 2147480811 83 Linux
[root@oms-db01 /]# mkfs.ext3 /dev/sdb1
mke2fs 1.39 (29-May-2006)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
268435456 inodes, 536870202 blocks
26843510 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=4294967296
16384 block groups
32768 blocks per group, 32768 fragments per group
16384 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
4096000, 7962624, 11239424, 20480000, 23887872, 71663616, 78675968,
102400000, 214990848, 512000000
Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information:
done
This filesystem will be automatically checked every 35 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.
2、 创建目录挂载磁盘
[root@oms-db01 /]# mkdir oradata
[root@oms-db01 /]# chown -R oracle:oisntall oradata/
[root@oms-db01 /]# mount /dev/sdb1 oradata/
[root@oms-db01 /]# df -h
文件系统 容量 已用 可用 已用% 挂载点
/dev/mapper/VolGroup00-LogVol00
274G 166G 94G 64% /
/dev/sda1 99M 13M 81M 14% /boot
tmpfs 7.9G 0 7.9G 0% /dev/shm
/dev/sdb1 2.0T 199M 1.9T 1% /oradata
二、修改归档模式及归档日志路径
1、 修改数据库归档日志文件路径
alter system set log_archive_dest_1='location=/oradata/omsdb/archivelog';
2、 重启数据库至MOUNT状态
Shutdown immediate
Startup mount
3、 修改数据库为归档模式
Alter database archivelog
4、 打开数据库
Alter database open
三、修改数据文件路径
1、 将表空间offline
alter tablespace oms_data offline;
2、 CP数据文件到指定目录
cp /u01/app/oracle/oradata/omsdb/oms_data01.dbf /oradata/omsdb/datafiles/oms_data01.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data02.dbf /oradata/omsdb/datafiles/oms_data02.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data03.dbf /oradata/omsdb/datafiles/oms_data03.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data04.dbf /oradata/omsdb/datafiles/oms_data04.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data05.dbf /oradata/omsdb/datafiles/oms_data05.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data06.dbf /oradata/omsdb/datafiles/oms_data06.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data07.dbf /oradata/omsdb/datafiles/oms_data07.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data08.dbf /oradata/omsdb/datafiles/oms_data08.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data09.dbf /oradata/omsdb/datafiles/oms_data09.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data10.dbf /oradata/omsdb/datafiles/oms_data10.dbf
3、 修改表空间数据文件指向
alter database rename file '/u01/app/oracle/oradata/omsdb/oms_data01.dbf' to '/oradata/omsdb/datafiles/oms_data01.dbf';
alter database rename file '/u01/app/oracle/oradata/omsdb/oms_data02.dbf' to '/oradata/omsdb/datafiles/oms_data02.dbf';
alter database rename file '/u01/app/oracle/oradata/omsdb/oms_data03.dbf' to '/oradata/omsdb/datafiles/oms_data03.dbf';
alter database rename file '/u01/app/oracle/oradata/omsdb/oms_data04.dbf' to '/oradata/omsdb/datafiles/oms_data04.dbf';
alter database rename file '/u01/app/oracle/oradata/omsdb/oms_data05.dbf' to '/oradata/omsdb/datafiles/oms_data05.dbf';
alter database rename file '/u01/app/oracle/oradata/omsdb/oms_data06.dbf' to '/oradata/omsdb/datafiles/oms_data06.dbf';
alter database rename file '/u01/app/oracle/oradata/omsdb/oms_data07.dbf' to '/oradata/omsdb/datafiles/oms_data07.dbf';
alter database rename file '/u01/app/oracle/oradata/omsdb/oms_data08.dbf' to '/oradata/omsdb/datafiles/oms_data08.dbf';
alter database rename file '/u01/app/oracle/oradata/omsdb/oms_data09.dbf' to '/oradata/omsdb/datafiles/oms_data09.dbf';
alter database rename file '/u01/app/oracle/oradata/omsdb/oms_data10.dbf' to '/oradata/omsdb/datafiles/oms_data10.dbf';
4、将表空间online
Alter tablespace oms_data online
四、备份数据库
Rman备份全库
五、将OMS_LOGINFOR表转换成分区表
1、创建OMS_LOGINFOR_1分区表,以REQUESTINCOMETIME字段每天分区
2、将OMS_LOGINFOR表数据写入到OMS_LOGINFOR_1
Insert into OMS_LOGINFOR_1 select * from OMS_LOGINFOR;
3、删除OMS_LOGINFOR表,再将OMS_LOGINFOR_1表重命名为OMS_LOGINFOR
Drop table OMS_LOGINFOR;
Alter table OMS_LOGINFOR_1 rename to OMS_LOGINFOR;
-- Create table
createtable OMS_LOGINFOR
(
autoid NUMBERnotnull,
requestid VARCHAR2(200),
customerno VARCHAR2(64),
systemcode VARCHAR2(64),
interfacecodeto VARCHAR2(64),
type VARCHAR2(20),
content CLOB,
creator VARCHAR2(20),
createtime DATE,
interfacecodefor VARCHAR2(64),
modular VARCHAR2(20),
requestincometime TIMESTAMP(9),
responseouttime TIMESTAMP(9),
orlrequestdata CLOB,
conversionrequest CLOB,
orlresponsedata CLOB,
conversionresponse CLOB
)
partitionbyrange (REQUESTINCOMETIME) interval (numtoyMinterval (1,' DAY '))
(
partition p_2017_03_01 valueslessthan (to_date('2017-03-01', 'yyyy-mm-dd'))
)
tablespace OMS_DATA
pctfree10
initrans1
maxtrans255
storage
(
initial64K
next8K
minextents1
maxextentsunlimited
);
-- Add comments to the table
commentontable OMS_LOGINFOR
is'日志信息表';
-- Add comments to the columns
commentoncolumn OMS_LOGINFOR.autoid
is'序列自增长';
commentoncolumn OMS_LOGINFOR.requestid
is'一次请求开始到请求结束,ID唯一';
commentoncolumn OMS_LOGINFOR.customerno
is'客户编号';
commentoncolumn OMS_LOGINFOR.systemcode
is'系统编号';
commentoncolumn OMS_LOGINFOR.interfacecodeto
is'接口编号';
commentoncolumn OMS_LOGINFOR.type
is'日志类型';
commentoncolumn OMS_LOGINFOR.content
is'日志内容';
commentoncolumn OMS_LOGINFOR.creator
is'创建人';
commentoncolumn OMS_LOGINFOR.createtime
is'日志产生时间';
commentoncolumn OMS_LOGINFOR.interfacecodefor
is'目标接口编号';
commentoncolumn OMS_LOGINFOR.modular
is'日志产生的模块';
commentoncolumn OMS_LOGINFOR.requestincometime
is'请求进入时间';
commentoncolumn OMS_LOGINFOR.responseouttime
is'请求返回时间';
commentoncolumn OMS_LOGINFOR.orlrequestdata
is'原始请求数据';
commentoncolumn OMS_LOGINFOR.conversionrequest
is'oms转换后请求数据';
commentoncolumn OMS_LOGINFOR.orlresponsedata
is'原始返回数据';
commentoncolumn OMS_LOGINFOR.conversionresponse
is'oms转换后返回数据';
-- Create/Recreate indexes
createbitmapindex IDX_OMS_LOG on OMS_LOGINFOR (INTERFACECODEFOR)
tablespace OMS_DATA
pctfree10
initrans2
maxtrans255
storage
(
initial64K
next1M
minextents1
maxextentsunlimited
);
createindex IDX_OMS_REQTIME on OMS_LOGINFOR (REQUESTINCOMETIME)
tablespace OMS_DATA
pctfree10
initrans2
maxtrans255
storage
(
initial64K
next1M
minextents1
maxextentsunlimited
);
-- Create/Recreate primary, unique and foreign key constraints
altertable OMS_LOGINFOR
addconstraint PK_AUTOID primarykey (AUTOID)
usingindex
tablespace OMS_DATA
pctfree10
initrans2
maxtrans255
storage
(
initial64K
next1M
minextents1
maxextentsunlimited
);
六、调整REDO日志组文件大小
1、增加日志组:
alter database add logfile group 4 '/oradata/omsdb/onlinelog/redo04.log' size 1024M;
alter database add logfile group 5 '/oradata/omsdb/onlinelog/redo05.log' size 1024M;
alter database add logfile group 6 '/oradata/omsdb/onlinelog/redo06.log' size 1024M;
alter database add logfile group 1 '/oradata/omsdb/onlinelog/redo01.log' size 1024M;
alter database add logfile group 2 '/oradata/omsdb/onlinelog/redo02.log' size 1024M;
alter database add logfile group 3 '/oradata/omsdb/onlinelog/redo03.log' size 1024M;
4、 删除日志组:
切换日志状态:
Alter system switch logfile;
Alter system checkpoint;
删除日志:
Alter database drop logfile group 1;
Alter database drop logfile group 2;
Alter database drop logfile group 3;
5、 删除日志文件
Rm /u01/app/oracle/oradata/omsdb/redo01.log
Rm /u01/app/oracle/oradata/omsdb/redo02.log
Rm /u01/app/oracle/oradata/omsdb/redo03.log
一、增加2T存储空间
1、 对磁盘进行分区并格式化
[root@oms-db01
~]# fdisk -l
Disk
/dev/sda: 322.1 GB, 322122547200 bytes
255
heads, 63 sectors/track, 39162 cylinders
Units =
cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks
Id System
/dev/sda1 *
1 13 104391
83 Linux
/dev/sda2 14 39162
314464342+ 8e Linux LVM
Disk
/dev/sdb: 2199.0 GB, 2199023255552 bytes
255
heads, 63 sectors/track, 267349 cylinders
Units =
cylinders of 16065 * 512 = 8225280 bytes
Disk
/dev/sdb doesn't contain a valid partition table
[root@oms-db01
~]# fdisk /dev/sdb
Device
contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building
a new DOS disklabel. Changes will remain in memory only,
until you
decide to write them. After that, of course, the previous
content
won't be recoverable.
The
number of cylinders for this disk is set to 267349.
There is
nothing wrong with that, but this is larger than 1024,
and could
in certain setups cause problems with:
1)
software that runs at boot time (e.g., old versions of LILO)
2)
booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)
WARNING:
The size of this disk is 2.2 TB (2199023255552 bytes).
DOS
partition table format can not be used on drives for volumes
larger
than 2.2 TB (2199023255040 bytes). Use parted(1) and GUID
partition
table format (GPT).
Warning:
invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
Command
(m for help): n
Command
action
e
extended
p
primary partition (1-4)
p
Partition
number (1-4): 1
First
cylinder (1-267349, default 1):
Using
default value 1
Last
cylinder or +size or +sizeM or +sizeK (1-267349, default 267349):
Using
default value 267349
Command
(m for help): w
The
partition table has been altered!
Calling
ioctl() to re-read partition table.
Syncing
disks.
[root@oms-db01
~]# fdisk -l
Disk
/dev/sda: 322.1 GB, 322122547200 bytes
255
heads, 63 sectors/track, 39162 cylinders
Units =
cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks
Id System
/dev/sda1 *
1 13 104391
83 Linux
/dev/sda2 14 39162
314464342+ 8e Linux LVM
WARNING:
The size of this disk is 2.2 TB (2199023255552 bytes).
DOS
partition table format can not be used on drives for volumes
larger
than 2.2 TB (2199023255040 bytes). Use parted(1) and GUID
partition
table format (GPT).
Disk
/dev/sdb: 2199.0 GB, 2199023255552 bytes
255 heads,
63 sectors/track, 267349 cylinders
Units =
cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks
Id System
/dev/sdb1
1 267349 2147480811
83 Linux
[root@oms-db01
/]# mkfs.ext3 /dev/sdb1
mke2fs
1.39 (29-May-2006)
Filesystem
label=
OS type:
Linux
Block
size=4096 (log=2)
Fragment
size=4096 (log=2)
268435456
inodes, 536870202 blocks
26843510
blocks (5.00%) reserved for the super user
First
data block=0
Maximum
filesystem blocks=4294967296
16384
block groups
32768
blocks per group, 32768 fragments per group
16384
inodes per group
Superblock
backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200,
884736, 1605632, 2654208,
4096000, 7962624, 11239424, 20480000, 23887872,
71663616, 78675968,
102400000, 214990848, 512000000
Writing
inode tables: done
Creating
journal (32768 blocks): done
Writing
superblocks and filesystem accounting information:
done
This
filesystem will be automatically checked every 35 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.
2、 创建目录挂载磁盘
[root@oms-db01 /]# mkdir oradata
[root@oms-db01 /]# chown -R oracle:oisntall oradata/
[root@oms-db01 /]# mount /dev/sdb1 oradata/
[root@oms-db01 /]# df -h
文件系统 容量 已用 可用 已用% 挂载点
/dev/mapper/VolGroup00-LogVol00
274G 166G
94G 64% /
/dev/sda1 99M 13M
81M 14% /boot
tmpfs 7.9G 0
7.9G 0% /dev/shm
/dev/sdb1
2.0T 199M 1.9T 1% /oradata
二、修改归档模式及归档日志路径
1、 修改数据库归档日志文件路径
alter system set log_archive_dest_1='location=/oradata/omsdb/archivelog';
2、 重启数据库至MOUNT状态
Shutdown immediate
Startup mount
3、 修改数据库为归档模式
Alter database archivelog
4、 打开数据库
Alter database open
三、修改数据文件路径
1、 将表空间offline
alter tablespace oms_data offline;
2、 CP数据文件到指定目录
cp /u01/app/oracle/oradata/omsdb/oms_data01.dbf
/oradata/omsdb/datafiles/oms_data01.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data02.dbf
/oradata/omsdb/datafiles/oms_data02.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data03.dbf
/oradata/omsdb/datafiles/oms_data03.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data04.dbf
/oradata/omsdb/datafiles/oms_data04.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data05.dbf
/oradata/omsdb/datafiles/oms_data05.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data06.dbf
/oradata/omsdb/datafiles/oms_data06.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data07.dbf
/oradata/omsdb/datafiles/oms_data07.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data08.dbf
/oradata/omsdb/datafiles/oms_data08.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data09.dbf
/oradata/omsdb/datafiles/oms_data09.dbf
cp /u01/app/oracle/oradata/omsdb/oms_data10.dbf
/oradata/omsdb/datafiles/oms_data10.dbf
3、 修改表空间数据文件指向
alter database rename file
'/u01/app/oracle/oradata/omsdb/oms_data01.dbf' to '/oradata/omsdb/datafiles/oms_data01.dbf';
alter database rename file
'/u01/app/oracle/oradata/omsdb/oms_data02.dbf' to
'/oradata/omsdb/datafiles/oms_data02.dbf';
alter database rename file
'/u01/app/oracle/oradata/omsdb/oms_data03.dbf' to '/oradata/omsdb/datafiles/oms_data03.dbf';
alter database rename file
'/u01/app/oracle/oradata/omsdb/oms_data04.dbf' to
'/oradata/omsdb/datafiles/oms_data04.dbf';
alter database rename file
'/u01/app/oracle/oradata/omsdb/oms_data05.dbf' to
'/oradata/omsdb/datafiles/oms_data05.dbf';
alter database rename file
'/u01/app/oracle/oradata/omsdb/oms_data06.dbf' to
'/oradata/omsdb/datafiles/oms_data06.dbf';
alter database rename file
'/u01/app/oracle/oradata/omsdb/oms_data07.dbf' to
'/oradata/omsdb/datafiles/oms_data07.dbf';
alter database rename file
'/u01/app/oracle/oradata/omsdb/oms_data08.dbf' to
'/oradata/omsdb/datafiles/oms_data08.dbf';
alter database rename file
'/u01/app/oracle/oradata/omsdb/oms_data09.dbf' to
'/oradata/omsdb/datafiles/oms_data09.dbf';
alter database rename file '/u01/app/oracle/oradata/omsdb/oms_data10.dbf'
to '/oradata/omsdb/datafiles/oms_data10.dbf';
4、将表空间online
Alter tablespace oms_data online
四、备份数据库
Rman备份全库
五、将OMS_LOGINFOR表转换成分区表
1、创建OMS_LOGINFOR_1分区表,以REQUESTINCOMETIME字段每天分区
2、将OMS_LOGINFOR表数据写入到OMS_LOGINFOR_1
Insert into OMS_LOGINFOR_1 select * from OMS_LOGINFOR;
3、删除OMS_LOGINFOR表,再将OMS_LOGINFOR_1表重命名为OMS_LOGINFOR
Drop table OMS_LOGINFOR;
Alter table OMS_LOGINFOR_1 rename to OMS_LOGINFOR;
-- Create table
createtable OMS_LOGINFOR
(
autoid NUMBERnotnull,
requestid VARCHAR2(200),
customerno VARCHAR2(64),
systemcode VARCHAR2(64),
interfacecodeto VARCHAR2(64),
type VARCHAR2(20),
content CLOB,
creator VARCHAR2(20),
createtime DATE,
interfacecodefor VARCHAR2(64),
modular VARCHAR2(20),
requestincometime TIMESTAMP(9),
responseouttime TIMESTAMP(9),
orlrequestdata CLOB,
conversionrequest CLOB,
orlresponsedata CLOB,
conversionresponse CLOB
)
partitionbyrange (REQUESTINCOMETIME)
interval (numtoyMinterval (1,' DAY '))
(
partition
p_2017_03_01 valueslessthan (to_date('2017-03-01', 'yyyy-mm-dd'))
)
tablespace OMS_DATA
pctfree10
initrans1
maxtrans255
storage
(
initial64K
next8K
minextents1
maxextentsunlimited
);
-- Add comments to the table
commentontable OMS_LOGINFOR
is'日志信息表';
-- Add comments to the columns
commentoncolumn OMS_LOGINFOR.autoid
is'序列自增长';
commentoncolumn
OMS_LOGINFOR.requestid
is'一次请求开始到请求结束,ID唯一';
commentoncolumn OMS_LOGINFOR.customerno
is'客户编号';
commentoncolumn
OMS_LOGINFOR.systemcode
is'系统编号';
commentoncolumn
OMS_LOGINFOR.interfacecodeto
is'接口编号';
commentoncolumn OMS_LOGINFOR.type
is'日志类型';
commentoncolumn
OMS_LOGINFOR.content
is'日志内容';
commentoncolumn
OMS_LOGINFOR.creator
is'创建人';
commentoncolumn
OMS_LOGINFOR.createtime
is'日志产生时间';
commentoncolumn
OMS_LOGINFOR.interfacecodefor
is'目标接口编号';
commentoncolumn
OMS_LOGINFOR.modular
is'日志产生的模块';
commentoncolumn OMS_LOGINFOR.requestincometime
is'请求进入时间';
commentoncolumn
OMS_LOGINFOR.responseouttime
is'请求返回时间';
commentoncolumn
OMS_LOGINFOR.orlrequestdata
is'原始请求数据';
commentoncolumn
OMS_LOGINFOR.conversionrequest
is'oms转换后请求数据';
commentoncolumn OMS_LOGINFOR.orlresponsedata
is'原始返回数据';
commentoncolumn
OMS_LOGINFOR.conversionresponse
is'oms转换后返回数据';
-- Create/Recreate indexes
createbitmapindex IDX_OMS_LOG on OMS_LOGINFOR
(INTERFACECODEFOR)
tablespace OMS_DATA
pctfree10
initrans2
maxtrans255
storage
(
initial64K
next1M
minextents1
maxextentsunlimited
);
createindex IDX_OMS_REQTIME on OMS_LOGINFOR
(REQUESTINCOMETIME)
tablespace OMS_DATA
pctfree10
initrans2
maxtrans255
storage
(
initial64K
next1M
minextents1
maxextentsunlimited
);
-- Create/Recreate primary, unique and foreign key
constraints
altertable OMS_LOGINFOR
addconstraint PK_AUTOID primarykey (AUTOID)
usingindex
tablespace OMS_DATA
pctfree10
initrans2
maxtrans255
storage
(
initial64K
next1M
minextents1
maxextentsunlimited
);
六、调整REDO日志组文件大小
1、增加日志组:
alter database add logfile group 4 '/oradata/omsdb/onlinelog/redo04.log'
size 1024M;
alter database add logfile group 5 '/oradata/omsdb/onlinelog/redo05.log'
size 1024M;
alter database add logfile group 6 '/oradata/omsdb/onlinelog/redo06.log'
size 1024M;
alter database add logfile group 1 '/oradata/omsdb/onlinelog/redo01.log'
size 1024M;
alter database add logfile group 2 '/oradata/omsdb/onlinelog/redo02.log'
size 1024M;
alter database add logfile group 3 '/oradata/omsdb/onlinelog/redo03.log'
size 1024M;
4、 删除日志组:
切换日志状态:
Alter system switch logfile;
Alter system checkpoint;
删除日志:
Alter database drop logfile group 1;
Alter database drop logfile group 2;
Alter database drop logfile group 3;
5、 删除日志文件
Rm /u01/app/oracle/oradata/omsdb/redo01.log
Rm /u01/app/oracle/oradata/omsdb/redo02.log
Rm /u01/app/oracle/oradata/omsdb/redo03.log
最新文章
- java学习第一天 回顾以前
- linux系统网址
- Ubuntu 手工挂载硬盘
- 关于vue.js中条件渲染的练习
- shell脚本专题之-----------全自动编译安装mysql
- 2016年末闲谈iOS开发的未来
- Angular.JS
- C++中不同数据类型的互相转换
- Casperjs/PhantomJs 中文网站截图乱码
- Python系统调用——运行其他程序
- bzoj3393 [Usaco2009 Jan]Laserphones 激光通讯
- SM4密码算法(附源码)
- Linux常用命令之-删除文件
- RestTemplate的使用介绍汇总
- 【LeetCode算法-20】Valid Parentheses
- Ubuntu 14.04 LTS 初装成
- Feign快速入门
- IO密集型 计算密集型
- centos在图形界面和命令行之间切换的快捷键是什么?
- 零基础学习python_easygui(35课)
热门文章
- 一行JS搞定快速关机
- Random-数组
- _CrtDumpMemoryLeaks()的作用 检测内存泄漏
- Java文件操作系列[3]——使用jacob操作word文档
- 非常实用的Linux 系统监控工具
- Selenium私房菜系列7 -- 玩转Selenium Server
- sqlserver中drop、truncate和delete语句的用法
- COGS 930. [河南省队2012] 找第k小的数
- mongo ServerSelectionTimeoutError: localhost:27017: [Errno 111] Connection refused
- 讲课笔记1——meta标签、表格标签