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;