Re: Snapshot questions

Ton wrote:
> I have some questions about creating a snapshot environment
> (Oracle realease 8.17.4i Windows NT)
>
> What do I need:
>
> - Replicate Master Table A + indexen to a Remote server "Snapshot"
> - Snapshot data is READ-Only
> - Data refresh oneway every hour " FAST" and one time day "Complete"

Don't understand this requirement. FAST refreshes, that end in a successful completion mean all your replicated data is equal to the original - there's not need for a full refresh.

> I have read the oracle documentation but the steps to create this
> environment is still not clear to me
>
> Where do I employ the setup actions: On the master server, Snapshot
> server or make it no difference as long I select the right replication
> tree in the DBA studio (Snapshot Replication: Master site / Snapshot
> site)?

On both sites; OEM does not allow a site to be master and snapshot site at the same time.

> What is the right sequence of actions:
> Master site - Setup Wizard Master side will be create REPADMIN will
> be created on Master side, SNAPADMIN on Master and Snapshot site.)
>
> Master site - Create a snapshot log
> (The CREATE SNAPSHOT LOG command creates an after row trigger on the
> effected table) If the the trigger fails because the log file is not
> there anymore or not able to insert new records will this have any
> effects on the master table normal production activities)

Yes, of course. It's similar to: "if the production tables do no longer exist, will this affect production?"
>
> Snapshot site - Create Snapshot (Why is the check box always ON of :
> Enable the materialized view for query rewite event)?
Because Data Warehousing loves the option. I guess.

>
> Snapshot site - Create Refresh group ( Here I have to put in the
> resfresh information does this overide the refresh setting I already
> put in the snapshot setup?

Ehhh ... where, what? you did not describe such a step, neither is there one.
A refresh group is simply a way of organizing all snapshots you want to refresh at the same time. Reasons: e.g. data dependencies

> Will the refresh group makes use of the refresh type from the
> snapshot setup?

No. It will be used to schedule the refresh job. Each defined snapshot in the snapshot group can have either full, fast, or force refresh methods
>
> If I want to do a fast refresh every hour from 9.00 AM - 5.00 PM and
> I want also to to do one complete refresh at 10.00 PM. how do I set
> this up because I can setup a 2nd refresh group but there is only one
> refresh type in the snapshot setup?
>

Again, I don't understand the requirement, and no. The method of refreshing is part of the snapshot definition, not of the dbms_refresh package

> Where will the refresh being activated from the Master or snapshot
> site?
>
> Thanks

Snapshot site. But other jobs will run on the Master site, like purge jobs.

-- 
Regards, Frank van Bortel