BR0970W DB alert level ERROR type CONTROL_FILE_MISSING

[former_member209962]

Hi Friedns,

We are getting warning in DB check as below.

ERROR, type: CONTROL_FILE_MISSING, object: H:\ORACLE\SID\ORIGLOGA\CNTRL\CNTRLSID.DBF

ERROR, type: CONTROL_FILE_MISSING, object: H:\ORACLE\SID\ORIGLOGB\CNTRL\CNTRLSID.DBF

ERROR, type: REDOLOG_FILE_MISSING, object: H:\ORACLE\SID\ORIGLOGA\LOG_G11M1.DBF

ERROR, type: REDOLOG_FILE_MISSING, object: H:\ORACLE\SID\ORIGLOGB\LOG_G12M1.DBF

ERROR, type: REDOLOG_FILE_MISSING, object: H:\ORACLE\SID\ORIGLOGA\LOG_G13M1.DBF

ERROR, type: REDOLOG_FILE_MISSING, object: H:\ORACLE\SID\ORIGLOGB\LOG_G14M1.DBF

When I log in to server and check i can see these file at respective locations. but db check is saying its missing we restarted the DB and system is up database is geting opened, even online backups are running fine without any warnings or error.

Kindly help us to eliminate this warnings.

Thanks

Basis

[former_member182657 · Accepted solution]

Hi Basis,

Could you check with SAP Note   1625038 - BRBACKUP 7.20 EXT fails on Windows with BR0274E

and will try to update BR*tools version with the latest available .

After that re check and confirm.

Regards,

Gaurav

[former_member209962 · Accepted solution]

Hi Gaurav,

After adding full permisssions to user sapservicesid to orilog a,b and cntrl folders issue solved.

Thanks

Basis

[former_member182657]

Oh Great !! Thanks for sharing. Kindly close the thread.

Regards,

Gaurav

[former_member182657]

Hi Basis,

Yes i just checked the location of your control files at three locations from the log provided.

BR0120I Control files
File                                                Size       Device  Type  Link
H:\ORACLE\SID\ORIGLOGA\CNTRL\CNTRLSID.DBF              0            0  NULL  NOLINK
H:\ORACLE\SID\ORIGLOGB\CNTRL\CNTRLSID.DBF              0            0  NULL  NOLINK
F:\ORACLE\SID\SAPDATA1\CNTRL\CNTRLSID.DBF       23773184            5  FILE  NOLINK

But ve a doubt and showing size 0 under location H:\ .This could be the reason here you're getting warning

Control file not mirrored

Could you share output result of SQL command

select * from v$controlfile;

to verify the sizes at these locations.

Regards,

[former_member209962]

Please find below output.

SQL> select * from v$controlfile;

STATUS
-------
NAME
------------------------------------------------

IS_ BLOCK_SIZE FILE_SIZE_BLKS
--- ---------- --------------

H:\ORACLE\SID\ORIGLOGA\CNTRL\CNTRLSID.DBF
NO       16384           1450

H:\ORACLE\EMP\ORIGLOGB\CNTRL\CNTRLSID.DBF
NO       16384           1450

STATUS
-------
NAME
------------------------------------------------

IS_ BLOCK_SIZE FILE_SIZE_BLKS
--- ---------- --------------

F:\ORACLE\SID\SAPDATA1\CNTRL\CNTRLSID.DBF
NO       16384           1450

Thanks

Basis

[former_member182657]

Hi Basis,

Thanks for sharing and after analysis of log provided i found

2   Y    E   CONTROL_FILE_MIRROR
Control file not mirrored
  3   Y    E   CONTROL_FILE_MISSING

For this i would recommend you to follow SAP doc at

Mirroring the Control File - SAP Database Guide: Oracle - SAP Library

SAP KBA   830576 - Parameter recommendations for Oracle 10g

Parameters and Alerts for Database System Check - Computing Center Management System (BC-CCM) - SAP ...

and try to change the standard mirroring of control file parameter.

Hope this will help you.

Regards,

[former_member209962]

Hi Gaurav,

Once again thanks for your reply, as i said we have controlfiles at three locations and i can see it same with orilogA & B  But in dbcheck its coming as missing.

What you have pointed out in your screen shot is check conditions for db check job you will see more conditions if you see 3 ,4, 5 etc....

Thanks

Basis

