<!-- Title: 07:59:22  Fri Apr 20 2001 -->
<!-- Crewchief: nstanfield -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>


<!-- Date: Fri Apr 20 08:00:14 2001 -->
<pre>ERROR in dump log cdfonprd . . exporting table                      RUNLABELS          1 rows exported 
. . exporting table                        RUNSETS 
EXP-00002: error in writing to export file 
EXP-00002: error in writing to export file 
EXP-00000: Export terminated unsuccessfully 
 
The exports for the cdfonprd instance have grown past 
the assigned space on disk. *see below 
 
Can we go ahead and assign an 18G named  /backup1 
on b0dau35 -  My understanding is that backups/exports are 
not mirrored so it will only take 1 disk. 
 
In addition we should go ahead and assign 
another 18G to rman backups named /backup2 allowing 
more then 1 rman on disk.  **see below for present rman 
size we only maintain 1 on disk. 
 
Reminder:  at the db mtg we also mentioned 1 18G for 
additional calib data and 1 18G for additional calib indexes. 
My understanding is these are mirrored and we use up 4 
disks.   (dbs22 & dbs23) 
 
In summary, of the new 8 18G disks we are assigning 6.   Right?! 
This will require changes in the tape backup(s) which are done 
daily? 
 
Thanks 
-Nelly 
 
P.S.  The backup disks get  priority over the calib disks -- 
I will change the cron job for the exports / backups once the 
new disks are assigned. 
 
The cdfonint rman on dau36 also failed due to space so we need 
to assign another disk there as well. 
 
 
 
 
*/dev/vx/dsk/oradg/exportvol 
                     3145728 3145728       0   100%    /dbs21 
 
-rw-r--r--   1 oracle   dba      3219301376 Apr 20 00:25 
exp_cdfonprd_full_Thu.dmp 
 
**/dev/vx/dsk/oradg/backupvol 
                     17531904 9913877 7142096    59%    /backup0 
 
-rw-r--r--   1 oracle   dba            0 Apr  2 16:16 TimeStamp 
-rw-r-----   1 oracle   dba      2146451968 Apr 20 00:47 
CDFONPRD_t427509328_s756_p1 
-rw-r-----   1 oracle   dba      1320755712 Apr 20 00:54 
CDFONPRD_t427509328_s756_p2 
-rw-r-----   1 oracle   dba      21258240 Apr 20 00:54 snap_cdfonprd.ctl 
-rw-r-----   1 oracle   dba      2146451968 Apr 20 01:06 
CDFONPRD_t427510479_s757_p1 
-rw-r-----   1 oracle   dba      1415225856 Apr 20 01:15 
CDFONPRD_t427510479_s757_p2 
-rw-r-----   1 oracle   dba      249840128 Apr 20 01:19 
CDFONPRD_t427511733_s758_p1 
-rw-r-----   1 oracle   dba      711303680 Apr 20 01:26 
CDFONPRD_t427511979_s759_p1 
-rw-r-----   1 oracle   dba      1888207360 Apr 20 01:38 
CDFONPRD_t427512394_s760_p1 
-rw-r-----   1 oracle   dba      246366720 Apr 20 01:41 
CDFONPRD_t427513110_s761_p1 
 
 
 
</pre>
<!-- Author: nstanfield -->

<!-- Date: Fri Apr 20 09:54:17 2001 -->
<pre>
Target Name : cdfonprd.fnal.gov
Target Type : Database
Node Name : b0dau35.fnal.gov

Multiple Extents
Segment {SYS.SOURCE$} in tablespace SYSTEM is comprised of 147 extents. Segment CALIB_PRD.PPRQIE in tablespace CALIB_DATA is comprised of 76 extents. Segment CALIB_PRD.CESQIE in tablespace CALIB_DATA is comprised of 126 extents. Segment CALIB_PRD.WHAQIE in tablespace CALIB_DATA is comprised of 503 extents. Segment CALIB_PRD.PEMQIE in tablespace CALIB_DATA is comprised of 881 extents. Segment CALIB_PRD.PHAQIE in tablespace CALIB_DATA is comprised of 813 extents. Segment CALIB_PRD.PESCALIB in tablespace CALIB_DATA is comprised of 71 extents. Segment CALIB_PRD.CEMQIE in tablespace CALIB_DATA is comprised of 1125 extents. Segment CALIB_PRD.CHAQIE in tablespa...
CRITICAL
Apr 20 2001 09:51:46 AM
</pre>
<!-- Author: oem-admin (email) -->



<!-- Date: Fri Apr 20 15:42:40 2001 -->
<pre> 
alter tablespace on cdfonprd 
 
