From:                              Pascal FAURE <pascal@db1.fr>

Sent:                               mercredi 17 octobre 2012 11:37

To:                                   'it-ops-achatpro@hubwoo.com'

Cc:                                   Nicolas Seret (nseret@hubwoo.com); 'sent@db1.fr'

Subject:                          RAC/ASM/Oracle health check - October 16 -> 1 file added to INDX Tablespace

 

Hi,

 

I made a check of RAC/ASM and CHUDBORG database check and the conclusion is :

-          Alert.log of CHUDBORG is OK (no risk of corruption)

-          File system fullfilness  : OK

-          CHUDBORG Backup RMAN : OK

-          ASM diskgroup and CHUDBORG tablespace free space are OK

 

 

Bellowing the report concerning disk space for ASM Disk (stability since 27 of September) :

 

NAME         TOTAL_MB    FREE_MB

---------- ---------- ----------

DGROUP1         32762      17732

DGROUP2         16378       4632

DGROUP3         32762       6932

DGROUP4         16378      11160

DGROUP5        229358        870

DGROUP6         57332       5502

DGROUP7        242670       4552

DGROUP8         53236       4664

 

 

Bellowing the report concerning disk space for CHUDBORG tablespace  :

 

                                                                                     SIZE         SIZE

                                                                         SIZE         BUSY         FREE RATE

TABLESPACE                     STATUS                                   in Kb        in Kb        in Kb    %

------------------------------ --------------------------------- ------------ ------------ ------------ ----

INDX                           ON_LINE - LOCAL - PERMANENT         77,280,256   73,192,832    4,087,424   95

SYSAUX                         ON_LINE - LOCAL - PERMANENT          3,121,152    2,132,672      988,480   69

SYSTEM                         ON_LINE - LOCAL - PERMANENT            634,880      321,600      313,280   51

TBSORG                         ON_LINE - LOCAL - PERMANENT         80,056,320   77,605,888    2,450,432   97

TOOL                           ON_LINE - LOCAL - PERMANENT            131,072        6,528      124,544    5

UNDOTBS1                       ON_LINE - LOCAL - PERMANENT          2,097,152    1,116,928      980,224   54

UNDOTBS2                       ON_LINE - LOCAL - PERMANENT          2,097,152    1,285,504      811,648   62

                                                                 ------------ ------------ ------------

sum                                                               165,417,984  155,661,952    9,756,032

 

 

There is 4,087,424 free space on INDX (99%) , it was 5,447,296 27 of September (97%) , no problem during the next two months.

 

 

File system :

 

oracle@db-node2: /u02/exports_oracle$ df -k

Filesystem            kbytes    used   avail   capacity  Mounted on

/dev/md/dsk/d100     8262869 4148647 4031594     51%    /

/devices                   0       0       0      0%    /devices

ctfs                       0       0       0      0%    /system/contract

proc                       0       0       0      0%    /proc

mnttab                     0       0       0      0%    /etc/mnttab

swap                 53538672    1328 53537344     1%    /etc/svc/volatile

objfs                      0       0       0      0%    /system/object

fd                         0       0       0      0%    /dev/fd

/dev/md/dsk/d160     8262869 4690628 3489613     58%    /var

swap                 53554408   17064 53537344     1%    /tmp

swap                 53537392      48 53537344     1%    /var/run

/dev/md/dsk/d25      152831438 127380537 23922587 85%    /u02

/dev/md/dsk/d130     16525754 8434171 7926326    52%    /u01

/dev/md/dsk/d170     4133598 2654807 1437456     65%    /export/home

 

 

/u02 is 82% . Less free space because I added logical export of CHUDBORG database every evening (in backup script) for more security

 

oracle@db-node2: /u02/exports_oracle$ ls -alt

total 109744436

-rw-r--r--   1 oracle   oinstall   68353 Oct 16 01:26 CHUDBORG.log

-rw-r-----   1 oracle   oinstall 56161611776 Oct 16 01:26 CHUDBORG.dmp

drwxrwxrwx   3 oracle   oinstall   11264 Oct 15 22:56 .

-rwxr--r--   1 oracle   oinstall     976 Jun  7 17:22 expdatapump.sh

