Oracle 12c 迁移MGMTDB 到其他的磁盘组

最新推荐文章于 2022-03-17 08:40:00 发布
最新推荐文章于 2022-03-17 08:40:00 发布
阅读量591 收藏 1
点赞数 2
文章标签： 数据库

mgmtdb 是oracle12c中 负责集群信息维护的新增了一个数据库，这个数据库文件默认是放在ocrvote磁盘组上，所有当你安装12c GI 的时候你会发现oracle数据要ocr磁盘明显大了几G ,其实主要还是这个mgmtdb原因，这次迁移我就迁移到datadg里 其实最好还是单独建立dg 例如建立dg 名字为MGMTDG,这里测试的版本为12.1.0.2 ，估计到12.2的时候 GI 安装的时候mgmtdb oracle会推荐单独安装到一个磁盘组里。

这里要注意一点就是mgmtdb 是grid用户下面操作需要export  ORACLE_SID=-MGMTDB
这样可以登录进数据库
迁移重要步骤如下
1  备份数据库
2 关闭mgmt监听
3 还原spfile 到新dg
4 设置controlfile为新的dg
5 还原controlfile 到新dg 
6 backup db 到新的dg
7 switch copy
8 迁移临时文件到新dg
9 修改db_create_file_dest 为新dg
10 更新redo日志文件路径
11 查看更新集群中mgmtdb信息
12 重启验证


下面是测试主要步骤

1 查看目前存在的磁盘组


 
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576     20480    14985                0           14985              0             N  DATADG/
MOUNTED  NORMAL  N         512   4096  1048576     12288     8445             4096            2174              0             Y  OCRVOTE/
2   查看当前mgmtdb状态和配置
[root@qc1 bin]# ./srvctl status mgmtdb
Database is enabled
Instance -MGMTDB is running on node qc1
[root@qc1 bin]# ./srvctl config mgmtdb
Database unique name: _mgmtdb
Database name: 
Oracle home:
Oracle user: grid
Spfile: +OCRVOTE/_MGMTDB/PARAMETERFILE/spfile.267.882365357
Password file: 
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Type: Management
PDB name: qc_cluster
PDB service: qc_cluster
Cluster name: qc-cluster
Database instance: -MGMTDB
[root@qc1 bin]# 


3 查看mgmtdb监听
qc1[/home/grid]srvctl status mgmtlsnr
Listener MGMTLSNR is enabled
Listener MGMTLSNR is running on node(s): qc1
qc1[/home/grid]srvctl stop mgmtlsnr

4 创建临时数据库备份目录
mkdir -p /home/grid/backup_mgmtdb
先做一下数据库rman 备份
qc1[/home/grid]export ORACLE_SID=-MGMTDB
qc1[/home/grid]rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Mon Jun 15 10:03:02 2015
Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
connected to target database (not started)
RMAN> startup mount
Oracle instance started
database mounted
Total System Global Area     788529152 bytes
Fixed Size                     2929352 bytes
Variable Size                314576184 bytes
Database Buffers             465567744 bytes
Redo Buffers                   5455872 bytes

5 备份数据库

RMAN> backup database format '/home/grid/backup_mgmtdb/rman_mgmtdb_%U' tag='bk_mgmtdb_dg';