[former_member182657]

Hi,

Could you share complete log file and alert_<SID>.log file as well.Also try to check time stamp for the warnings.

Regards,

Gauav

[former_member209962]

Hi

Gauav,

Alert log has no warnings or error related to db check but please find below dbcheck log.

BR0801I BRCONNECT 7.20 (37)
BR0805I Start of BRCONNECT processing: cepqzfdd.chk 2015-01-19 07.30.21
BR0484I BRCONNECT log file: K:\oracle\SID\sapcheck\cepqzfdd.chk
BR0477I Oracle pfile C:\oracle\SID\102\database\initSID.ora created from spfile C:\oracle\SID\102\database\spfileSID.ora

BR0101I Parameters

Name                           Value

oracle_sid                     SID
oracle_home                    C:\oracle\SID\102
oracle_profile                 C:\oracle\SID\102\database\initSID.ora
sapdata_home                   K:\oracle\SID
sap_profile                    C:\oracle\SID\102\database\initSID.sap
system_info                    DRALSHARQ\SAPServiceSID DRALSHARQ Windows 6.0 Build 6002 Service Pack 2 AMD64
oracle_info                    SID 10.2.0.4.0 8192 223 1230103689 DRALSHARQ UTF8 UTF8 3467999567 &SID
sap_info                       701 SAPSR3 0002LK0003SID0011U19039684110013NetWeaver_ORA
make_info                      NTAMD64 OCI_10201_SHARE May 26 2014 721_REL
command_line                   brconnect -jid CHECK20150118073000 -u / -c -f check
br_env                         NLS_LANG=AMERICAN_AMERICA.UTF8,
                               ORACLE_HOME=C:\oracle\SID\102,
                               ORACLE_SID=SID,
                               SAPDATA_HOME=K:\oracle\SID,
                               SAPEXE=E:\usr\sap\SID\SYS\exe\uc\NTAMD64,
                               SAPSYSTEMNAME=SID,
                               TNS_ADMIN=E:\usr\sap\SID\SYS\profile\oracle
alert_log                      K:\ORACLE\SID\SAPTRACE\BACKGROUND\alert_SID.log

BR0280I BRCONNECT time stamp: 2015-01-19 07.30.22
BR0813I Schema owners found in database SID: DBSNMP, DIP, OPS$DRALSHARQ\SIDADM, OPS$DRALSHARQ\SAPSERVICESID, ORACLE_OCM, OUTLN, SAPSR3*, SYS, SYSTEM, TSMSYS

BR0118I Tablespaces and data files

Tablespace     Status     File                                               Status     Id.        Size      MaxSize     IncrSize  BlkSize      Device  Type  Link

PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_1\SR3.DATA1             ONLINE+     4  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_2\SR3.DATA2             ONLINE+     5  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_3\SR3.DATA3             ONLINE+     6  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_4\SR3.DATA4             ONLINE+     7  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_5\SR3.DATA5             ONLINE+     8  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_6\SR3.DATA6             ONLINE+     9  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_7\SR3.DATA7             ONLINE+    10  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_8\SR3.DATA8             ONLINE+    11  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_9\SR3.DATA9             ONLINE+    12  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_10\SR3.DATA10           ONLINE+    13  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_11\SR3.DATA11           ONLINE+    14  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_12\SR3.DATA12           ONLINE+    15  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_13\SR3.DATA13           ONLINE+    16  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_14\SR3.DATA14           ONLINE+    17  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_15\SR3.DATA15           ONLINE+    18  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_16\SR3.DATA16           ONLINE+    19  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_17\SR3.DATA17           ONLINE+    45  17179877376  21474836480     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_18\SR3.DATA18           ONLINE+    46  17179877376  21474836480     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_19\SR3.DATA19           ONLINE+    47  17179877376  21474836480     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_20\SR3.DATA20           ONLINE+    52  17179877376  21474836480     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_21\SR3.DATA21           ONLINE+    53  17179877376  21474836480     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_22\SR3.DATA22           ONLINE+    54  17179877376  21474836480     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_23\SR3.DATA23           ONLINE+    57  17179877376  21474836480     20971520     8192           5  FILE  NOLINK
PSAPSR3        ONLINE+    F:\ORACLE\SID\SAPDATA2\SR3_24\SR3.DATA24           ONLINE+    58  17179877376  21474836480     20971520     8192           5  FILE  NOLINK
PSAPSR3701     ONLINE+    F:\ORACLE\SID\SAPDATA3\SR3701_1\SR3701.DATA1       ONLINE+    20   2097160192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701     ONLINE+    F:\ORACLE\SID\SAPDATA3\SR3701_2\SR3701.DATA2       ONLINE+    21   2097160192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701     ONLINE+    F:\ORACLE\SID\SAPDATA3\SR3701_3\SR3701.DATA3       ONLINE+    22   2097160192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701     ONLINE+    F:\ORACLE\SID\SAPDATA3\SR3701_4\SR3701.DATA4       ONLINE+    23   2097160192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701     ONLINE+    F:\ORACLE\SID\SAPDATA3\SR3701_5\SR3701.DATA5       ONLINE+    24  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701     ONLINE+    F:\ORACLE\SID\SAPDATA3\SR3701_6\SR3701.DATA6       ONLINE+    25  10443825152  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701     ONLINE+    F:\ORACLE\SID\SAPDATA3\SR3701_7\SR3701.DATA7       ONLINE+    26  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701     ONLINE+    F:\ORACLE\SID\SAPDATA3\SR3701_8\SR3701.DATA8       ONLINE+    27   9814679552  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701     ONLINE+    F:\ORACLE\SID\SAPDATA3\SR3701_9\SR3701.DATA9       ONLINE+    28   2097160192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701     ONLINE+    F:\ORACLE\SID\SAPDATA3\SR3701_10\SR3701.DATA10     ONLINE+    29   2264932352  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701     ONLINE+    F:\ORACLE\SID\SAPDATA3\SR3701_11\SR3701.DATA11     ONLINE+    30   2097160192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701     ONLINE+    F:\ORACLE\SID\SAPDATA3\SR3701_12\SR3701.DATA12     ONLINE+    31   2222989312  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701     ONLINE+    F:\ORACLE\SID\SAPDATA3\SR3701_13\SR3701.DATA13     ONLINE+    32   2097160192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701     ONLINE+    F:\ORACLE\SID\SAPDATA3\SR3701_14\SR3701.DATA14     ONLINE+    33   1331699712  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701X    ONLINE+    F:\ORACLE\SID\SAPDATA4\SR3701X_1\SR3701X.DATA1     ONLINE+    35  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701X    ONLINE+    F:\ORACLE\SID\SAPDATA4\SR3701X_2\SR3701X.DATA2     ONLINE+    36  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701X    ONLINE+    F:\ORACLE\SID\SAPDATA4\SR3701X_3\SR3701X.DATA3     ONLINE+    37  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701X    ONLINE+    F:\ORACLE\SID\SAPDATA4\SR3701X_4\SR3701X.DATA4     ONLINE+    38  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701X    ONLINE+    F:\ORACLE\SID\SAPDATA4\SR3701X_5\SR3701X.DATA5     ONLINE+    39  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701X    ONLINE+    F:\ORACLE\SID\SAPDATA4\SR3701X_6\SR3701X.DATA6     ONLINE+    40  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701X    ONLINE+    F:\ORACLE\SID\SAPDATA4\SR3701X_7\SR3701X.DATA7     ONLINE+    41  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701X    ONLINE+    F:\ORACLE\SID\SAPDATA4\SR3701X_8\SR3701X.DATA8     ONLINE+    42  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701X    ONLINE+    F:\ORACLE\SID\SAPDATA4\SR3701X_9\SR3701X.DATA9     ONLINE+    43  10485768192  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3701X    ONLINE+    F:\ORACLE\SID\SAPDATA4\SR3701X_10\SR3701X.DATA10   ONLINE+    44  31457288192  32505856000     20971520     8192           5  FILE  NOLINK
PSAPSR3USR     ONLINE+    F:\ORACLE\SID\SAPDATA4\SR3USR_1\SR3USR.DATA1       ONLINE+    34     52436992  10485760000     20971520     8192           5  FILE  NOLINK
PSAPSR3USR     ONLINE+    F:\ORACLE\SID\SAPDATA4\SR3USR_2\SR3USR.DATA2       ONLINE+    56     52436992  10485760000     20971520     8192           5  FILE  NOLINK
PSAPTSID       ONLINE#    F:\ORACLE\SID\SAPDATA1\TSID_1\TSID.DATA2           ONLINE+    -1   1090527232  20971520000     10485760     8192           5  FILE  NOLINK
PSAPUNDO       ONLINE-    F:\ORACLE\SID\SAPDATA1\UNDO_1\UNDO.DATA1           ONLINE+     2   8388616192  10485760000     20971520     8192           5  FILE  NOLINK
SYSAUX         ONLINE+    F:\ORACLE\SID\SAPDATA1\SYSAUX_1\SYSAUX.DATA1       ONLINE+     3    440410112  10485760000     20971520     8192           5  FILE  NOLINK
SYSAUX         ONLINE+    F:\ORACLE\SID\SAPDATA1\SYSAUX_2\SYSAUX.DATA2       ONLINE+    55    440410112  10485760000     20971520     8192           5  FILE  NOLINK
SYSTEM         ONLINE+    F:\ORACLE\SID\SAPDATA1\SYSTEM_1\SYSTEM.DATA1       SYSTEM+     1   1080041472  10485760000     20971520     8192           5  FILE  NOLINK
SYSTEM         ONLINE+    F:\ORACLE\SID\SAPDATA1\SYSTEM_2\SYSTEM.DATA2       SYSTEM+    48  10485768192  20971520000     20971520     8192           5  FILE  NOLINK
SYSTEM         ONLINE+    F:\ORACLE\SID\SAPDATA1\SYSTEM_3\SYSTEM.DATA3       SYSTEM+    49   1080041472  10485760000     20971520     8192           5  FILE  NOLINK
SYSTEM         ONLINE+    F:\ORACLE\SID\SAPDATA1\SYSTEM_4\SYSTEM.DATA4       SYSTEM+    50   1080041472  10485760000     20971520     8192           5  FILE  NOLINK
SYSTEM         ONLINE+    F:\ORACLE\SID\SAPDATA1\SYSTEM_5\SYSTEM.DATA5       SYSTEM+    51   1080041472  10485760000     20971520     8192           5  FILE  NOLINK

