asm MGMT库迁移

Oracle 12.2

测试mgmtdb库迁移

Version 1.0

2017-12-19

背景说明

某项目mgmt磁盘空间不足，且mgmt磁盘组存在安全风险，因此需要测试mgmt库迁移到其他磁盘组的方法。

mgmt.库作用

所内环境说明：

序号	节点名次	型号	ip地址	浮动ip	scan－ip
1	db01	dell R630	10.45.10.75	10.45.10.101	10.45.10.100
2	db02	dell R630	10.45.10.81	10.45.10.102
3	db03	dell R630	10.45.10.74	10.45.10.103
4	stor01	dell R730xd	10.45.10.72

迁移过程

查看当前mgmtdb库信息

查看mgmtdb所在节点,可以看出mgmtdb在db02节点上

[root@db02 ~]# /app/grid/product/122/bin/srvctl status mgmtdb

Database is enabled

Instance -MGMTDB is running on node db02

查看mgmtdb所在节点库信息

[root@db02 ~]# /app/grid/product/122/bin/srvctl config mgmtdb

Database unique name: _mgmtdb

Database name:

Oracle home: <CRS home>

Oracle user: grid

Spfile: +MGMT/_MGMTDB/PARAMETERFILE/spfile.269.962754419

Password file:

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Type: Management

PDB name: GIMR_DSCREP_10

PDB service: GIMR_DSCREP_10

Cluster name: db-cluster

Database instance: -MGMTDB

查看库数据文件信息

su – grid

export ORACLE_SID=-MGMTD

rman target /

report schema;

开启归档模式，备份mgmtdb到本地存储，

su – grid

export ORACLE_SID=-MGMTDB

sqlplus / as sysdba

alter database archivelog;

指定归档目录

alter system set db_recovery_file_dest_size=10G;

alter　system set db_recovery_file_dest=’+TEST’;

mgmtdb库备份

备份数据文件信息到本地

backup database format ‘/app/grid/grid/backup/mgmtdb%U’;

mgmtdb库恢复参数文件

恢复spfile文件信息

export ORACLE_SID=-MGMTDB

rman target /

startup nomount;

restore spfile to ‘+TEST’;

mgmt库恢复控制文件信息

售前修改控制文件路径信息

alter system set control_files=’+TEST’ scope=spfile;

重启进入nomount模式，恢复控制文件

restore controlfile from ‘+TEST/_MGMTDB/AUTOBACKKUP/2017_12_18/S_96073933.282.963073937’;

mgmtdb库恢复数据文件

alter database mount;

backup as copy device type disk database format ‘+TEST’;

switch database to copy;

recover database ;

查看数据文件位置

调整online日志组位置

alter database add logfile group 4 ‘+TEST’;

alter database add logfile group 5  ‘+TEST’;

alter database add logfile group 6 ‘+TEST’;

删除原有日志组

alter database clear logfile group 1;

alter database clear logfile group 2;

alter database clear logfile group 3;

temp临时表空间位置切换

create temporary tablespace temp02 tempfile '+TEST' size 100M;

alter database default temporary tablespace temp02;

drop tablespace temp including contents and datafiles;