Home » Server Options » Data Guard » Can we use DBMS_SCHEDULER Package in Data Guard ??
icon8.gif  Can we use DBMS_SCHEDULER Package in Data Guard ?? [message #199513] Tue, 24 October 2006 23:09 Go to next message
vx_2004
Messages: 10
Registered: July 2006
Junior Member
I am having issues in scheduling a simple stored procedure in Standby DB, so I am wondering can we use DBMS_SCHEDULER in Stand by at all or not.

Pls advise, if you need instructions on scheduling, I will send them to you if needed.

Thanks
Re: Can we use DBMS_SCHEDULER Package in Data Guard ?? [message #199997 is a reply to message #199513] Fri, 27 October 2006 06:04 Go to previous messageGo to next message
ualual
Messages: 22
Registered: May 2005
Junior Member
if it is a physical standby, then the database is in READ-ONLY mode. It reads only the redo logs, etc

Now, if it's a logical standby, then I would bet YES.
-
Re: Can we use DBMS_SCHEDULER Package in Data Guard ?? [message #208171 is a reply to message #199997] Fri, 08 December 2006 07:27 Go to previous message
anurag078
Messages: 34
Registered: May 2006
Location: West Des Moines
Member
For a physical standby database, the database is either in managed recovery state or open(read only) state.

Any changes in database metadata(data dictionary)/data is not allowed.

So using dbms_scheduler, means you are going to make some changes in standby database's data dictionary, which is not possible on the standby database.

Previous Topic: which to startup first
Next Topic: Error in Oracle HTTP Server
Goto Forum:
  


Current Time: Sun Dec 04 20:46:26 CST 2016

Total time taken to generate the page: 0.19781 seconds