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

2015-01-22 21:52:54 · 作者: · 浏览: 35
e: Oracle user: grid Spfile:+OCR/_MGMTDB/PARAMETERFILE/spfile.268.865977817 Password file: Domain: Start options: open Stop options:immediate Database role:PRIMARY Management policy:AUTOMATIC Type: Management PDB name: rac_scan PDB service: rac_scan Cluster name:rac-scan Database instance:-MGMTDB [grid@rac1templates]$ [grid@rac1 templates]$ exportORACLE_SID=-MGMTDB [grid@rac1 templates]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production onWed Dec 10 21:39:13 2014 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise EditionRelease 12.1.0.2.0 - 64bit Production With the Partitioning, Automatic Storage Managementand Advanced Analytics options SQL> select file_name fromdba_data_files union select member file_name from V$logfile; FILE_NAME -------------------------------------------------------------------------------- +OCR/_MGMTDB/DATAFILE/sysaux.257.865977463 +OCR/_MGMTDB/DATAFILE/system.258.865977473 +OCR/_MGMTDB/DATAFILE/undotbs1.259.865977489 +OCR/_MGMTDB/ONLINELOG/group_1.261.865977635 +OCR/_MGMTDB/ONLINELOG/group_2.262.865977635 +OCR/_MGMTDB/ONLINELOG/group_3.263.865977635 6 rows selected. SQL>

数据文件已经转移到OCR 磁盘组了。

?

?

6 启用并启动ora.crf 资源

?

在所有节点,用root用户执行:

[root@rac1 u01]# crsctl modify res ora.crf-attr ENABLED=1 -init



[root@rac1 u01]# crsctl start res ora.crf-init

CRS-2672: Attempting to start 'ora.crf' on'rac1'

CRS-2676: Start of 'ora.crf' on 'rac1'succeeded



[root@rac1 u01]# oclumon manage -get master



Master = rac1

[root@rac1 u01]#

?