BR0119I Redolog files

File                                          Status  Group       Size       Device  Type  Link  Thread

H:\ORACLE\SID\ORIGLOGA\LOG_G11M1.DBF          INUSE      1    52429312            0  NULL  NOLINK     1
I:\ORACLE\SID\MIRRLOGA\LOG_G11M2.DBF          INUSE      1    52429312            8  FILE  NOLINK     1
H:\ORACLE\SID\ORIGLOGB\LOG_G12M1.DBF          INUSE      2    52429312            0  NULL  NOLINK     1
I:\ORACLE\SID\MIRRLOGB\LOG_G12M2.DBF          INUSE      2    52429312            8  FILE  NOLINK     1
H:\ORACLE\SID\ORIGLOGA\LOG_G13M1.DBF          INUSE      3    52429312            0  NULL  NOLINK     1
I:\ORACLE\SID\MIRRLOGA\LOG_G13M2.DBF          INUSE      3    52429312            8  FILE  NOLINK     1
H:\ORACLE\SID\ORIGLOGB\LOG_G14M1.DBF          INUSE      4    52429312            0  NULL  NOLINK     1
I:\ORACLE\SID\MIRRLOGB\LOG_G14M2.DBF          INUSE      4    52429312            8  FILE  NOLINK     1

BR0120I Control files

File                                                Size       Device  Type  Link

H:\ORACLE\SID\ORIGLOGA\CNTRL\CNTRLSID.DBF              0            0  NULL  NOLINK
H:\ORACLE\SID\ORIGLOGB\CNTRL\CNTRLSID.DBF              0            0  NULL  NOLINK
F:\ORACLE\SID\SAPDATA1\CNTRL\CNTRLSID.DBF       23773184            5  FILE  NOLINK

BR0982I Database disk volumes

Directory / Raw disk                          Device      Total[KB]      Free[KB]    Used[%]   MaxNeed[KB]   MaxMiss[KB]

