If jobs are updating tables, how would you get the updates back to the
primary?

Are you using a physical standby, or are you using a logical standby
database? What is the primary purpose of the standby-- high availability?
Reporting?

If you are going to go down this path, I would tend to see if the jobs could
be written to access data on the standby and update tables on the primary.
In general, though, I think it is probably a bad idea to have anything other
than reporting jobs know of the existence of a standby database.

Justin Cave <[Email address protected]
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: chandra
[mailto:oracledba-ezmlmshield-x84927076.[Email address protected]
Sent: Thursday, October 07, 2004 5:01 AM
To: LazyDBA Discussion
Subject: Running jobs on Standby Databases

Hi

We have standby databases for our critical production sites.
I am exploring the ways to use the standby servers to run some of the
production jobs.
But the problem is most of the jobs do at least one update to the tables.
and i also need to ensure the latest ness of data on Standby.

When i open Standby DB in read only mode,
to my knowldge
none can update existing tables data
nor
Create any new temporary tables.

is any one of you out there Running jobs on the Standby databases
Please throw some light on my issue.

Regards
Chandra

>
>


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html







Oracle LazyDBA home page