Using Data Guard with PeopleSoft
A question regarding the compatibility of PeopleSoft and Oracle Data Guard recently came up and I thought I'd share this with all.
Can Data Guard be used with PeopleSoft?
PeopleSoft does not use any unsupported data types for logical or physical standby databases. As of PeopleTools 8.49, PeopleSoft Enterprise only uses VARCHAR2, DATE, NUMBER, BLOB, CLOB, LONG RAW, LONG VARCHAR.
However, none of our reporting options are strictly read only and therefore we cannot use an active standby database; a customer might want to do this to set up a separate reporting database. Reports are usually run through the process scheduler, and the PS reporting tools and the scheduler update the database (think of the status updates that are made as the report is run).
BOTTOM LINE:
Customers can use Data Guard 10g to set up standby databases for failover purposes (logical or physical standby), but they can’t use Active Data Guard (11g) for reporting, as that requires opening the database read only.