C:\oracle\SID\102                                  2     117336060      30679372      73.85             0             0
K:\oracle\SID                                     10     102399996      54030124      47.24             0             0
F:\ORACLE\SID\SAPDATA1                             5     837627900     206260588      75.38     226097152      19836564
F:\ORACLE\SID\SAPDATA2                             5     837627900     206260588      75.38     226097152      19836564
F:\ORACLE\SID\SAPDATA3                             5     837627900     206260588      75.38     226097152      19836564
F:\ORACLE\SID\SAPDATA4                             5     837627900     206260588      75.38     226097152      19836564
I:\ORACLE\SID\MIRRLOGA                             8       6143996       5880044       4.30             0             0
I:\ORACLE\SID\MIRRLOGB                             8       6143996       5880044       4.30             0             0
K:\oracle\SID\saparch                             10     102399996      54030124      47.24             0             0
K:\oracle\SID\sapbackup                           10     102399996      54030124      47.24             0             0
K:\oracle\SID\sapcheck                            10     102399996      54030124      47.24             0             0
K:\oracle\SID\sapreorg                            10     102399996      54030124      47.24             0             0
K:\oracle\SID\saptrace                            10     102399996      54030124      47.24             0             0
K:\oracle\SID\oraarch                             10     102399996      54030124      47.24             0             0

BR0280I BRCONNECT time stamp: 2015-01-19 07.30.30
BR0814I Number of tables in schema of owner SAPSR3: 77105
BR0836I Number of tables treated as info cubes for owner SAPSR3: 49
BR0814I Number of tables/partitions in schema of owner SYS: 625/171
BR0814I Number of tables/partitions in schema of owner SYSTEM: 134/27

BR0280I BRCONNECT time stamp: 2015-01-19 07.30.38
BR0815I Number of indexes in schema of owner SAPSR3: 92203
BR0815I Number of indexes/partitions in schema of owner SYS: 678/180
BR0815I Number of indexes/partitions in schema of owner SYSTEM: 175/32

BR0280I BRCONNECT time stamp: 2015-01-19 07.30.52
BR0816I Number of segments in schema of owner DBSNMP: 25
BR0816I Number of segments in schema of owner OPS$DRALSHARQ\SIDADM: 1
BR0816I Number of segments in schema of owner OUTLN: 9
BR0816I Number of segments/LOBs in schema of owner SAPSR3: 174228/2460
BR0816I Number of segments/LOBs in schema of owner SYS: 1796/87
BR0816I Number of segments/LOBs in schema of owner SYSTEM: 353/22
BR0816I Number of segments in schema of owner TSMSYS: 4

BR0280I BRCONNECT time stamp: 2015-01-19 07.30.52
BR0961I Number of conditions found in DBCHECKORA: 118

BR0983I Tablespace fragmentation

Tablespace    Files   Tables  Indexes    Extents     Total[KB]   Used[%]     Free[KB]   FreeExt.   MaxSize[KB]   MaxAlloc[KB]   Used[%]       Free[KB]       Largest[KB]

PSAPSR3          24    76767    91728     268202    298057728     93.45     19515200          8     331612160+      33554432+    84.00+      53069632+       4194304+:4194304+:4194304+:4194304+:4194304+
PSAPSR3701       14        0        0          0     60282880      0.00     60281984         22     143360000+      83077120+     0.00+     143359104+       8939520+:8192000+:8192000+:8192000+:8192000+
PSAPSR3701X      10      310      446      13719    122880000     89.01     13507072          5     123904000+       1024000+    88.27+      14531072+       4063232:4063232:3102720:2277248:1024000+
PSAPSR3USR        2       28       29        250       102400     86.06        14272          3      20480000+      20377600+     0.43+      20391872+      10188800+:10188800+:13248:960:64
PSAPTSID          1        0        0          0      1064960      0.10      1063936          0      20480000+      19415040+     0.01+      20478976+      19415040+:0:0:0:0
PSAPUNDO          1        0        0          0      8192000      0.00      8191936        569      10240000+       2048000+     0.00+      10239936+       2269184:2048000+:1360704:1076160:295936
SYSAUX            2      254      284       2447       860160     47.28       453440         57      20480000+      19619840+     1.99+      20073280+       9809920+:9809920+:396224:13248:12288
SYSTEM            5      505      569       2995     14458880      7.27     13407424          9      61440000+      46981120+     1.71+      60388544+      10240000+:9185280+:9185280+:9185280+:9185280+

Total:           59    77864    93056     287613    505899008     76.98    116435264        673     731996160      226097152     53.21      342532416       69120000:47681536:26444480:24939200:22903872

