- Replication for db on fcdfora1 dropped and database shutdown.
Also for OEM
1. turned off statis for cdfofprd
2. turned off events for cdfofprd
3. moved dg to dau35 for cdfonprd vs fcdfora1 machine
- Alerts
As per HDWDB app co-ordinator :
The following is a known problem related to the granularity (1 second)
of the DATE datatype forming part of the primary key of
CARDUPDATES table. When cdfofprd is upgraded to Oracle 9i,
then we can consider using the TIMESTAMP data type, which
has finer granularity and would eliminate this sorts of alerts
CSS-DSG Recommendation :
Consider Oracle generated sequence number as a Primary Key
And NON-UNIQUE index on DATE Column.
Projects Status
- Shut Down Activities
Online Shutdown Activities
Project | Estimate | Date |
Cleanup Calib QIE 2 tables (Matt) | Test in INT then PRD | This will be scheduled with CALIB app co-ordinator any time. |
Applications to review space | ?? | ?? |
Upgrade o/s 2.9 (Jeff S) | Some progress | need more time |
Offline Shutdown Activities
Production move complete. Need to est a rman recovery.
Once fcdfora1 & 2 are built we will test our recovery procedure.
Working on: system setup for fcdfora2 to fcdfora1 improving our dev/int env. - target mid November
MISC.
-New cdf_predator user to replace cdf_fetch to track predator activity. Needs a few execute assigned by File Catalog but user created.
-Dmitri has ordered the machine for our stream test bed. Will be on hold for 2 months then we proceed with testing again.
-Cdf Val can reside with pending datastreams testbed or move to fcdfora1 - cdfval on cdfpcb
( It is recommended to move cdfval on fcdfora1 in last cdf db mtg.. Will be discussed in details with Dennis Box
whether it is going to be instance or a schema on fcdfora1).
-Briefing scheduled for November 13 cost estimate for standby db (RJ/JS) and feasibility of Data Guard Solution.
-gigabit ethernet request for fcdfora4 to help support
disk maintenance
Richard requested the gigabit ethernet request at the cdf
operations meeting on CDF ops meeting
-Schedule CDF Taking Stock mtg - Nov 20th CDF Db Design Time slot.
Report by: CD/CSS/DSG 11/05/2003