tag:blogger.com,1999:blog-25740336.post5459015541108442198..comments2023-08-24T22:26:48.675+01:00Comments on The PeopleSoft DBA Blog: Data Guard Implications of NOLOGGING operations from PeopleTools 8.48David Kurtzhttp://www.blogger.com/profile/00468908370233805717noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-25740336.post-58468001953218271362010-04-19T18:35:58.679+01:002010-04-19T18:35:58.679+01:00Hi David -
We have a Finance 9.0 running on Logic...Hi David -<br /><br />We have a Finance 9.0 running on Logical Standby database. At times we have skipped UPDATES on TAO tables to mitigate a SQL Appy stuck situtation and as approved by functional team. However we wanted to undertand the impact of this on the Application tables that load data by using these TAO tables. Users have not reported any issues , however being a pro-active DBAs we wanted to understand if this causes any bad data on the replicated site.<br /><br />Thanks<br /><br />Ankur ShahUnknownhttps://www.blogger.com/profile/08877471744000228009noreply@blogger.comtag:blogger.com,1999:blog-25740336.post-70651649727953341402009-02-11T23:00:00.000+00:002009-02-11T23:00:00.000+00:00PeopleSoft does not use collections or any user-de...PeopleSoft does not use collections or any user-defined data types when running on Oracle RDBMS. I don't think it issues any unsupported DDLs. I see no reason why you couldn't implement logical standby for a PeopleSoft system.David Kurtzhttps://www.blogger.com/profile/00924323960047469300noreply@blogger.comtag:blogger.com,1999:blog-25740336.post-85846206566142103452009-02-11T15:56:00.000+00:002009-02-11T15:56:00.000+00:00Hi, David,From Oracle documentation, Logical Stand...Hi, David,<BR/><BR/>From Oracle documentation, Logical Standby doesn't support certain data types (collections, User-defined types, etc). Does PeopleSoft use any of these types? It doesn't support certain DDLs. I am wondering if this would prevent us from implementing a logical standby for a peoplesoft database. Your comment would be greatly appreciated. Thanks!Li Li 李力https://www.blogger.com/profile/05832832505049079969noreply@blogger.comtag:blogger.com,1999:blog-25740336.post-32683720319769039912008-06-18T23:15:00.000+01:002008-06-18T23:15:00.000+01:00The NOLOGGING option at object level only applies ...The NOLOGGING option at object level only applies to certain operations. Most DML will still be logged. <BR/>In my 10g database, all but three of the NOLOGGING tables are also temporary. Redo is not generated for DML on Global Temporary tables.<BR/>FORCE LOGGING is a database wide setting, so I would expect it to apply also to these three tables.David Kurtzhttps://www.blogger.com/profile/00924323960047469300noreply@blogger.comtag:blogger.com,1999:blog-25740336.post-5311532841734700172008-06-18T16:12:00.000+01:002008-06-18T16:12:00.000+01:00Hi, David:I see some objects outside of Peoplesoft...Hi, David:<BR/><BR/>I see some objects outside of Peoplesoft product schema have NOLOGGING there in a Peoplesoft database (like some of SYS or DBSNMP tables). If I use FORCE LOGGING option, would it impact the system level operation?<BR/><BR/>Michael LiangAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-25740336.post-47640494090496202362008-04-02T04:27:00.000+01:002008-04-02T04:27:00.000+01:00I have a Peoplesoft 8.1.7 database that is being k...I have a Peoplesoft 8.1.7 database that is being kept around for legacy reasons and wanted to know if there is a way to make the database or application read-only... I tried setting the DB to Read-only only to find that PS will not run.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-25740336.post-52198326672647762292008-03-06T21:25:00.000+00:002008-03-06T21:25:00.000+00:00Apologies, I didn't phrase that very well. I mean...Apologies, I didn't phrase that very well. I meant whether you could the standby having made it the primary. You are quite right. If you only open the database read-only, you will not be able to run the PeopleSoft application.David Kurtzhttps://www.blogger.com/profile/00924323960047469300noreply@blogger.comtag:blogger.com,1999:blog-25740336.post-2924497294261795272008-03-06T19:31:00.000+00:002008-03-06T19:31:00.000+00:00Hi David,You say in one of your comments that Peop...Hi David,<BR/><BR/>You say in one of your comments that PeopleSoft CAN run on a Physical Standby. How would you go about doing that? A physical standby database can be in one of two states. 1. Open read only or 2. mounted (active recovery)<BR/><BR/>My understanding is that a PeopleSoft app needs to be able to write to the database in order to run.<BR/><BR/>Do you also happen to have any metrics on how much of a hit you take by forcing logging?<BR/><BR/>Thanks<BR/>Raji (raji at ucsc dot edu)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-25740336.post-82455546578514749302007-08-29T22:41:00.000+01:002007-08-29T22:41:00.000+01:00PeopleSoft will run on a physical standby, but you...PeopleSoft will run on a physical standby, but you must force logging, otherwise some objects in your secondary database could be corrupted. <BR/>Similarly, you can use logical standby, but unless you force logging, you may not replicate all data to the secondary database. Indexes created NOLOGGING are not going to be a problem because the DML is reapplied, but any use of INSERT /*+APPEND NOLOGGING*/ might be.David Kurtzhttps://www.blogger.com/profile/00924323960047469300noreply@blogger.comtag:blogger.com,1999:blog-25740336.post-42917566418230970662007-08-14T00:39:00.000+01:002007-08-14T00:39:00.000+01:00So..David, are you saying that the PeopleSoft appl...So..David, are you saying that the PeopleSoft applications will not run on a Logical Standby Database?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-25740336.post-9758331460614010332007-07-03T05:14:00.000+01:002007-07-03T05:14:00.000+01:00Hi David This also has implications for backups an...Hi David <BR/>This also has implications for backups and database cloning with RMAN. It would have been nice if the nologging had been an option, or was more heavily flagged.Peter McLartyhttps://www.blogger.com/profile/10001900062480216548noreply@blogger.com