BR0280I BRCONNECT time stamp: 2015-01-19 07.30.52
BR0818I Number of tables found in DBDIFF for owner SAPSR3: 2

BR0280I BRCONNECT time stamp: 2015-01-19 07.30.53
BR0818I Number of tables found in DBSTATC for owner SAPSR3: 390

BR0962I Check conditions for database administration:

Pos. Act. Lev. Condition                         Object
Description

  1   Y    W   ARCHIVER_STUCK
Out of space in archive directory - more than 90% space used

  2   Y    E   CONTROL_FILE_MIRROR
Control file not mirrored

  3   Y    E   CONTROL_FILE_MISSING
Control file missing on disk

  4   Y    W   CRITICAL_FILE
File autoextend can cause file system overflow

  5   Y    W   CRITICAL_SEGMENT
Segment can cause tablespace overflow - by allocating up to 2 next extent(s)

  6   Y    W   CRITICAL_TABLESPACE
Tablespace files autoextend can cause file system overflow

  7   Y    E   DATA_FILE_MISMATCH
Data file marked as missing in control file

  8   Y    E   DATA_FILE_MISSING
Data file missing on disk

  9   Y    E   FILE_OFFLINE
Database file offline

10   Y    W   FILE_SYSTEM_FULL
File system full - more than 99% space used

11   Y    E   HARMFUL_STATISTICS
Table or index has harmful optimizer statistics

12   Y    E   INVALID_FILE_TYPE
Invalid operating system file type

13   Y    W   IN_WRONG_TABLESPACE
Table or index in wrong tablespace

14   Y    E   MISSING_INDEX
Table has no index

15   Y    E   MISSING_STATISTICS
Table or index has no optimizer statistics

16   Y    E   NOARCHIVELOG_MODE
Database in NOARCHIVELOG mode

17   Y    W   PCTINCREASE_NOT_ZERO
PCTINCREASE value not equal zero

18   Y    E   REDOLOG_FILE_MIRROR
Redo log file not mirrored

19   Y    E   REDOLOG_FILE_MISSING
Redo log file missing on disk

20   Y    W   TABLESPACE_FULL
Tablespace full - more than 95% space used

21   Y    W   TABLESPACE_IN_BACKUP
Tablespace in backup mode

22   Y    E   TABLESPACE_OFFLINE
Tablespace offline

23   Y    W   TOO_MANY_EXTENTS
Segment has too many extents - more than 90% of MAXEXTENTS used

BR0963I Check conditions for database operations:

Pos. Act. Lev. Condition               Description

  1   Y    W   ARCHIVE_TOO_OLD         Last successful archive log backup older than 10 days (or has not been run)
  2   Y    W   BACKUP_TOO_OLD          Last successful complete database backup older than 10 days (or has not been run)
  3   Y    W   LAST_ARCHIVE_FAILED     Last archive log backup failed
  4   Y    W   LAST_BACKUP_FAILED      Last complete database backup failed
  5   Y    W   LAST_OPERATION_FAILED   Last 'chk' operation failed
  6   N    W   LAST_OPERATION_FAILED   Last DBA operation failed
  7   Y    W   LAST_STATS_FAILED       Last update optimizer statistics failed
  8   Y    W   OPERATION_TOO_OLD       Last successful 'chk' operation older than 10 days (or has not been run)
  9   N    W   OPERATION_TOO_OLD       Last successful DBA operation older than 10 days (or has not been run)
10   Y    W   STATS_TOO_OLD           Last successful update optimizer statistics older than 10 days (or has not been run)

BR0964I Check conditions for database messages:

Pos. Act. Lev. Message                 Description

  1   Y    W   ORA-00060               Deadlock while waiting for resource
  2   Y    E   ORA-00255               Error archiving log file
  3   Y    E   ORA-00257               Archiver error
  4   Y    E   ORA-00270               Error creating archive log
  5   Y    E   ORA-00272               Error writing archive log
  6   Y    E   ORA-00376               Database file cannot be read
  7   Y    E   ORA-00447               Fatal error in background process
  8   Y    E   ORA-00470               LGWR process terminated with error
  9   Y    E   ORA-00471               DBWR process terminated with error