Starting backup at 2015-06-15 10:04:38
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=25 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+OCRVOTE/_MGMTDB/DATAFILE/system.257.882365057
input datafile file number=00003 name=+OCRVOTE/_MGMTDB/DATAFILE/sysaux.256.882365025
input datafile file number=00004 name=+OCRVOTE/_MGMTDB/DATAFILE/undotbs1.258.882365103
channel ORA_DISK_1: starting piece 1 at 2015-06-15 10:04:40
channel ORA_DISK_1: finished piece 1 at 2015-06-15 10:05:15
piece handle=/home/grid/backup_mgmtdb/rman_mgmtdb_01q9ht9n_1_1 tag=BK_MGMTDB_DG comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=+OCRVOTE/_MGMTDB/FD9AC0F7C36E4438E043B6A9E80A24D5/DATAFILE/system.264.882365201
input datafile file number=00006 name=+OCRVOTE/_MGMTDB/FD9AC0F7C36E4438E043B6A9E80A24D5/DATAFILE/sysaux.265.882365201
channel ORA_DISK_1: starting piece 1 at 2015-06-15 10:05:15
channel ORA_DISK_1: finished piece 1 at 2015-06-15 10:05:40
piece handle=/home/grid/backup_mgmtdb/rman_mgmtdb_02q9htar_1_1 tag=BK_MGMTDB_DG comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 2015-06-15 10:05:40
Starting Control File and SPFILE Autobackup at 2015-06-15 10:05:40
piece handle=/grid/app/12.1/dbs/c-1086639195-20150615-00 comment=NONE
Finished Control File and SPFILE Autobackup at 2015-06-15 10:05:43
6 迁移mgmtdb spfile 到新的dg datadg
RMAN>  restore spfile to "+datadg";

Starting restore at 2015-06-15 10:07:24
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: restoring SPFILE
output file name=+datadg
channel ORA_DISK_1: reading from backup piece /grid/app/12.1/dbs/c-1086639195-20150615-00
channel ORA_DISK_1: piece handle=/grid/app/12.1/dbs/c-1086639195-20150615-00 tag=TAG20150615T100540
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 2015-06-15 10:07:25
7 查看验证spfile 是否在新的dg上
qc1[/home/grid] srvctl config mgmtdb |grep Spfile
Spfile: +DATADG/_MGMTDB/PARAMETERFILE/spfile.263.882439645
qc1[/home/grid]

RMAN> shutdown immediate

database dismounted
Oracle instance shut down
8 迁移controlfile 到新的dg
grid用户下

qc1[/home/grid]echo $ORACLE_SID
-MGMTDB
qc1[/home/grid]sqlplus "/as sysdba"

SQL*Plus: Release 12.1.0.2.0 Production on Mon Jun 15 10:10:17 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area  788529152 bytes
Fixed Size                  2929352 bytes
Variable Size             314576184 bytes
Database Buffers          465567744 bytes
Redo Buffers                5455872 bytes
SQL> 
SQL> show parameter spfile
NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
spfile                               string
+DATADG/_MGMTDB/PARAMETERFILE/
spfile.263.882439645
SQL> 
SQL> show parameter contro

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
control_file_record_keep_time        integer
7
control_files                        string
+OCRVOTE/_MGMTDB/CONTROLFILE/c
urrent.259.882365147
control_management_pack_access       string
DIAGNOSTIC+TUNING
SQL> 
SQL>  alter system set control_files='+DATADG' scope=spfile ;
System altered.
SQL> 
关闭实例
SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management and Advanced Analytics options


9 rman 进行还原
qc1[/home/grid]rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Mon Jun 15 10:13:08 2015

Coyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
connected to target database (not started)
RMAN> startup nomount
Oracle instance started
Total System Global Area     788529152 bytes

Fixed Size                     2929352 bytes
Variable Size                314576184 bytes
Database Buffers             465567744 bytes
Redo Buffers                   5455872 bytes
RMAN> RESTORE CONTROLFILE FROM '+OCRVOTE/_MGMTDB/CONTROLFILE/current.259.882365147';
Starting restore at 2015-06-15 10:14:06
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=+DATADG/_MGMTDB/CONTROLFILE/current.270.882440047
Finished restore at 2015-06-15 10:14:08

10 还原之后mount db
RMAN> alter database mount;
Statement processed
released channel: ORA_DISK_1
RMAN> 
11 到这里控制文件和spfile都迁移到新的datadg上来了，下面我们将迁移数据文件到datadg
进入rman
grid 用户 export ORACLE_SID=-MGMTDB

RMAN> BACKUP AS COPY DEVICE TYPE DISK DATABASE FORMAT '+DATADG';