this drive is 99% full 
took 300M away from one of the datafiles other datafiles 
for calib are on /dbs20  
 
/dev/vx/dsk/oradg/calibindvol 
                     4706304 4610321   89990    99%    /dbs15 
</pre>
<!-- Author: nstanfield -->


<!-- Date: Fri Apr 20 16:03:13 2001 -->
<pre>Reviewed role assignments for calib application with Jack C. 
 
Have created scripts with grants & revokes and have 
run against cdfonprd & cdfonint.    
 
No changes to cdfondev.   
 
Will revoke calib_write from the calib offline user's 
once we sent them email.  Will also remove calib_data/calib_index tables from all 3 cdf of instances 
once email is sent (particularly to lmark)</pre>
<!-- Author: nstanfield -->

<!-- Date: Fri Apr 20 16:53:50 2001 -->
<pre>
Target Name : cdfonprd.fnal.gov
Target Type : Database
Node Name : b0dau35.fnal.gov

Alert
The following errors are in the ALERT file : ORA-000060: Deadlock detected. More info in file /ora1/admin/cdfonprd/udump/cdfonprd_ora_7174.trc. ORA-000060: Deadlock detected. More info in file /ora1/admin/cdfonprd/udump/cdfonprd_ora_22507.trc..
WARNING
Apr 20 2001 04:50:59 PM
</pre>
<!-- Author: oem-admin (email) -->



<!-- Date: Fri Apr 20 20:11:10 2001 -->
<pre>Ran script admin_subroles.grt which is in  
the patches area in CalibDB against all online  
instances to grant new subroles the ability to  
write to the admin tables. Otherwise, the roles  
would be useless.</pre>
<!-- Author: jcranshaw -->


<!-- Date: Sat Apr 21 21:42:50 2001 -->
<html> 
<body> 
<h3> Running Simulation on CALIB_INT since yesterday </h3> 
<p> 
<pre><font color=blue> 
CalibDBWriter -dbtype OTL -dblogin calib_int/calib@cdfonint<br> 
 -days 8 -run 94700 -period 24 -report_rate 8 >& <br> 
 simrun_8days_12.log & <br> 