10   Y    E   ORA-00472               PMON process terminated with error
11   Y    E   ORA-00473               ARCH process terminated with error
12   Y    E   ORA-00474               SMON process terminated with error
13   Y    E   ORA-00600               Oracle internal error
14   Y    E   ORA-00603               Oracle server session terminated by fatal error
15   Y    E   ORA-01113               Data file needs media recovery
16   Y    E   ORA-01114               I/O error writing database file
17   Y    E   ORA-01115               I/O error reading database file
18   Y    E   ORA-01122               File verification check failed
19   Y    E   ORA-01135               Database file is offline
20   Y    W   ORA-01149               Cannot shutdown - data file in backup mode
21   Y    W   ORA-01555               Snapshot too old
22   Y    W   ORA-01562               Failed to extend rollback segment
23   Y    E   ORA-01578               Database block corrupted
24   Y    E   ORA-01628               Max. extents reached for rollback segment
25   Y    E   ORA-01629               Max. extents reached saving undo for tablespace
26   Y    E   ORA-01630               Max. extents reached in tSID segment in tablespace
27   Y    E   ORA-01631               Max. extents reached in table
28   Y    E   ORA-01632               Max. extents reached in index
29   Y    E   ORA-01650               Unable to extend rollback segment in tablespace
30   Y    E   ORA-01651               Unable to extend save undo segment for tablespace
31   Y    E   ORA-01652               Unable to extend tSID segment in tablespace
32   Y    E   ORA-01653               Unable to extend table in tablespace
33   Y    E   ORA-01654               Unable to extend index in tablespace
34   Y    E   ORA-01655               Unable to extend cluster in tablespace
35   Y    E   ORA-01656               Max. extents reached in cluster
36   Y    E   ORA-01680               Unable to extend LOB segment in tablespace
37   Y    E   ORA-01681               Max. extents reached in LOB segment in tablespace
38   Y    E   ORA-01683               Unable to extend index partition
39   Y    E   ORA-01684               Max. extents reached in table partition
40   Y    E   ORA-01685               Max. extents reached in index partition
41   Y    E   ORA-01688               Unable to extend table partition
42   Y    E   ORA-01691               Unable to extend lob segment in tablespace
43   Y    E   ORA-01692               Unable to extend lob segment partition in tablespace
44   Y    E   ORA-01693               Max. extents reached in lob segment
45   Y    E   ORA-01694               Max. extents reached in lob segment partition
46   Y    E   ORA-03113               End-of-file on communication channel
47   Y    E   ORA-07445               Exception encountered: core dump
48   Y    E   ORA-16014               Destination not available for archiving log file
49   Y    E   ORA-16038               Log file cannot be archived
50   Y    E   ORA-19502               Write error on log file
51   Y    E   ORA-19504               Failed to create log file
52   Y    E   ORA-19510               Failed to set size of blocks for file
53   Y    E   ORA-27044               Unable to write the header block of file
54   Y    E   ORA-27063               Number of bytes read/written is incorrect
55   Y    E   ORA-27072               File I/O error
56   Y    E   ORA-30036               Unable to extend segment in undo tablespace
57   Y    W   Checkpoint not complete
58   Y    E   Corrupt block

BR0965I Check conditions for database profile:

Pos. Act. Lev. Parameter                         Condition                  Value Unit

  1   Y    E   COMPATIBLE                           <>                     10.2.0
  2   Y    W   CONTROL_FILE_RECORD_KEEP_TIME        <                          30
  3   Y    E   DB_BLOCK_SIZE                        <>                       8192
  4   Y    W   DB_FILES                             <                         254
  5   Y    W   DB_FILE_MULTIBLOCK_READ_COUNT                                    
  6   Y    E   FILESYSTEMIO_OPTIONS                 <>                     SETALL
  7   Y    W   LOG_ARCHIVE_START                                                
  8   Y    W   LOG_BUFFER                           ><                   4096,512 K
  9   Y    W   LOG_CHECKPOINTS_TO_ALERT             <>                       TRUE
