Last week we pointed out an article on backing up control files. This week Alejandro Vargas calls our attention to an article on How to Recreate the Controlfile on a RAC Environment.
The Oracle optimizer team has another great 'inside the gearbox' article, this time on the 11g feature that allows you to automate sample size on statistics.
Stephen Chan (I sure seem to be typing that name a lot) has another great find: Hidden Features Revealed: Technology Inventory Utility for Apps 12.
Not backup and recovery, just recovery, which is the key step you do all that backing up for. When you need to recover, you, the DBA, are either the hero of the hour or the Monster.com new profile and resume poster. Tom Kyte has a good article on the subject today at his blog.
I would add that when you are doing a recovery you should not let yourself be rushed, no matter how much pressure is applied (usually lots). Read everything to the end and don't rush any steps. Recoveries often can be like the episode of M.A.S.H. when a U.S. bomb landed in the compound and the doctors had to disarm it using an Army manual. They read out something along the lines of: Ok, pull the green wire out...Done...Now the red wire...Ok. (Turns the page) But first....Oh *&#%@$!...and they dive into a foxhole.
So read all the way to the end of the note you are using before following the steps, and avoid that: 'but first'. My experience is that the red wire is usually RESETLOGS. Please only use that command when you are sure it is safe and needed.
PeopleSoft and JD Edwards
(Contributed to the Infogram by Anu Sachdeva)
HCM -Two-step upgrade from 8.3 to 9.0 - Upgrade Wrapper
Instead of just providing that Red Paper on how to do a two-step upgrade from 8.3 to 9.0, there is a new tool called the "Wrapper".
Here is the link on Customer Connection with the information:
Generic Solutions to be omitted from Customer Connection Solution Search
Global Customer Care, JD Edwards Enterprise One, JD Edwards World, Peoplesoft Enterprise: Beginning Friday, January 25 generic solutions will no longer appear in Solution Advisor searches on Customer Connection. This upcoming change will alter the way solution data is indexed within the application so that when a search is performed, no solution with Type = "Generic" will appear in the results. Removing generic solutions from the search index will reduce the amount of useless items that appear each time an engineer or a customer performs a search for technical solution data.
MOST RECENT APPCASTS
The latest in the JD Edwards EnterpriseOne Tools and Technology Area (10 min.)
January 22, 2008 — Live with Cliff
Eric Oss, Manager of Customer Operations from the Oracle JD Edwards implementation and hosting partner WTS and Gary Grieshaber, Sr. Director, Strategy discuss the latest JD Edwards EnterpriseOne Tools 8.97 release, the feedback they have been receiving from the marketplace and why customers should take advantage of this new release.
What are Social CRM Applications? (12 min.)
January 17, 2008 — Live with Cliff
Listen to Anthony Lye, Senior Vice President of CRM, discuss how Oracle's Social CRM Applications combine powerful enterprise applications and the latest in social networking with Web 2.0 technology to dramatically improve end user productivity.
The Benefits of Oracle's Price Management Solution (12 min.)
January 17, 2008 — Live with Cliff
David Trice, Oracle Vice President of Product Strategy presents an overview of Oracle's Price Management Solution, why Oracle has invested in that area, and why customers should care about Price Management.
PeopleSoft: For Your Upgrade and Expansion Consideration (11 min.)
January 15, 2008 — Live with Cliff
Considering an upgrade of Oracle's PeopleSoft? Listen to John Webb, Vice President Strategy for PeopleSoft Enterprise, discuss how upgrading and expanding your PeopleSoft Applications can add tremendous value and how far the Applications have come in the latest release.
UPK version 3.1 goes GA! (5 min.)
January 10, 2008 — Live with Cliff
Hear Russell Handley, Director, UPK Product Marketing, discuss the much anticipated release of UPK 3.1, and how it can benefit enterprises of all sizes, across all geographies.
Calendar of upcoming Webcasts for February:
More details available on Customer Connection > Advisor Webcasts
PeopleSoft Web Services
February 26 -12:00 noon (MST)
JD Edwards EnterpriseOne
Transportation Freight Update
January 31 - 10:00 a.m. (MST)
Using Change Assistant for Search and Deployment of JD Edwards EnterpriseOne ESUs
February 12 -10:00 a.m. (MST)
Basket and order Repricing
February 12 - 8:30 p.m. (MST) 9 a.m. (IST) on February 13
Government reporting for Equal Employment Opportunity (EEO)
February 14 - 10:00 a.m. (MST)
February 19 - 10:00 a.m. (MST)
Features of 8.11SP1 India Localization in Comparision with Legacy Products
February 19 - 8:30 p.m. (MST) 9 a.m. (IST) on February 20
Automated Receipts Processing
February 26 - 8:30 p.m. (MST) 9 a.m. (IST) on February 27
JD Edwards World
A9.1 HRM/Payroll Enhancements
February 21 - 10:00 a.m. (MST)
How to Generate Timecard Journals
February 27 - 10:00 a.m. (MST)