drwxr-xr-x   7 oracle   root         512 May 31 17:11 ..

drwxr-xr-x   2 oracle   oinstall    1536 Apr 18  2011 history

 

oracle@db-node2: /u02/exports_oracle$ more CHUDBORG.log

Export: Release 10.2.0.3.0 - 64bit Production on Monday, 15 October, 2012 22:55:45

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters and Data Mining options

Starting "USRORG"."SYS_EXPORT_FULL_01":  usrorg/******** dumpfile=CHUDBORG.dmp LOGFILE=CHUDBORG.log DIRECTORY=DATA_PUMP FULL=YES

Estimate in progress using BLOCKS method...

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 64.69 GB

Processing object type DATABASE_EXPORT/TABLESPACE

Processing object type DATABASE_EXPORT/SYS_USER/USER

Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ

Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA

. . exported "USRORG"."RW_PRITEM_FLEX"                   16.72 GB 193340905 rows

. . exported "USRORG"."RW_CONTACT_INFO"                  7.626 GB 44001182 rows

. . exported "USRORG"."RW_POITEM_FLEX"                   6.897 GB 82989796 rows

. . exported "USRORG"."SYNCHRO_HIST"                         0 KB       0 rows

. . exported "USRORG"."TEMP_TBS"                             0 KB       0 rows

Master table "USRORG"."SYS_EXPORT_FULL_01" successfully loaded/unloaded

******************************************************************************

Dump file set for USRORG.SYS_EXPORT_FULL_01 is:

 

 

 

Regards,

 

 

Pascal FAURE
Consultant Oracle 

Tél : 06 07 60 08 96


Description: Description: Description: Description: cid:910CBE1D-DDA4-4962-B24C-8D5D2884BB9E

Tél : 08 20 22 00 80

Fax  04 76 63 35 37 
www.db1.fr

 

 

From: Pascal FAURE [mailto:pascal@db1.fr]
Sent: mercredi 26 septembre 2012 15:02
To: 'it-ops-achatpro@hubwoo.com'
Cc: Nicolas Seret (nseret@hubwoo.com); 'sent@db1.fr'
Subject: RAC/ASM/Oracle health check - Septembre 26 -> 1 file added to INDX Tablespace

 

Hi,

 

I made a check of RAC/ASM and CHUDBORG database check and the conclusion is :

-          Alert.log of CHUDBORG is OK (no risk of corruption)

-          File system fullfilness  : NON OK  -> I added today a new file on INDX tablespace (see below)

-          CHUDBORG Backup RMAN : OK

-          ASM diskgroup and CHUDBORG tablespace free space are OK (see below)

 

Bellowing the report concerning disk space for ASM Disk (stability since 4 of septembre) :

 

NAME         TOTAL_MB    FREE_MB

---------- ---------- ----------

DGROUP1         32762      17732

DGROUP2         16378       4632

DGROUP3         32762       6932

DGROUP4         16378      11160

DGROUP5        229358        870

DGROUP6         57332       5502

DGROUP7        242670       8650

DGROUP8         53236       4664

       

Bellowing the report concerning disk space for CHUDBORG tablespace  :

                                                                         SIZE         BUSY         FREE RATE

TABLESPACE                     STATUS                                   in Kb        in Kb        in Kb    %

------------------------------ --------------------------------- ------------ ------------ ------------ ----

INDX                           ON_LINE - LOCAL - PERMANENT         73,085,952   70,527,232    2,558,720   97

SYSAUX                         ON_LINE - LOCAL - PERMANENT          3,121,152    1,964,672    1,156,480   63

SYSTEM                         ON_LINE - LOCAL - PERMANENT            634,880      321,536      313,344   51

TBSORG                         ON_LINE - LOCAL - PERMANENT         80,056,320   75,281,408    4,774,912   95

TOOL                           ON_LINE - LOCAL - PERMANENT            131,072        6,528      124,544    5

UNDOTBS1                       ON_LINE - LOCAL - PERMANENT          2,097,152    1,199,872      897,280   58

UNDOTBS2                       ON_LINE - LOCAL - PERMANENT          2,097,152      961,920    1,135,232   46

                                                                 ------------ ------------ ------------

sum                                                               161,223,680  150,263,168   10,960,512

 

 

                                                                                     SIZE         SIZE

                                                                         SIZE         BUSY         FREE RATE

TABLESPACE                     STATUS                                   in Kb        in Kb        in Kb    %

------------------------------ --------------------------------- ------------ ------------ ------------ ----

INDX                           ON_LINE - LOCAL - PERMANENT         73,085,952   71,767,424    1,318,528   99

SYSAUX                         ON_LINE - LOCAL - PERMANENT          3,121,152    2,042,240    1,078,912   66

SYSTEM                         ON_LINE - LOCAL - PERMANENT            634,880      321,600      313,280   51

TBSORG                         ON_LINE - LOCAL - PERMANENT         80,056,320   76,542,272    3,514,048   96

TOOL                           ON_LINE - LOCAL - PERMANENT            131,072        6,528      124,544    5

UNDOTBS1                       ON_LINE - LOCAL - PERMANENT          2,097,152    1,160,960      936,192   56

UNDOTBS2                       ON_LINE - LOCAL - PERMANENT          2,097,152    1,316,224      780,928   63

                                                                 ------------ ------------ ------------

sum                                                               161,223,680  153,157,248    8,066,432

 

 

There is 1,318,528 free space on INDX (99%) , it was 2,558,720 beginning of september (97%)

 

So it is time to add a new file on INDX tabespace, on +DGROUP7 like the others files of INDX TS (8Go free on DGROUP7)

 

ALTER TABLESPACE INDX ADD DATAFILE '+DGROUP7/chudborg/indx_24.dbf' SIZE 4G AUTOEXTEND OFF;

 

Command executed today with success.

 

Bellowing the new report concerning disk space for ASM and CHUDBORG tablespace  :

                      

NAME         TOTAL_MB    FREE_MB

---------- ---------- ----------

DGROUP1         32762      17732

DGROUP2         16378       4632

DGROUP3         32762       6932

DGROUP4         16378      11160

DGROUP5        229358        870

DGROUP6         57332       5502

DGROUP7        242670       4552

DGROUP8         53236       4664                                                               SIZE         SIZE

                                                                         SIZE         BUSY         FREE RATE

TABLESPACE                     STATUS                                   in Kb        in Kb        in Kb    %

------------------------------ --------------------------------- ------------ ------------ ------------ ----

INDX                           ON_LINE - LOCAL - PERMANENT         77,280,256   71,832,960    5,447,296   93  

SYSAUX                         ON_LINE - LOCAL - PERMANENT          3,121,152    2,042,816    1,078,336   66

SYSTEM                         ON_LINE - LOCAL - PERMANENT            634,880      321,600      313,280   51

TBSORG                         ON_LINE - LOCAL - PERMANENT         80,056,320   76,542,272    3,514,048   96

TOOL                           ON_LINE - LOCAL - PERMANENT            131,072        6,528      124,544    5

UNDOTBS1                       ON_LINE - LOCAL - PERMANENT          2,097,152    1,178,368      918,784   57

UNDOTBS2                       ON_LINE - LOCAL - PERMANENT          2,097,152    1,337,728      759,424   64

                                                                 ------------ ------------ ------------

sum                                                               165,417,984  153,262,272   12,155,712

 

We can see that DGROUP7 diskgroup has now 4,5 Go of free space and INDX tablespace has 5,4 Go of free space

 

 

RMAN BACKUP :

Verifying that all datafile are backuped

 

oracle@db-node2: /u01/app/oracle/admin$ rman target / catalog rman/rman@catrman

RMAN> report need backup;

RMAN retention policy is set to redundancy 1

Report of files with less than 1 redundant backups

File #bkps Name

---- ----- -----------------------------------------------------

46   0     +DGROUP7/chudborg/indx_22.dbf

50   0     +DGROUP7/chudborg/indx_24.dbf

 

This result is normal : indx_22.dbf is not used by database since august and indx24.dbf has just been added to the dababase today and will be backuped during next full backup

 

 

Regards,

 

Pascal FAURE
Consultant Oracle 

Tél : 06 07 60 08 96


Description: Description: Description: Description: cid:image001.jpg@01CD8A8F.89C8FF60

Tél : 08 20 22 00 80

Fax  04 76 63 35 37 
www.db1.fr