Oracle数据库部分迁至闪存存储的实现方法(2/2)

本篇文章主要介绍了" Oracle数据库部分迁至闪存存储的实现方法"，主要涉及到方面的内容，对于Oracle感兴趣的同学可以参考一下： 环境：Oracle 11.2.0.4 RAC（2 nodes）说明：假设新增闪存挂载点是/flash（使用了第三方的集群文件系统），如果是使用Oracle的AS...

RMAN> backup as copy tablespace TBS_D_JINGYU format '/flash/oradata/jydb5/';
SQL> alter tablespace TBS_D_JINGYU offline;
RMAN> switch tablespace TBS_D_JINGYU to copy;
RMAN> recover tablespace TBS_D_JINGYU;
SQL> alter tablespace TBS_D_JINGYU online;

6 redo迁移到闪存

新增redo logfile，删除历史redo。

redo迁移到闪存的操作命令：

--新增redo logfile
alter database add logfile THREAD 1 group 11 '/flash/oradata/jydb5/redo11.log' SIZE 2147483648;
alter database add logfile THREAD 1 group 12 '/flash/oradata/jydb5/redo12.log' SIZE 2147483648;
alter database add logfile THREAD 1 group 13 '/flash/oradata/jydb5/redo13.log' SIZE 2147483648;
alter database add logfile THREAD 1 group 14 '/flash/oradata/jydb5/redo14.log' SIZE 2147483648;
alter database add logfile THREAD 1 group 15 '/flash/oradata/jydb5/redo15.log' SIZE 2147483648;
alter database add logfile THREAD 1 group 16 '/flash/oradata/jydb5/redo16.log' SIZE 2147483648;
alter database add logfile THREAD 1 group 17 '/flash/oradata/jydb5/redo17.log' SIZE 2147483648;
alter database add logfile THREAD 2 group 21 '/flash/oradata/jydb5/redo21.log' SIZE 2147483648;
alter database add logfile THREAD 2 group 22 '/flash/oradata/jydb5/redo22.log' SIZE 2147483648;
alter database add logfile THREAD 2 group 23 '/flash/oradata/jydb5/redo23.log' SIZE 2147483648;
alter database add logfile THREAD 2 group 24 '/flash/oradata/jydb5/redo24.log' SIZE 2147483648;
alter database add logfile THREAD 2 group 25 '/flash/oradata/jydb5/redo25.log' SIZE 2147483648;
alter database add logfile THREAD 2 group 26 '/flash/oradata/jydb5/redo26.log' SIZE 2147483648;
alter database add logfile THREAD 2 group 27 '/flash/oradata/jydb5/redo27.log' SIZE 2147483648;
--删除历史redo
alter database drop logfile group 31;
alter database drop logfile group 32;
alter database drop logfile group 33;
alter database drop logfile group 34;
alter database drop logfile group 35;
alter database drop logfile group 36;
alter database drop logfile group 37;
alter database drop logfile group 41;
alter database drop logfile group 42;
alter database drop logfile group 43;
alter database drop logfile group 44;
alter database drop logfile group 45;
alter database drop logfile group 46;
alter database drop logfile group 47;

7 undo迁移到闪存

undo迁移实质就是通过创建新的undo表空间，然后修改默认undo表空间的设置，最终删除历史undo表空间。

undo表空间迁移到闪存:

create undo tablespace UNDOTBS11 datafile '/flash/oradata/jydb5/undotbs101.dbf' SIZE 30G;
create undo tablespace UNDOTBS21 datafile '/flash/oradata/jydb5/undotbs201.dbf' SIZE 24G;
alter tablespace undotbs11 add datafile '/flash/oradata/jydb5/undotbs102.dbf' SIZE 30G;
alter tablespace undotbs11 add datafile '/flash/oradata/jydb5/undotbs103.dbf' SIZE 30G;
alter tablespace undotbs11 add datafile '/flash/oradata/jydb5/undotbs104.dbf' SIZE 30G;
alter tablespace undotbs11 add datafile '/flash/oradata/jydb5/undotbs105.dbf' SIZE 30G;
alter tablespace undotbs11 add datafile '/flash/oradata/jydb5/undotbs106.dbf' SIZE 31G;
alter tablespace undotbs21 add datafile '/flash/oradata/jydb5/undotbs202.dbf' SIZE 24G;
--show parameter undo
alter system set undo_tablespace=UNDOTBS11 sid = 'jydb51';
alter system set undo_tablespace=UNDOTBS21 sid = 'jydb52';
--select SEGMENT_NAME ,STATUS ,TABLESPACE_NAME from dba_rollback_segs;（确认offline）
drop tablespace undotbs1 including contents and datafiles;
drop tablespace undotbs2 including contents and datafiles;

8 备库修改参数

数据库环境中还有一个ADG备库。

针对备库，主要需要修改db_file_name_convert和log_file_name_convert参数值，增加对新目录的映射关系。

以上这篇Oracle数据库部分迁至闪存存储的实现方法就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持本站。

您可能感兴趣的文章:

• Oracle数据块实现原理深入解读
• oracle 数据库数据迁移解决方案
• Oracle中 关于数据库存储过程和存储函数的使用

以上就介绍了 Oracle数据库部分迁至闪存存储的实现方法，包括了方面的内容，希望对Oracle有兴趣的朋友有所帮助。

本文网址链接：http://www.codes51.com/article/detail_4531295_2.html