</font> 
</pre> 
<br> 
</p> 
<p> 
<pre> 
<br> 
Writing 105 calibrations 
Error 604 : ORA-00604: error occurred at recursive SQL level 1 
ORA-01653: unable to extend table CALIB_INT.MLOG$_TIMESTAMP1 by 7 in tablespace MLOG_DATA 
sql: INSERT INTO TIMESTAMP (ID_VALUE,TABLENAME,TIMEV) VALUES (-42341,'CALIBRUNLISTS',987906237) 
TimeStampOTL:UpdateTimeStamp : Error  
OCI Error 
Error 604 : ORA-00604: error occurred at recursive SQL level 1 
ORA-01653: unable to extend table CALIB_INT.MLOG$_TIMESTAMP1 by 7 in tablespace MLOG_DATA 
sql: INSERT INTO TIMESTAMP (ID_VALUE,TABLENAME,TIMEV) VALUES (30153,'COTTimeDistance1',987906237) 
TimeStampOTL:UpdateTimeStamp : Error  
OCI Error 
Error 604 : ORA-00604: error occurred at recursive SQL level 1 
ORA-01653: unable to extend table CALIB_INT.MLOG$_TIMESTAMP1 by 7 in tablespace MLOG_DATA 
sql: INSERT INTO TIMESTAMP (ID_VALUE,TABLENAME,TIMEV) VALUES (-42345,'CALIBRUNLISTS',987906237) 
TimeStampOTL:UpdateTimeStamp : Error  
OCI Error 
Error 604 : ORA-00604: error occurred at recursive SQL level 1 
ORA-01653: unable to extend table CALIB_INT.MLOG$_TIMESTAMP1 by 7 in tablespace MLOG_DATA 
sql: INSERT INTO TIMESTAMP (ID_VALUE,TABLENAME,TIMEV) VALUES (30157,'COTTimeDistance1',987906237) 
TimeStampOTL:UpdateTimeStamp : Error  
OCI Error 
Error 604 : ORA-00604: error occurred at recursive SQL level 1 
ORA-01653: unable to extend table CALIB_INT.MLOG$_TIMESTAMP1 by 7 in tablespace MLOG_DATA 
sql: INSERT INTO TIMESTAMP (ID_VALUE,TABLENAME,TIMEV) VALUES (-42349,'CALIBRUNLISTS',987906237) 
TimeStampOTL:UpdateTimeStamp : Error  
OCI Error 
Error 604 : ORA-00604: error occurred at recursive SQL level 1 
ORA-01653: unable to extend table CALIB_INT.MLOG$_TIMESTAMP1 by 7 in tablespace MLOG_DATA 
sql: INSERT INTO TIMESTAMP (ID_VALUE,TABLENAME,TIMEV) VALUES (30161,'COTTimeDistance1',987906237) 
TimeStampOTL:UpdateTimeStamp : Error  
OCI Error 
Error 604 : ORA-00604: error occurred at recursive SQL level 1 
ORA-01653: unable to extend table CALIB_INT.MLOG$_TIMESTAMP1 by 7 in tablespace MLOG_DATA 
sql: INSERT INTO TIMESTAMP (ID_VALUE,TABLENAME,TIMEV) VALUES (-42353,'CALIBRUNLISTS',987906237) 
TimeStampOTL:UpdateTimeStamp : Error  
OCI Error 
Error 604 : ORA-00604: error occurred at recursive SQL level 1 
ORA-01653: unable to extend table CALIB_INT.MLOG$_TIMESTAMP1 by 7 in tablespace MLOG_DATA 
sql: INSERT INTO TIMESTAMP (ID_VALUE,TABLENAME,TIMEV) VALUES (30165,'COTTimeDistance1',987906237) 
TimeStampOTL:UpdateTimeStamp : Error  
<br> 
</pre> 
<br> 
<b><i> and finally ...</i></b> 
<pre> 
<br> 
OCI Error 
Error 604 : ORA-00604: error occurred at recursive SQL level 1 
ORA-01653: unable to extend table CALIB_INT.MLOG$_SET_RUN_MAPS1 by 7 in tablespace MLOG_DATA 
sql: INSERT INTO SET_RUN_MAPS (TSID,CID, PROCESS_NAME, JOBSET) VALUES( -43625,30789,'TEST',6197) 
OCI Error 
Error 604 : ORA-00604: error occurred at recursive SQL level 1 
ORA-01653: unable to extend table CALIB_INT.MLOG$_SET_RUN_MAPS1 by 7 in tablespace MLOG_DATA 
sql: INSERT INTO SET_RUN_MAPS (TSID,CID, PROCESS_NAME, JOBSET) VALUES( -43629,30793,'TEST',6197) 
OCI Error 
Error 604 : ORA-00604: error occurred at recursive SQL level 1 
ORA-01653: unable to extend table CALIB_INT.MLOG$_SET_RUN_MAPS1 by 7 in tablespace MLOG_DATA 
sql: INSERT INTO SET_RUN_MAPS (TSID,CID, PROCESS_NAME, JOBSET) VALUES( -43633,30797,'TEST',6197) 
OCI Error 
Error 604 : ORA-00604: error occurred at recursive SQL level 1 
ORA-01653: unable to extend table CALIB_INT.MLOG$_SET_RUN_MAPS1 by 7 in tablespace MLOG_DATA 
sql: INSERT INTO SET_RUN_MAPS (TSID,CID, PROCESS_NAME, JOBSET) VALUES( -43637,30801,'TEST',6197) 
OCI Error 
Error 604 : ORA-00604: error occurred at recursive SQL level 1 
ORA-01653: unable to extend table CALIB_INT.MLOG$_SET_RUN_MAPS1 by 7 in tablespace MLOG_DATA 
sql: INSERT INTO SET_RUN_MAPS (TSID,CID, PROCESS_NAME, JOBSET) VALUES( -43641,30805,'TEST',6197) 
OCI Error 
Error 604 : ORA-00604: error occurred at recursive SQL level 1 
ORA-01653: unable to extend table CALIB_INT.MLOG$_SET_RUN_MAPS1 by 7 in tablespace MLOG_DATA 
sql: INSERT INTO SET_RUN_MAPS (TSID,CID, PROCESS_NAME, JOBSET) VALUES( -43645,30809,'TEST',6197) 
OCI Error 
Error 604 : ORA-00604: error occurred at recursive SQL level 1 
ORA-01653: unable to extend table CALIB_INT.MLOG$_SET_RUN_MAPS1 by 7 in tablespace MLOG_DATA 
sql: INSERT INTO SET_RUN_MAPS (TSID,CID, PROCESS_NAME, JOBSET) VALUES( -43649,30813,'TEST',6197) 
OCI Error 
Failed to do query for runmap put: failure 
<br> 
</pre> 
<i><b> Core dumped ...</b></i> 
</p> 
</body> 
</html>
<!-- Author: Igor Gorelov. -->