GMTDB -createAsContainerDatabasetrue -templateName MGMTSeed_Database.dbc -gdbName _mgmtdb -storageType ASM-diskGroupName <+NEW_DG> -datafileJarLocation $GRID_HOME/assistants/dbca/templates-characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck --共享的NFS/CFS ： $/bin/dbca -silent-createDatabase -templateName MGMTSeed_Database.dbc -sid -MGMTDB -gdbName_mgmtdb -storageType FS -datafileDestination -datafileJarLocation /assistants/dbca/templates -charactersetAL32UTF8 -autoGeneratePasswords -oui_internal --示例： [grid@rac1 templates]$ dbca -silent-createDatabase -sid -MGMTDB -createAsContainerDatabase true -templateNameMGMTSeed_Database.dbc -gdbName _mgmtdb -storageType ASM -diskGroupName +OCR-datafileJarLocation /u01/gridsoft/12.1.0.2/assistants/dbca/templates-characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck Registering database with Oracle GridInfrastructure 5% complete Copying database files 7% complete 9% complete 16% complete 23% complete 30% complete 41% complete Creating and starting Oracle instance 43% complete 48% complete 49% complete 50% complete 55% complete 60% complete 61% complete 64% complete Completing Database Creation 68% complete 79% complete 89% complete 100% complete Look at the log file"/u01/gridbase/cfgtoollogs/dbca/_mgmtdb/_mgmtdb0.log" for furtherdetails. [grid@rac1 templates]$

4 使用DBCA 创建PDB

[grid@rac1 templates]$ srvctl status mgmtdb

Database is enabled

Instance -MGMTDB is running on node rac1

[grid@rac1 templates]$

在任意节点，用grid用户执行dbca创建PDB，命令如下：

$ /bin/dbca -silent-createPluggableDatabase -sourceDB -MGMTDB -pdbName -createPDBFrom RMANBACKUP -PDBBackUpfile/assistants/dbca/templates/mgmtseed_pdb.dfb -PDBMetadataFile/assistants/dbca/templates/mgmtseed_pdb.xml -createAsClone true–internalSkipGIHomeCheck

--查询集群的名称：

[grid@rac1 /]$ cemutlo -n

rac-scan

[grid@rac1 /]$

注意：默认情况CLUSTER_NAME 都是-，这里比如换成_

我们这里就要换成rac_scan

[grid@rac1 templates]$ dbca -silent-createPluggableDatabase -sourceDB -MGMTDB -pdbName rac_scan -createPDBFromRMANBACKUP -PDBBackUpfile /u01/gridsoft/12.1.0.2/assistants/dbca/templates/mgmtseed_pdb.dfb-PDBMetadataFile/u01/gridsoft/12.1.0.2/assistants/dbca/templates/mgmtseed_pdb.xml-createAsClone true -internalSkipGIHomeCheck

Creating Pluggable Database

4% complete

12% complete

21% complete

38% complete

55% complete

85% complete

Completing Pluggable Database Creation

100% complete

Look at the log file"/u01/gridbase/cfgtoollogs/dbca/_mgmtdb/rac_scan/_mgmtdb0.log" forfurther details.

[grid@rac1 templates]$

5 验证MGMTDB

用grid用户执行如下命令，验证MGMTDB运行情况：

[grid@rac1 ~]$ srvctl status MGMTDB

Database is enabled

Instance -MGMTDB is running on node rac1

这里显示的是节点1，那么在节点1上在执行：

[grid@rac1 ~]$ mgmtca

[grid@rac1 ~]$ crsctl stat res -t

……

ora.MGMTLSNR

1 ONLINE ONLINE rac1 169.254.193.105 192.

168.57.5,STABLE

ora.mgmtdb

1 ONLINE ONLINE rac1 Open,STABLE

……

[grid@rac1 ~]$



[grid@rac1templates]$ srvctl config mgmtdb

Database unique name:_mgmtdb

Database name:

Oracle hom

Oracle 12cRAC移动MGMTDB数据库数据文件方法(二)

4 使用DBCA 创建PDB

5 验证MGMTDB