OraFAQ Forum: Data Guard » Can we use DBMS_SCHEDULER Package in Data Guard ??

Home » Server Options » Data Guard » Can we use DBMS_SCHEDULER Package in Data Guard ??

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can we use DBMS_SCHEDULER Package in Data Guard ?? [message #199513]

Tue, 24 October 2006 23:09

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

Report message to a moderator

Re: Can we use DBMS_SCHEDULER Package in Data Guard ?? [message #199997 is a reply to message #199513]

Fri, 27 October 2006 06:04

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.
-

Report message to a moderator

Re: Can we use DBMS_SCHEDULER Package in Data Guard ?? [message #208171 is a reply to message #199997]

Fri, 08 December 2006 07:27

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 20 06:38:45 CDT 2025