Starting backup at 2015-06-15 10:16:01
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=+OCRVOTE/_MGMTDB/DATAFILE/system.257.882365057
output file name=+DATADG/_MGMTDB/DATAFILE/system.276.882440163 tag=TAG20150615T101601 RECID=3 STAMP=882440175
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=+OCRVOTE/_MGMTDB/DATAFILE/sysaux.256.882365025
output file name=+DATADG/_MGMTDB/DATAFILE/sysaux.275.882440177 tag=TAG20150615T101601 RECID=4 STAMP=882440192
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=+OCRVOTE/_MGMTDB/FD9AC0F7C36E4438E043B6A9E80A24D5/DATAFILE/system.264.882365201
output file name=+DATADG/_MGMTDB/187498613A9C6285E0536302000AD902/DATAFILE/system.274.882440193 tag=TAG20150615T101601 RECID=5 STAMP=882440199
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=+OCRVOTE/_MGMTDB/FD9AC0F7C36E4438E043B6A9E80A24D5/DATAFILE/sysaux.265.882365201
output file name=+DATADG/_MGMTDB/187498613A9C6285E0536302000AD902/DATAFILE/sysaux.273.882440201 tag=TAG20150615T101601 RECID=6 STAMP=882440207
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=+OCRVOTE/_MGMTDB/DATAFILE/undotbs1.258.882365103
output file name=+DATADG/_MGMTDB/DATAFILE/undotbs1.293.882440207 tag=TAG20150615T101601 RECID=7 STAMP=882440211
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 2015-06-15 10:16:54
Starting Control File and SPFILE Autobackup at 2015-06-15 10:16:54
piece handle=/grid/app/12.1/dbs/c-1086639195-20150615-01 comment=NONE
Finished Control File and SPFILE Autobackup at 2015-06-15 10:16:57


RMAN>  SWITCH DATABASE TO COPY;

datafile 1 switched to datafile copy "+DATADG/_MGMTDB/DATAFILE/system.276.882440163"
datafile 3 switched to datafile copy "+DATADG/_MGMTDB/DATAFILE/sysaux.275.882440177"
datafile 4 switched to datafile copy "+DATADG/_MGMTDB/DATAFILE/undotbs1.293.882440207"
datafile 5 switched to datafile copy "+DATADG/_MGMTDB/187498613A9C6285E0536302000AD902/DATAFILE/system.274.882440193"
datafile 6 switched to datafile copy "+DATADG/_MGMTDB/187498613A9C6285E0536302000AD902/DATAFILE/sysaux.273.882440201"


RMAN>


12  检查文件
RMAN> report schema;

Report of database schema for database with db_unique_name _MGMTDB
List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    500      SYSTEM               ***     +DATADG/_MGMTDB/DATAFILE/system.276.882440163
3    400      SYSAUX               ***     +DATADG/_MGMTDB/DATAFILE/sysaux.275.882440177
4    55       UNDOTBS1             ***     +DATADG/_MGMTDB/DATAFILE/undotbs1.293.882440207
5    160      PDB$SEED:SYSTEM      ***     +DATADG/_MGMTDB/187498613A9C6285E0536302000AD902/DATAFILE/system.274.882440193
6    150      PDB$SEED:SYSAUX      ***     +DATADG/_MGMTDB/187498613A9C6285E0536302000AD902/DATAFILE/sysaux.273.882440201


List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    40       TEMP                 32767       +OCRVOTE/_MGMTDB/TEMPFILE/temp.263.882365191
2    40       PDB$SEED:TEMP        32767       +OCRVOTE/_MGMTDB/FD9AC0F7C36E4438E043B6A9E80A24D5/DATAFILE/pdbseed_temp012015-06-14_01-27-20-pm.dbf


13 由于临时文件rman是不会迁移，要手动迁移一下
Move Tempfile to Diskgroup MGMTDB.
RMAN> 
RMAN> run {
2> SET NEWNAME FOR TEMPFILE 1 TO '+DATADG';
3> SWITCH TEMPFILE ALL;
4>  }

executing command: SET NEWNAME
renamed tempfile 1 to +DATADG in control file

