📄 oracle基本操作-16.htm
字号:
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">⑧、在beijing数据库scott用户下插入初始化数据</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">SQL>insert into dept values (dept_no.nextval,'sales','chicago');</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">SQL>insert into dept values (dept_no.nextval,'operations','boston');</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">SQL>commit;</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">6、创建要复制的组scott_mg，加入数据库对象，产生对象的复制支持</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD
class=a14><font color="#FFFFFF">①、用repadmin身份登录shenzhen数据库，创建主复制组scott_mg</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">SQL> execute dbms_repcat.create_master_repgroup('scott_mg');</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">说明：scott_mg组名可以根据用户的需求自由命名。</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">②、在复制组scott_mg里加入数据库对象</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">SQL>execute dbms_repcat.create_master_repobject(sname=>'scott',oname=>'dept',
type=>'table',use_existing_object=>true,gname=>'scott_mg');</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">参数说明：</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">sname 实现数据库复制的用户名称</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">oname 实现数据库复制的数据库对象名称</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">(表名长度在27个字节内，程序包名长度在24个字节内)</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">type 实现数据库复制的数据库对象类别</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">(支持的类别：表，索引，同义词，触发器，视图，过程，函数，程序包，程序包体)</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">use_existing_object true表示用主复制节点已经存在的数据库对象</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">gname 主复制组名</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">③、对数据库对象产生复制支持</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">SQL>execute dbms_repcat.generate_replication_support('scott','dept','table');</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">(说明：产生支持scott用户下dept表复制的数据库触发器和程序包)</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">④、确认复制的组和对象已经加入数据库的数据字典</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">SQL>select gname, master, status
from dba_repgroup; </font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">SQL>select * from dba_repobject;</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">7、创建主复制节点</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">①、用repadmin身份登录shenzhen数据库，创建主复制节点</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">SQL>execute dbms_repcat.add_master_database
</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD
class=a14><font color="#FFFFFF">(gname=>'scott_mg',master=>'beijing.test.com.cn',use_existing_objects=>true,
copy_rows=>false, propagation_mode => 'asynchronous');</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">参数说明：</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">gname 主复制组名</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">master 加入主复制节点的另一个数据库</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">use_existing_object true表示用主复制节点已经存在的数据库对象</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">copy_rows false表示第一次开始复制时不用和主复制节点保持一致</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">propagation_mode 异步地执行</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">②、确认复制的任务队列已经加入数据库的数据字典</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">SQL>select * from user_jobs;</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">8、使同步组的状态由停顿(quiesced )改为正常(normal)</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">①、用repadmin身份登录shenzhen数据库，运行以下命令</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">SQL> execute dbms_repcat.resume_master_activity('scott_mg',false);</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">②、确认同步组的状态为正常(normal)</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">SQL> select gname, master, status
from dba_repgroup;</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD
class=a14><font color="#FFFFFF">③、如果这个①命令不能使同步组的状态为正常(normal)，可能有一些停顿的复制，运行以下命令再试试(建议在紧急的时候才用)：</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">SQL> execute dbms_repcat.resume_master_activity('scott_mg',true);</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">9、创建复制数据库的时间表，我们假设用固定的时间表：10分钟复制一次。</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">①、用repadmin身份登录shenzhen数据库，运行以下命令</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">SQL>begin</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">dbms_defer_sys.schedule_push (</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">destination => 'beijing.test.com.cn',</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">interval => 'sysdate + 10/1440',</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">next_date => sysdate);</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">end;</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">/</font></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=620 align=center>
<TBODY>
<TR>
<TD class=a14><font color="#FFFFFF">⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -