ch18.htm

Teach yourself Oracle8 in 21 day

<P><A NAME="10"></A><A HREF="10.htm"><B>Figure 18.10.</B></A><B></B></P>
<P><I>The Default Admin/Propagator/Receiver screen of the Setup wizard.</I></P>

<DL>
	<DD><B>4. </B>If a propagator already exists, you will be prompted for a password
	(see Figure 18.11). By default you will be prompted for the password for the default
	propagator DBSNMP. If you don't know the password, try <TT>DBSNMP</TT>.
</DL>

<P><A NAME="11"></A><A HREF="11.htm"><B>Figure 18.11.</B></A><B></B></P>
<P><I>The Existing Propagator's Password screen of the Setup wizard.</I></P>

<DL>
	<DD><B>5. </B>In the New Replicated Object Schema screen, shown in Figure 18.12,
	you can choose to create a new schema to hold replicated objects. It is not necessary
	to choose any schemas at this point but this is a convenient place to do it.<BR>
	<B></B>

	<P><B>6. </B>The next screen schedules the time for replication and a replication
	interval. You can leave the default to replicate once per day or change it, as shown
	in Figure 18.13.
</DL>



<BLOCKQUOTE>
	<P>
<HR>
<FONT COLOR="#000077"><B>NOTE:</B></FONT><B> </B>The values entered here represent
	the username and password of the account that does the replication. This account
	will be created by the Setup wizard. 
<HR>


</BLOCKQUOTE>

<P><A NAME="13"></A><A HREF="13.htm"><B>Figure 18.13.</B></A><B></B></P>
<P><I>The Defaults for Scheduled Links screen of the Setup wizard.</I></P>

<DL>
	<DD><B>7. </B>The next screen, which resembles the one shown in Figure 18.13, allows
	you to schedule default purging. The purge schedule lets you ordain what time the
	deferred transaction queues are purged.<BR>
	<B></B>

	<P><B>8. </B>The Master Site Customizations screen, shown in Figure 18.14, allows
	you to customize the master site as desired. Select a site and click the Customize
	button to modify users, the using clause, and so on.
</DL>

<P><A NAME="14"></A><A HREF="14.htm"><B>Figure 18.14.</B></A><B></B></P>
<P><I>The Master Site Customizations screen of the Setup wizard.</I></P>

<DL>
	<DD><B>9.</B> The Finish screen, shown in Figure 18.15, consists of an option to
	record the actions to be taken to a PL/SQL script. Enabling this option is a good
	idea if you want to be able to re-create these actions in the future.
</DL>

<P><A NAME="15"></A><A HREF="15.htm"><B>Figure 18.15.</B></A><B></B></P>
<P><I>The Finish screen of the Setup wizard.</I></P>

<DL>
	<DD><B>10. </B>After you complete the Finish screen, you will be presented with a
	summary of the actions to be taken in the Setup Wizard Finish screen. If everything
	looks fine, click OK; the master setup will commence (see Figure 18.16).
</DL>

<P><A NAME="16"></A><A HREF="16.htm"><B>Figure 18.16.</B></A><B></B></P>
<P><I>The Setup Wizard Finish screen of the Setup wizard.</I></P>
<P><FONT COLOR="#000077"><B>Configuring the Snapshot Site</B> </FONT></P>

<P>Configuring the snapshot site is similar to configuring the master site. The Setup
wizard leads you through a series of screens to help you set up the snapshot site
correctly:

<DL>
	<DD><B>1. </B>First you'll see the Master Site Selection screen, where you select
	the site that will be the master for this snapshot site and provide the <TT>SYSTEM</TT>
	password.<BR>
	<B></B>

	<P><B>2. </B>After you have selected the master site, the Setup wizard connects to
	it to obtain information it needs for the configuration and to validate the connection.<BR>
	<B></B>

	<P><B>3. </B>Select the snapshot site via the Select Snapshot Sites screen, which
	resembles the Select Master Sites screen shown in Figure 18.8. From here you select
	one or more snapshot sites.<BR>
	<B></B>

	<P><B>4. </B>Clicking the New button invokes the New Snapshot Site screen, where
	you enter the site name and the <TT>SYSTEM</TT> password (see Figure 18.17).
</DL>

<P><A NAME="17"></A><A HREF="17.htm"><B>Figure 18.17.</B></A><B></B></P>
<P><I>The New Snapshot Site screen of the Setup wizard.</I></P>

<DL>
	<DD><B>5. </B>After you select the master and the snapshot site, you must set up
	the propagator and the replication administrator. This is done in the Snapshot Site
	Defaults screen, shown in Figure 18.18. The defaults usually work very well.
</DL>

<P><A NAME="18"></A><A HREF="18.htm"><B>Figure 18.18.</B></A><B></B></P>
<P><I>The Snapshot Site Defaults screen of the Setup wizard.</I></P>