RMAN> 
14  redo日志要 重新增加（datadg）删除一下
qc1[/home/grid]export ORACLE_SID=-MGMTDB






SQL>  select lf.group#,lf.member,lg.status from v$logfile lf, v$log lg where  lf.GROUP#=lg.GROUP#  order by 1;


SQL> /


    GROUP# MEMBER                                   STATUS
---------- ---------------------------------------- --------------------------------
         1 +OCRVOTE/_MGMTDB/ONLINELOG/group_1.260.8 INACTIVE
           82365151


         2 +OCRVOTE/_MGMTDB/ONLINELOG/group_2.261.8 INACTIVE
           82365159


         3 +OCRVOTE/_MGMTDB/ONLINELOG/group_3.262.8 CURRENT
           82365173


 ALTER DATABASE ADD LOGFILE MEMBER '+DATADG' TO GROUP 1;
 ALTER DATABASE ADD LOGFILE MEMBER '+DATADG' TO GROUP 2;
 ALTER DATABASE ADD LOGFILE MEMBER '+DATADG' TO GROUP 3;
SQL> /
    GROUP# MEMBER                                                       STATUS
---------- ------------------------------------------------------------ --------------------------------
         1 +DATADG/_MGMTDB/ONLINELOG/group_1.283.882443911              CURRENT
         1 +OCRVOTE/_MGMTDB/ONLINELOG/group_1.260.882365151             CURRENT
         2 +DATADG/_MGMTDB/ONLINELOG/group_2.282.882443911              INACTIVE
         2 +OCRVOTE/_MGMTDB/ONLINELOG/group_2.261.882365159             INACTIVE
         3 +DATADG/_MGMTDB/ONLINELOG/group_3.284.882443913              INACTIVE


SQL>   ALTER DATABASE DROP LOGFILE MEMBER '+OCRVOTE/_MGMTDB/ONLINELOG/group_3.262.882365173';


Database altered.


SQL>   ALTER DATABASE DROP LOGFILE MEMBER '+OCRVOTE/_MGMTDB/ONLINELOG/group_2.261.882365159';

Database altered.
SQL>   ALTER DATABASE DROP LOGFILE MEMBER '+OCRVOTE/_MGMTDB/ONLINELOG/group_1.260.882365151';
Database altered.
SQL> 
    GROUP# MEMBER                                                       STATUS
---------- ------------------------------------------------------------ --------------------------------
         1 +DATADG/_MGMTDB/ONLINELOG/group_1.283.882443911              INACTIVE
         2 +DATADG/_MGMTDB/ONLINELOG/group_2.282.882443911              INACTIVE
         3 +DATADG/_MGMTDB/ONLINELOG/group_3.284.882443913              CURRENT
SQL> 
15 查看mtmgdb配置
qc1[/home/oracle]srvctl config mgmtdb
Database unique name: _mgmtdb
Database name: 
Oracle home:
Oracle user: grid
Spfile: +DATADG/_MGMTDB/PARAMETERFILE/spfile.263.882439645
Password file: 
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Type: Management
PDB name: qc_cluster
PDB service: qc_cluster
Cluster name: qc-cluster
Database instance: -MGMTDB


16 srvctl 重启验证
root@qc1 bin]# ./srvctl stop mgmtdb 
[root@qc1 bin]# ./srvctl start mgmtdb
[root@qc1 bin]# ./srvctl status mgmtlsnr
Listener MGMTLSNR is enabled
Listener MGMTLSNR is running on node(s): qc1
[root@qc1 bin]# ./srvctl status mgmtdb  
Database is enabled
Instance -MGMTDB is running on node qc1
[root@qc1 bin]# ./srvctl config mgmtdb
Database unique name: _mgmtdb
Database name: 
Oracle home:
Oracle user: grid
Spfile: +DATADG/_MGMTDB/PARAMETERFILE/spfile.263.882439645
Password file: 
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Type: Management
PDB name: qc_cluster
PDB service: qc_cluster
Cluster name: qc-cluster
Database instance: -MGMTDB
[root@qc1 bin]# 




