10-13-2013 11:33 PM
Dear All
I am working on gaining knowledge about Oracle Data Guard Agent for Veritas Cluster Server for Windows Server.
Any help from the community will be helpful for VCS version 6x
Thanks
Solved! Go to Solution.
10-15-2013 02:47 AM
There does not seem to be an agent for Windows.
10-21-2013 12:54 AM
You can write your own agent either from scratch using information from the VCS Agent Developers Guide -
or use the Process agent. It is not that difficult. Using the Process agent you would need to use the following attributes of the Process Agent:
So the 2nd two are easy, so the StartProgram is the one that is difficult. You can see what the UNIX agent does from the documentation (https://sort.symantec.com/agents/detail/4625) and actually you could download UNIX agent and reuse the code from the online. If the code is written in perl it MAY work unchanged, but dealing with files MAY need altering as Windows paths can have spaces. Even if program is written in shell, at least you can reuse or the databas commands - these are listed in the guide:
About the Oracle Data Guard agent’s online functionThe agent determines the role of the database and the type of open mode usingthe SQL commands:DATABASE_ROLE from V$DATABASEOPEN_MODE from V$DATABASEIf the role of the replicated database is PRIMARY and the open mode is MOUNT,the agent makes the database accessible for clients as follows:■ Alters the database to open mode READ WRITE.■ Creates a lock file on the local host to indicate that the resource is online.If the role of the database is PHYSICAL STANDBY, the agent assumes a site faultand reconfigures the database as follows:■ The agent first tries to demote a primary database instance by executing theaction DGDemotePri inside the remote cluster.■ Then, the agent changes the mode of the local database from PHYSICALSTANDBY to PRIMARY.The agent stops the reception of redo log information using the SQL command:ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCELThe agent changes the role of the database using the SQL command:ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY■ The agent then restarts the local database instance to make the changeseffective and creates a lock file in the local agent home directory.
10-15-2013 02:47 AM
There does not seem to be an agent for Windows.
10-15-2013 01:08 PM
I think Mariannne is right , however SORT is not always very accurate as for example, SORT does not list an Oracle Database agent for Windows , but there is an Oracle Database agent which is mentioned in the Install guide, but the install guide does not mention an Oracle Data Guard - see extract below:
High Availability Hardware Replication Agents■ Veritas Cluster Server Hardware Replication Agentfor EMC SRDFEnables VCS to manage SRDF replicated devices.■ Veritas Cluster Server Hardware Replication Agentfor EMC SRDFSTAREnables VCS to manage SRDFSTAR replicateddevices.■ Veritas Cluster Server Hardware Replication Agentfor Hitachi TrueCopyEnables VCS to manage TrueCopy replicated devices.High Availability Application Agents■ Veritas Cluster Server Application Agent forExchange 2007■ Veritas Cluster Server Database Agent for Exchange2010■ Veritas Cluster Server Application Agent forSharePoint Server 2010High Availability Database Agents■ Veritas Cluster Server Database Agent for SQLThis installs the VCS agent for both, SQL Server■ Veritas Cluster Server Database Agent for Oracle
10-16-2013 01:25 AM
I have checked the Oracle agent guides for Windows. (https://sort.symantec.com/documents )
Data Guard is not mentioned at all.
10-20-2013 09:49 PM
Thanks for the input, I also had concluded on the same from my research that Agent for Windows is not available.
So here my question is how can we cater this situation, if someone is interested in Clustering Solution HA/DR for Windows Env but want to use Oracle Data Guard and avoid licensening of VVR as they already have ODG.
Any comments ?
10-20-2013 09:50 PM
I have raised a query on Mariane comment, see if you can also contribute on it.
Thanks
10-21-2013 12:54 AM
You can write your own agent either from scratch using information from the VCS Agent Developers Guide -
or use the Process agent. It is not that difficult. Using the Process agent you would need to use the following attributes of the Process Agent:
So the 2nd two are easy, so the StartProgram is the one that is difficult. You can see what the UNIX agent does from the documentation (https://sort.symantec.com/agents/detail/4625) and actually you could download UNIX agent and reuse the code from the online. If the code is written in perl it MAY work unchanged, but dealing with files MAY need altering as Windows paths can have spaces. Even if program is written in shell, at least you can reuse or the databas commands - these are listed in the guide:
About the Oracle Data Guard agent’s online functionThe agent determines the role of the database and the type of open mode usingthe SQL commands:DATABASE_ROLE from V$DATABASEOPEN_MODE from V$DATABASEIf the role of the replicated database is PRIMARY and the open mode is MOUNT,the agent makes the database accessible for clients as follows:■ Alters the database to open mode READ WRITE.■ Creates a lock file on the local host to indicate that the resource is online.If the role of the database is PHYSICAL STANDBY, the agent assumes a site faultand reconfigures the database as follows:■ The agent first tries to demote a primary database instance by executing theaction DGDemotePri inside the remote cluster.■ Then, the agent changes the mode of the local database from PHYSICALSTANDBY to PRIMARY.The agent stops the reception of redo log information using the SQL command:ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCELThe agent changes the role of the database using the SQL command:ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY■ The agent then restarts the local database instance to make the changeseffective and creates a lock file in the local agent home directory.
10-21-2013 01:01 AM
I've just had a look at the code and it is all written in perl so would be fairly easy to port. You may want to ask your Symantec representive to ask if this could be ported as it would be very easy for Symantec to port assuming ODG works the same on Windows as it does on UNIX as all the Symantec parts are the same.
Mike