<DL>
	<DD><B>6.</B> You will be presented with the Defaults for Scheduled Links screen,
	which allows you to customize the update schedule just as you did in the previous
	section. Change this schedule to update at a faster or slower rate.<BR>
	<B></B>

	<P><B>7. </B>As with the master setup, you must also set the default purge schedule.
	This is done in the Default Purge Scheduling screen, which enables you to select
	an interval expression and rollback segment.<BR>
	<B></B>

	<P><B>8.</B> As with the master setup, you are given the opportunity to customize
	the snapshot site with the Snapshot Site Customizations screen, shown in Figure 18.19.
	Select a snapshot site and click the Customize button to modify users, the using
	clause, link scheduling, and the schema.<BR>
	<B></B>

	<P><B>9. </B>In the Finish screen, you have the option of running the setup or writing
	the steps to a script. If you write them to a script, you can get an idea of what
	steps are performed and you have a record of the operation.<BR>
	<B></B>

	<P><B>10.</B> After you finish the Setup wizard, you are presented with the Setup
	Wizard Finish screen (see Figure 18.20), which summarizes all the actions to be taken.
	When you are satisfied with the steps, click OK and the setup will begin.
</DL>

<P><A NAME="19"></A><A HREF="19.htm"><B>Figure 18.19.</B></A><B></B></P>
<P><I>The Snapshot Site Customizations screen of the Setup wizard.</I></P>
<P><A NAME="20"></A><A HREF="20.htm"><B>Figure 18.20.</B></A><B></B></P>
<P><I>The Setup Wizard Finish screen of the Setup wizard.</I></P>
<P>Both the master and snapshot setups offer a variety of different options. If you
don't know which options to use, click the Help button for an explanation of the
option. The online help is fairly complete and can be quite useful. <B></B></P>

<P><FONT COLOR="#000077"><B>Creating the Snapshots Using Replication Manager</B>
</FONT></P>

<P>Now that you have set up the replication master (replicated from) and replication
slave (replicated to), the final step is to set up the replication objects. To do
so, follow these steps:

<DL>
	<DD><B>1.</B> From the main screen of Replication Manager, select the master, then
	select File | Create New | Snapshot. This invokes the Snapshot wizard, where you
	can select what type of snapshot to create. I have chosen a simple snapshot, as shown
	in Figure 18.21.
</DL>

<P><A NAME="21"></A><A HREF="21.htm"><B>Figure 18.21.</B></A><B></B></P>
<P><I>The Basic Type screen of the Snapshot wizard.</I></P>


<BLOCKQUOTE>
	<P>
<HR>
<FONT COLOR="#000077"><B>NOTE:</B></FONT><B> </B>Before you can create the snapshot,
	you must create a database link from the menu where you chose the Create Snapshot
	option. This link is scheduled between the master and the slave. It is also necessary
	to create a snapshot log on the database object on the master if you intend to do
	fast updates. This can be done through Replication Manager. 
<HR>


</BLOCKQUOTE>


<DL>
	<DD><B>2. </B>After you have selected the type of snapshot, you will be asked for
	the database link. Select the database link you scheduled from the Master Link screen
	shown in Figure 18.22.
</DL>

<P><A NAME="22"></A><A HREF="22.htm"><B>Figure 18.22.</B></A><B></B></P>

<P><I>The Master Link screen of the Snapshot wizard.</I></P>

<DL>
	<DD><B>3. </B>Select the master table on which to create the snapshot by selecting
	the schema and then the table, as shown in Figure 18.23.
</DL>

<P><A NAME="23"></A><A HREF="23.htm"><B>Figure 18.23.</B></A><B></B></P>
<P><I>The Master Table screen of the Snapshot wizard.</I></P>

<DL>
	<DD><B>4. </B>You are given the option of restricting the data in the snapshot via
	a <TT>WHERE</TT> clause. You can define this <TT>WHERE</TT> clause in the Where Clause
	screen, shown in Figure 18.24.
</DL>

<P><A NAME="24"></A><A HREF="24.htm"><B>Figure 18.24.</B></A><B></B></P>
<P><I>The Where Clause screen of the Snapshot wizard.</I></P>

<DL>
	<DD><B>5.</B> Define the refresh group in the Refresh Group screen, shown in Figure
	18.25. If you do not yet have refresh groups, you can create one by clicking the
	Create New button.
</DL>

<P><A NAME="25"></A><A HREF="25.htm"><B>Figure 18.25.</B></A><B></B></P>
<P><I>The Refresh Group screen of the Snapshot wizard.</I></P>

<DL>
	<DD><B>6.</B> To create a refresh group, type the refresh group name in the Create
	Refresh Group screen, as shown in Figure 18.26.
</DL>

<P><A NAME="26"></A><A HREF="26.htm"><B>Figure 18.26.</B></A><B></B></P>
<P><I>The Create Refresh Group screen of the Snapshot wizard.</I></P>

<DL>
	<DD><B>7. </B>The Tablespace and Extent Characteristics screen, shown in Figure 18.27,
	allows you to change the tablespace and extent characteristics. Leave these at the
	default unless you have a reason to change them.
</DL>

<P><A NAME="27"></A><A HREF="27.htm"><B>Figure 18.27.</B></A><B></B></P>
<P><I>The Tablespace and Extent Characteristics screen of the Snapshot wizard.</I></P>

<DL>
	<DD><B>8.</B> You have completed all the necessary steps and have reached the Finish
	screen. As with most Oracle wizards, you must click Finish on the final screen to
	proceed with the operation.<BR>
	<B></B>