来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26175573/viewspace-1699935/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26175573/viewspace-1699935/

cineibeng3950
关注
  • 2
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle数据库mgmt,Oracle 12cRAC移动MGMTDB数据库数据文件方法-Oracle
weixin_42488997的博客
04-09 850
在之前的Blog里介绍了Oracle12c RAC 中的MGMTDB的概念，参考：Oracle 12cRAC MGMTDB 说明/database/201412/359252.html而在默认情况下，MGMTDB 的数据文件是存放在OCR voting disk的磁盘组里的，为了节省OCR 磁盘组空间，我们也可以把MGMTDB 转移走。当然，这里的移动位置，也是从一个共享位置移动到另一个共享位置。...
Oracle12c 实战ASM磁盘组管理
最新发布
03-05
Oracle12c 实战ASM磁盘组管理
MGMTDB实例迁移
QM_eng Blockes
09-16 382
MGMTDB实际上就是一个SID为-MGMTDB的单节点、可插拔数据库。 因此，对MGMTDB的数据库实例迁移，实际上就是对一个单节点实例的迁移。我们常做的迁移，是从一个ASM磁盘组迁移到另一个磁盘组。以下为迁移的详细步骤： 1.检查当前的MGMTDB的状态 --查看磁盘组信息 $ asmcmd lsdg --确认当前实例所在磁盘 select dg.name group_name,cl...
oracle 12c 注销mgmt,Oracle 12c 迁移MGMTDB 到其他的磁盘组
weixin_32204241的博客
04-04 452
mgmtdb 是oracle12c中 负责集群信息维护的新增了一个数据库，这个数据库文件默认是放在ocrvote磁盘组上，所有当你安装12c GI 的时候你会发现oracle数据要ocr磁盘明显大了几G ,其实主要还是这个mgmtdb原因，这次迁移我就迁移到datadg里 其实最好还是单独建立dg 例如建立dg 名字为MGMTDG,这里测试的版本为12.1.0.2 ，估计到12.2的时候 GI 安...
12c特性解读：RAC MGMTDB资料库的转移与维护
weixin_34123613的博客
07-18 162
戴明明（Dave） Oracle ACE-A，ACOUG核心成员，宝存科技数据库方案架构师 Dave也是CSDN 认证专家，超过7年的DBA经验，擅长Oracle数据库诊断、性能调优，热衷于Oracle 技术的研究与分享。从14年开始研究基于PCIe闪存卡的数据库高可用，高性能解决方案。 编辑手记：感谢Dave授权我们转载其技术文章，他在博客时代书写...
asm MGMT库迁移
Du.的博客
03-17 426
Oracle 12.2 测试mgmtdb库迁移 Version 1.0 2017-12-19 背景说明 某项目mgmt磁盘空间不足，且mgmt磁盘组存在安全风险，因此需要测试mgmt库迁移到其他磁盘组的方法。 mgmt.库作用 所内环境说明： 序号 节点名次 型号 ip地址 浮动ip scan－ip 1 db01
Oracle12c 实战ASM(12.1) 安装配置
03-05
在安装 Oracle 12c ASM（12.1）之前，需要增加共享磁盘配置。首先，打开虚拟机配置，添加磁盘。点击下一步，选择独立、永久，下一步创建新的磁盘。立即分配空间，单个文件，大小给 5G 合适。添加两块磁盘，一块 2G，...
window oracle12c补丁Opatch
07-31
window oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c...
Oracle 11.2.0.4 迁移到Oracle 12.2.0.1
03-08
Oracle 数据库迁移是指从低版本的 Oracle 数据库迁移到高版本的 Oracle 数据库，例如从 Oracle 11g 迁移到 Oracle 12c。该过程需要按照数据库用户模式迁移的详细步骤进行，以确保数据的安全和完整性。 在 Oracle ...
Oracle 12c数据库体系结构图文详解手册
12-23
Oracle 12c数据库体系结构图文详解手册 Oracle 12c数据库体系结构图文详解手册是 Oracle 12c数据库管理系统的核心组件之一，该手册详细介绍了 Oracle 12c数据库的体系结构、实例、数据库、内存结构、后台进程、...
Oracle 12c RAC 移动MGMTDB 数据库 数据文件方法
David Dai -- Focus on Oracle
12-10 6571
注：本文谢绝转载！  在之前的Blog里介绍了Oracle12c RAC 中的MGMTDB的概念，参考： Oracle 12cRAC MGMTDB 说明http://blog.csdn.net/tianlesoftware/article/details/41804553   而在默认情况下，MGMTDB 的数据文件是存放在OCR voting disk的磁盘组里的，为了节省OCR 磁盘组空间，
Oracle 12c中的MGMTDB
weixin_33962923的博客
01-20 246
MGMTDB系列 1 MGMTDB说明 Every Oracle Standalone Cluster and Oracle Domain Services Cluster contains a Grid Infrastructure Management Repository (GIMR), or t...
Oracle12c 存储在线迁移
02-26 211
首先是做了data磁盘组所有数据迁移到data01磁盘组中，因为data盘是第一个数据盘组所以 controlfile、spfile和密码文件都在data磁盘组中，所以这些也是要迁移的。 ...
Oracle 12C RAC数据迁移
weixin_33862993的博客
09-14 219
源端：12C RAC primay backup file目标端：12C 单实例部分总结：1 pfile修改2 disable redo thread N3 drop logfile group N4 rename logfile5 取消log 远程传输如果primary 处于maximum availablity mode，控制文件会侦测log_archive_dest_...
oracle数据库mgmt,19c rac数据库如何添加mgmt
weixin_36075067的博客
04-09 1116
19c rac数据库安装时候不再强制安装mgmt，ps：在rac安装界面组件叫做gimr，勾选了以后自动安装mgmt，那么如何快速添加mgmt呢？官方给出了简便的方法，利用mdbutil.pl脚本快速添加mgmt，参见文档Note: 2065175.1添加过程如下，确保已经添加好mgmt所需的asm磁盘组，19c中磁盘组至少要27G。[grid@rac1 soft]$ ./mdbutil.pl -...
oracle 12c 18c 19c,Oracle 12c、18c、19c中的MGMTDB、GIMR 是什么？
weixin_34619335的博客
04-04 821
Oracle 12c、18c、19c中的MGMTDB、GIMR 是什么？2020-09-09 14:40:13MGMTDB 这是12c Grid Infrastructure 的新功能：管理资料库的 FAQ 文档。在Oracle 12.1.0.1的Grid Infrastructure 的安装中，可以选择是否安装Grid Infrastructure ManagementMGMTDB 这是12c ...
12c 中 MGMTDB说明
changyanmanman的专栏
12-11 3534
1、说明：在Oracle 12.1.0.1的Grid Infrastructure 的安装中，可以选择是否安装Grid Infrastructure Management Repository (GIMR) 数据库。在Grid Infrastructure 12.1.0.2 中，已经没有改选项，MIMR 数据库已经变成了强制选项。在Oracle 12c 中Management Database 用
Oracle 12c RAC MGMTDB 说明
热门推荐
David Dai -- Focus on Oracle
12-08 1万+
注：本文谢绝转载。 1  MGMTDB 说明 在Oracle 12.1.0.1的Grid Infrastructure 的安装中，可以选择是否安装Grid Infrastructure Management Repository (GIMR) 数据库：MGMTDB. 如下图：   在Grid Infrastructure 12.1.0.2
Oracle 12c和18c中的MGMTDB(下)
测试0901-1
09-18 1万+
Oracle 12c和18c中的MGMTDB(下) 上一篇参考： htt...
linux搭建oracle ogg 12c迁移19c
03-31
1. 安装Oracle 19c 首先，需要安装Oracle 19c数据库，安装过程可以参考官方文档或者其他相关的教程。 2. 安装Oracle GoldenGate 12c 在Oracle 19c数据库所在的...至此，Oracle GoldenGate 12c的迁移工作已经完成。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值