SQL> create tablespace kltest
2 logging
3 datafile '/u01/11g/oradata/kldbold.dbf'
4 size 20m
5 autoextend on
6 next 50m maxsize 2048m
7 extent management local;
Tablespace created.
SQL> create user kldbold identified by kldbold default tablespace kldbold;
User created.
SQL> grant connect,resource,dba to kldbold;
Grant succeeded.
SQL> alter system set processes=2000 scope=spfile;
System altered.
重启
SQL> show parameter flash
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_flash_cache_file string
db_flash_cache_size big integer 0
db_flashback_retention_target integer 1440
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 3340451840 bytes
Fixed Size 2217952 bytes
Variable Size 1811941408 bytes
Database Buffers 1509949440 bytes
Redo Buffers 16343040 bytes
Database mounted.
SQL> alter system set db_recovery_file_dest_size=2g scope=both;
System altered.
SQL> alter system set db_recovery_file_dest='/u01/11g/flashback'
2 ;
System altered.
SQL> alter database archivelog;
Database altered.
SQL> alter database flashback on;
Database altered.
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
YES
RMAN> configure retention policy to recovery window of 1 days;
RMAN>CONFIGURE RETENTION POLICY REDUNDANCY 3;
*************************************************************************************************************************
扩容当前分区
一、首先创建一块新的分区:
fdisk /dev/hda
n
l #选择逻辑分区,如果没有,则首先创建扩展分区,然后再添加逻辑分区(硬盘:最多四个分区P-P-P-P或P-P-P-E)
6 #分区号(从5开始),/dev/hda6
t 8e #分区类型8e表示LVM分区
w #写入分区表
partprobe #重读分区表
mkfs –t ext3 /dev/hda6 #格式化
partx /dev/hda #查看当前硬盘的分区表及使用情况
二、创建PV,扩容VG,LV
pvcreate /dev/hda6
vgdisplay #查看当前已经存在的VG信息,以存在VG:VolGroup00为例
vgextend VolGroup00 /dev/hda6 #扩展VolGroup00
lvdisplay #查看已经存在的LV信息,以存在LV:LogVol01为例
lvextend –L 1G /dev/VolGroup00/LogVol01 #扩展LV
resize2fs /dev/VolGroup00/LogVol01 #执行该重设大小,对于当前正在使用的LogVol01有效
df –h #查看挂载情况,已经扩容
**********************************************************************************************************
exp kltest/kltest file=kltest.dmp owner=kltest file=kltest.dmp
imp kldbold/kldbold file=kltest.dmp fromuser=kltest touser=kldbold
alter table tmp
add constraint PK_tmp primary key ( MON, IDNO )
using index
tablespace index_stat
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
2 logging
3 datafile '/u01/11g/oradata/kldbold.dbf'
4 size 20m
5 autoextend on
6 next 50m maxsize 2048m
7 extent management local;
Tablespace created.
SQL> create user kldbold identified by kldbold default tablespace kldbold;
User created.
SQL> grant connect,resource,dba to kldbold;
Grant succeeded.
SQL> alter system set processes=2000 scope=spfile;
System altered.
重启
SQL> show parameter flash
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_flash_cache_file string
db_flash_cache_size big integer 0
db_flashback_retention_target integer 1440
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 3340451840 bytes
Fixed Size 2217952 bytes
Variable Size 1811941408 bytes
Database Buffers 1509949440 bytes
Redo Buffers 16343040 bytes
Database mounted.
SQL> alter system set db_recovery_file_dest_size=2g scope=both;
System altered.
SQL> alter system set db_recovery_file_dest='/u01/11g/flashback'
2 ;
System altered.
SQL> alter database archivelog;
Database altered.
SQL> alter database flashback on;
Database altered.
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
YES
RMAN> configure retention policy to recovery window of 1 days;
RMAN>CONFIGURE RETENTION POLICY REDUNDANCY 3;
*************************************************************************************************************************
扩容当前分区
一、首先创建一块新的分区:
fdisk /dev/hda
n
l #选择逻辑分区,如果没有,则首先创建扩展分区,然后再添加逻辑分区(硬盘:最多四个分区P-P-P-P或P-P-P-E)
6 #分区号(从5开始),/dev/hda6
t 8e #分区类型8e表示LVM分区
w #写入分区表
partprobe #重读分区表
mkfs –t ext3 /dev/hda6 #格式化
partx /dev/hda #查看当前硬盘的分区表及使用情况
二、创建PV,扩容VG,LV
pvcreate /dev/hda6
vgdisplay #查看当前已经存在的VG信息,以存在VG:VolGroup00为例
vgextend VolGroup00 /dev/hda6 #扩展VolGroup00
lvdisplay #查看已经存在的LV信息,以存在LV:LogVol01为例
lvextend –L 1G /dev/VolGroup00/LogVol01 #扩展LV
resize2fs /dev/VolGroup00/LogVol01 #执行该重设大小,对于当前正在使用的LogVol01有效
df –h #查看挂载情况,已经扩容
**********************************************************************************************************
exp kltest/kltest file=kltest.dmp owner=kltest file=kltest.dmp
imp kldbold/kldbold file=kltest.dmp fromuser=kltest touser=kldbold
alter table tmp
add constraint PK_tmp primary key ( MON, IDNO )
using index
tablespace index_stat
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);