使用镜像（Redhat7.0_en_x64_Oracle12.1.0.2.0）创建两个虚拟机，删除第二个虚拟机上的数据库（startup mount exclusive restrict; drop database; ）
在这个文件中增加下面3行： /etc/hosts
192.168.17.13 dg121_1
192.168.17.94 dg121_2
192.168.87.156 jia
3台机器都加，cloud control 和两台dataGuard的机器。
修改listener的配置文件，将其中的hostname改成dg121_1或dg121_2：
vi /u01/app/oracle/product/12.1.0/db_1/network/admin/listener.ora
vi /u01/app/oracle/product/12.1.0/db_1/network/admin/tnsnames.ora
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg121_2)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.scutech)
)
)
创建口令文件：
$ orapwd file=$ORACLE_HOME/dbs/orapwcdr1 password=dingjia
检查
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS TRUE TRUE FALSE FALSE FALSE FALSE 0
删除相关文件
[oracle@dg121-2 ~]$ rm $ORACLE_HOME/demo/schema/sales_history/sale1v3.dat
[oracle@dg121-2 ~]$ rm $ORACLE_HOME/QOpatch/qopiprep.bat
rm: remove write-protected regular file ‘/u01/app/oracle/product/12.1.0/db_1/QOpatch/qopiprep.bat’? y
安装 Cloud Control的 Agent，然后选择availability-> add standby database
删除相关文件
[oracle@dg121-2 ~]$ rm $ORACLE_HOME/demo/schema/sales_history/sale1v3.dat
[oracle@dg121-2 ~]$ rm $ORACLE_HOME/QOpatch/qopiprep.bat
rm: remove write-protected regular file ‘/u01/app/oracle/product/12.1.0/db_1/QOpatch/qopiprep.bat’? y
Oracle ACE，华为云 MVP，Oracle10g,12c OCM; MySQL 5.6,5.7,8.0 OCP;CCNA; EMC Certified; IBM P Certified; RHCE; SQLServer 764; DB2 Certified; TOEIC 890；获得过两次国家部级科技进步奖；发明过两项计算机专利。微信：yaoyuanace 邮箱：yaoyuanace（at）qq.com
318