10   Y    W   MAX_DUMP_FILE_SIZE                   ><               100000,10000
11   Y    W   OPEN_CURSORS                         ><                   2000,800
12   Y    W   OPTIMIZER_FEATURES_ENABLE                                        
13   Y    W   OPTIMIZER_INDEX_COST_ADJ             <>                         20
14   Y    W   OPTIMIZER_MODE                                                   
15   Y    W   PARALLEL_EXECUTION_MESSAGE_SIZE      ><                 16384,4096
16   Y    W   PARALLEL_THREADS_PER_CPU             ><                        2,1
17   Y    E   QUERY_REWRITE_ENABLED                <>                      FALSE
18   Y    E   RECYCLEBIN                           <>                        OFF
19   Y    E   REMOTE_OS_AUTHENT                    <>                       TRUE
20   Y    E   REPLICATION_DEPENDENCY_TRACKING      <>                      FALSE
21   Y    W   SHARED_POOL_SIZE                     <                         400 M
22   Y    W   STAR_TRANSFORMATION_ENABLED          <>                       TRUE
23   Y    W   STATISTICS_LEVEL                                                 
24   Y    W   TIMED_STATISTICS                                                 
25   Y    W   TRACE_ENABLED                                                    
26   Y    E   UNDO_MANAGEMENT                      <>                       AUTO
27   Y    W   UNDO_TABLESPACE                      <>                   PSAPUNDO

BR0280I BRCONNECT time stamp: 2015-01-19 07.30.53
BR0807I Name of database instance: SID
BR0808I BRCONNECT action ID: cepqzfdd
BR0809I BRCONNECT function ID: chk
BR0810I BRCONNECT function: check
BR0951I Number of active/inactive check conditions for database administration: 23/0
BR0952I Number of active/inactive check conditions for database operations: 8/2
BR0953I Number of active/inactive check conditions for database messages: 58/0
BR0954I Number of active/inactive check conditions for database profile: 27/0
BR0960I Last successful BRCONNECT check run: cepqutug.chk 2015-01-18 09.50.50
BR0126I Unattended mode active - no operator confirmation required

BR0280I BRCONNECT time stamp: 2015-01-19 07.30.53
BR0969I Checking database administration...
BR0970W Database administration alert - level: ERROR, type: CONTROL_FILE_MISSING, object: H:\ORACLE\SID\ORIGLOGA\CNTRL\CNTRLSID.DBF
BR0970W Database administration alert - level: ERROR, type: CONTROL_FILE_MISSING, object: H:\ORACLE\SID\ORIGLOGB\CNTRL\CNTRLSID.DBF
BR0970W Database administration alert - level: ERROR, type: REDOLOG_FILE_MISSING, object: H:\ORACLE\SID\ORIGLOGA\LOG_G11M1.DBF
BR0970W Database administration alert - level: ERROR, type: REDOLOG_FILE_MISSING, object: H:\ORACLE\SID\ORIGLOGB\LOG_G12M1.DBF
BR0970W Database administration alert - level: ERROR, type: REDOLOG_FILE_MISSING, object: H:\ORACLE\SID\ORIGLOGA\LOG_G13M1.DBF
BR0970W Database administration alert - level: ERROR, type: REDOLOG_FILE_MISSING, object: H:\ORACLE\SID\ORIGLOGB\LOG_G14M1.DBF

BR0280I BRCONNECT time stamp: 2015-01-19 07.30.53
BR0972I Checking database operations...

BR0280I BRCONNECT time stamp: 2015-01-19 07.30.53
BR0974I Checking database messages in K:\ORACLE\SID\SAPTRACE\BACKGROUND\alert_SID.log ...

BR0280I BRCONNECT time stamp: 2015-01-19 07.30.53
BR0977I Checking database profile...
BR0978W Database profile alert - level: WARNING, parameter: MAX_DUMP_FILE_SIZE, value: UNLIMITED (>< 100000,10000)
BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_INDEX_COST_ADJ, value: 100 (<> 20)

BR0280I BRCONNECT time stamp: 2015-01-19 07.30.54
BR0980I Number of changed database profile parameters: 0

BR0280I BRCONNECT time stamp: 2015-01-19 07.30.54
BR0955I Number of signaled error/warning/exception alerts for database administration: 6/0/0
BR0956I Number of signaled error/warning/exception alerts for database operations: 0/0/0
BR0957I Number of signaled error/warning/exception alerts for database messages: 0/0/0
BR0958I Number of signaled error/warning/exception alerts for database profile: 0/2/0

BR0806I End of BRCONNECT processing: cepqzfdd.chk 2015-01-19 07.30.54
BR0280I BRCONNECT time stamp: 2015-01-19 07.30.54
BR0803I BRCONNECT completed successfully with warnings

Thanks

Basis