warning alerts for database administration ?

[#1]

Detail log:	cejqydjo	.	chk
BR0801I BRCONNECT 7.00 (41)
BR0477I Oracle pfile /oracle/P01/102_64/dbs/initP01.ora created from spfile /oracle/P01/102_64/dbs/spfileP01.ora
BR0805I Start of BRCONNECT processing: cejqydjo.chk 2012-10-15 23.00.04
BR0484I BRCONNECT log file: /oracle/P01/sapcheck/cejqydjo.chk
BR0101I Parameters
Name                           Value
oracle_sid                     P01
oracle_home                    /oracle/P01/102_64
oracle_profile                 /oracle/P01/102_64/dbs/initP01.ora
sapdata_home                   /oracle/P01
sap_profile                    /oracle/P01/102_64/dbs/initP01.sap
system_info                    p01adm/orap01 MBEP01 AIX 3 5 00C585C44C00
oracle_info                    P01 10.2.0.2.0 8192 41789 253727210 MBEP01 UTF8 UTF8
sap_info                       700 SAPSR3 0002LK0003P010011Z14682207530015Maintenance_ORA
make_info                      rs6000_64 OCI_102 Apr  8 2009
command_line                   brconnect -u / -jid CHECK20121012230000 -c -f check
alert_log                      /oracle/P01/saptrace/background/alert_P01.log
BR0280I BRCONNECT time stamp: 2012-10-15 23.00.04
BR0813I Schema owners found in database P01:
DBSNMP, DIP, OPS$ORAP01, OPS$P01ADM, OPS$SAPSERVICEP01, OPS$SR3ADM, OUTLN, SAPSR3*, SAPSR3DB%, SYS,
SYSTEM, TSMSYS
BR0118I Tablespaces and data files
Tablespace     Status     File                                               Status     Id.        Size      MaxSize     IncrSize  BlkSize      Device  Type  Link
PSAPSR3        ONLINE+    /oracle/P01/sapdata1/sr3_1/sr3.data1               ONLINE+     4   2747277312  10485760000     20971520     8192     3407881  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata1/sr3_2/sr3.data2               ONLINE+     5   2621448192  10485760000     20971520     8192     3407881  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata1/sr3_3/sr3.data3               ONLINE+     6   2600476672  10485760000     20971520     8192     3407881  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata1/sr3_4/sr3.data4               ONLINE+     7   2621448192  10485760000     20971520     8192     3407881  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata1/sr3_5/sr3.data5               ONLINE+     8   2663391232  10485760000     20971520     8192     3407881  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata2/sr3_6/sr3.data6               ONLINE+     9   2726305792  10485760000     20971520     8192     3407882  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata2/sr3_7/sr3.data7               ONLINE+    10   2768248832  10485760000     20971520     8192     3407882  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata2/sr3_8/sr3.data8               ONLINE+    11   2642419712  10485760000     20971520     8192     3407882  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata2/sr3_9/sr3.data9               ONLINE+    12   2705334272  10485760000     20971520     8192     3407882  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata2/sr3_10/sr3.data10             ONLINE+    13   2684362752  10485760000     20971520     8192     3407882  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata3/sr3_11/sr3.data11             ONLINE+    14   2705334272  10485760000     20971520     8192     3407883  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata3/sr3_12/sr3.data12             ONLINE+    15   2684362752  10485760000     20971520     8192     3407883  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata3/sr3_13/sr3.data13             ONLINE+    16   2747277312  10485760000     20971520     8192     3407883  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata3/sr3_14/sr3.data14             ONLINE+    17   2936020992  10485760000     20971520     8192     3407883  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata3/sr3_15/sr3.data15             ONLINE+    18   2852134912  10485760000     20971520     8192     3407883  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata4/sr3_16/sr3.data16             ONLINE+    19   2915049472  10485760000     20971520     8192     3407884  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata4/sr3_17/sr3.data17             ONLINE+    20   2642419712  10485760000     20971520     8192     3407884  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata4/sr3_18/sr3.data18             ONLINE+    21   2747277312  10485760000     20971520     8192     3407884  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata4/sr3_19/sr3.data19             ONLINE+    22   2726305792  10485760000     20971520     8192     3407884  FILE  NOLINK
PSAPSR3        ONLINE+    /oracle/P01/sapdata4/sr3_20/sr3.data20             ONLINE+    23   2558533632  10485760000     20971520     8192     3407884  FILE  NOLINK
PSAPSR3700     ONLINE+    /oracle/P01/sapdata1/sr3700_1/sr3700.data1         ONLINE+    24   2579505152  10485760000     20971520     8192     3407881  FILE  NOLINK
PSAPSR3700     ONLINE+    /oracle/P01/sapdata1/sr3700_2/sr3700.data2         ONLINE+    25   2579505152  10485760000     20971520     8192     3407881  FILE  NOLINK
PSAPSR3700     ONLINE+    /oracle/P01/sapdata1/sr3700_3/sr3700.data3         ONLINE+    26   3040878592  10485760000     20971520     8192     3407881  FILE  NOLINK
PSAPSR3700     ONLINE+    /oracle/P01/sapdata1/sr3700_4/sr3700.data4         ONLINE+    27   2936020992  10485760000     20971520     8192     3407881  FILE  NOLINK
PSAPSR3700     ONLINE+    /oracle/P01/sapdata2/sr3700_5/sr3700.data5         ONLINE+    28   3019907072  10485760000     20971520     8192     3407882  FILE  NOLINK
PSAPSR3700     ONLINE+    /oracle/P01/sapdata2/sr3700_6/sr3700.data6         ONLINE+    29   3019907072  10485760000     20971520     8192     3407882  FILE  NOLINK
PSAPSR3700     ONLINE+    /oracle/P01/sapdata2/sr3700_7/sr3700.data7         ONLINE+    30   2998935552  10485760000     20971520     8192     3407882  FILE  NOLINK
PSAPSR3700     ONLINE+    /oracle/P01/sapdata2/sr3700_8/sr3700.data8         ONLINE+    31   2810191872  10485760000     20971520     8192     3407882  FILE  NOLINK
PSAPSR3700     ONLINE+    /oracle/P01/sapdata3/sr3700_9/sr3700.data9         ONLINE+    32   2789220352  10485760000     20971520     8192     3407883  FILE  NOLINK
PSAPSR3700     ONLINE+    /oracle/P01/sapdata3/sr3700_10/sr3700.data10       ONLINE+    33   2726305792  10485760000     20971520     8192     3407883  FILE  NOLINK
PSAPSR3700     ONLINE+    /oracle/P01/sapdata3/sr3700_11/sr3700.data11       ONLINE+    34   2684362752  10485760000     20971520     8192     3407883  FILE  NOLINK
PSAPSR3700     ONLINE+    /oracle/P01/sapdata3/sr3700_12/sr3700.data12       ONLINE+    35   2684362752  10485760000     20971520     8192     3407883  FILE  NOLINK
PSAPSR3700     ONLINE+    /oracle/P01/sapdata4/sr3700_13/sr3700.data13       ONLINE+    36   2621448192  10485760000     20971520     8192     3407884  FILE  NOLINK
PSAPSR3700     ONLINE+    /oracle/P01/sapdata4/sr3700_14/sr3700.data14       ONLINE+    37   2621448192  10485760000     20971520     8192     3407884  FILE  NOLINK
PSAPSR3700     ONLINE+    /oracle/P01/sapdata4/sr3700_15/sr3700.data15       ONLINE+    38   2600476672  10485760000     20971520     8192     3407884  FILE  NOLINK
PSAPSR3700     ONLINE+    /oracle/P01/sapdata4/sr3700_16/sr3700.data16       ONLINE+    39   2579505152  10485760000     20971520     8192     3407884  FILE  NOLINK
PSAPSR3DB      ONLINE+    /oracle/P01/sapdata4/sr3db_1/sr3db.data1           ONLINE+    41   2097160192  10485760000     20971520     8192     3407884  FILE  NOLINK
PSAPSR3DB      ONLINE+    /oracle/P01/sapdata4/sr3db_2/sr3db.data2           ONLINE+    42   2097160192  10485760000     20971520     8192     3407884  FILE  NOLINK
PSAPSR3DB      ONLINE+    /oracle/P01/sapdata4/sr3db_3/sr3db.data3           ONLINE+    43   1048584192  10485760000     20971520     8192     3407884  FILE  NOLINK
PSAPSR3USR     ONLINE+    /oracle/P01/sapdata1/sr3usr_1/sr3usr.data1         ONLINE+    40     20979712  10485760000     20971520     8192     3407881  FILE  NOLINK
PSAPTEMP       ONLINE#    /oracle/P01/sapdata2/temp_1/temp.data1             ONLINE+    -1   2097160192  10485760000     20971520     8192     3407882  FILE  NOLINK
PSAPUNDO       ONLINE-    /oracle/P01/sapdata3/undo_1/undo.data1             ONLINE+     2  10485768192  10485760000     20971520     8192     3407883  FILE  NOLINK
SYSAUX         ONLINE+    /oracle/P01/sapdata1/sysaux_1/sysaux.data1         ONLINE+     3    314580992  10485760000     20971520     8192     3407881  FILE  NOLINK
SYSTEM         ONLINE+    /oracle/P01/sapdata1/system_1/system.data1         SYSTEM+     1    922755072  10485760000     20971520     8192     3407881  FILE  NOLINK
BR0119I Redo log files
File                                          Status  Group       Size       Device  Type  Link
/oracle/P01/origlogA/log_g11m1.dbf            INUSE      1    52429312      3407875  FILE  NOLINK
/oracle/P01/mirrlogA/log_g11m2.dbf            INUSE      1    52429312      3407877  FILE  NOLINK
/oracle/P01/origlogB/log_g12m1.dbf            INUSE      2    52429312      3407876  FILE  NOLINK
/oracle/P01/mirrlogB/log_g12m2.dbf            INUSE      2    52429312      3407878  FILE  NOLINK
/oracle/P01/origlogA/log_g13m1.dbf            INUSE      3    52429312      3407875  FILE  NOLINK
/oracle/P01/mirrlogA/log_g13m2.dbf            INUSE      3    52429312      3407877  FILE  NOLINK
/oracle/P01/origlogB/log_g14m1.dbf            INUSE      4    52429312      3407876  FILE  NOLINK
/oracle/P01/mirrlogB/log_g14m2.dbf            INUSE      4    52429312      3407878  FILE  NOLINK
/oracle/P01/origlogA/log_g15m1.dbf            INUSE     15    52429312      3407875  FILE  NOLINK
/oracle/P01/mirrlogA/log_g15m2.dbf            INUSE     15    52429312      3407877  FILE  NOLINK
/oracle/P01/origlogB/log_g16m1.dbf            INUSE     16    52429312      3407876  FILE  NOLINK
/oracle/P01/mirrlogB/log_g16m2.dbf            INUSE     16    52429312      3407878  FILE  NOLINK
BR0120I Control files
File                                                Size       Device  Type  Link
/oracle/P01/origlogA/cntrl/cntrlP01.dbf         20824064      3407875  FILE  NOLINK
/oracle/P01/origlogB/cntrl/cntrlP01.dbf         20824064      3407876  FILE  NOLINK
/oracle/P01/sapdata1/cntrl/cntrlP01.dbf         20824064      3407881  FILE  NOLINK
BR0982I Database disk volumes
Directory / Raw disk                          Device      Total[KB]      Free[KB]    Used[%]   MaxNeed[KB]   MaxMiss[KB]
/oracle/P01/102_64                           3407885      95420416      88532064       7.22             0             0
/oracle/P01                                  3407886     152043520     151753216       0.19             0             0
/oracle/P01/mirrlogA                         3407877       4194304       4039716       3.69             0             0
/oracle/P01/mirrlogB                         3407878       4194304       4039720       3.69             0             0
/oracle/P01/origlogA                         3407875       4194304       4019364       4.17             0             0
/oracle/P01/origlogB                         3407876       4194304       4019364       4.17             0             0
/oracle/P01/sapdata1                         3407881      62914560      37836620      39.86      97832960      59996340
/oracle/P01/sapdata2                         3407882      62914560      37138068      40.97      76634048      39495980
/oracle/P01/sapdata3                         3407883      62914560      28435996      54.80      67932160      39496164
/oracle/P01/sapdata4                         3407884      62914560      34334328      45.43      94310400      59976072
/oracle/P01/saparch                          3407886     152043520     151753216       0.19             0             0
/oracle/P01/sapbackup                        3407886     152043520     151753216       0.19             0             0
/oracle/P01/sapcheck                         3407886     152043520     151753216       0.19             0             0
/oracle/P01/sapreorg                         3407880       4194304       4193324       0.02             0             0
/oracle/P01/saptrace                         3407886     152043520     151753216       0.19             0             0
/oracle/P01/oraarch                          3407879      20971520      20269860       3.35             0             0
BR0280I BRCONNECT time stamp: 2012-10-15 23.00.10
BR0814I Number of tables in schema of owner SAPSR3: 70104
BR0836I Number of info cube tables found for owner SAPSR3: 49
BR0814I Number of tables in schema of owner SAPSR3DB: 318
BR0814I Number of tables/partitions in schema of owner SYS: 621/189
BR0814I Number of tables/partitions in schema of owner SYSTEM: 134/27
BR0280I BRCONNECT time stamp: 2012-10-15 23.00.19
BR0815I Number of indexes in schema of owner SAPSR3: 83844
BR0815I Number of indexes in schema of owner SAPSR3DB: 466
BR0815I Number of indexes/partitions in schema of owner SYS: 675/199
BR0815I Number of indexes/partitions in schema of owner SYSTEM: 175/32
BR0280I BRCONNECT time stamp: 2012-10-15 23.00.45
BR0816I Number of segments in schema of owner DBSNMP: 25
BR0816I Number of segments in schema of owner OPS$P01ADM: 1
BR0816I Number of segments in schema of owner OUTLN: 8
BR0816I Number of segments/LOBs in schema of owner SAPSR3: 158226/2139
BR0816I Number of segments/LOBs in schema of owner SAPSR3DB: 1012/114
BR0816I Number of segments/LOBs in schema of owner SYS: 1818/85
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: 2012-10-15 23.00.45
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          20    69791    83404     199079     53022720     99.97        18176          4     190730240+     137707520+    27.79+     137725696+       7741440+:7700480+:7680000+:7680000+:7659520+
PSAPSR3700       16      299      425       9856     43253760     99.93        29120         16     161935360+     118681600+    26.69+     118710720+       7720960+:7720960+:7720960+:7700480+:7680000+
PSAPSR3DB         3      318      466       1623      5120000     21.93      3997056          4      30720000+      25600000+     3.66+      29597056+       9216000+:8192000+:8192000+:1692608:1630144
PSAPSR3USR        1       14       15         29        20480      9.38        18560          1      10240000+      10219520+     0.02+      10238080+      10219520+:18560:0:0:0
PSAPTEMP          1        0        0          0      2048000      0.20      2043904          0      10240000+       8192000+     0.04+      10235904+       8192000+:0:0:0:0
PSAPUNDO          1        0        0          0     10240000      0.00     10239936        242      10240000              0      0.00       10239936        4063232:2566144:2113472:100352:74752
SYSAUX            1      252      282       2117       307200     88.00        36864          3      10240000+       9932800+     2.64+       9969664+       9932800+:35776:1024:64:0
SYSTEM            1      503      568       2839       901120     99.44         5056          1      10240000+       9338880+     8.75+       9343936+       9338880+:5056:0:0:0
Total:           44    71177    85160     215543    114913280     85.74     16388672        271     434585600      319672320     22.67      336060992       66424832:26238976:25707456:17173504:17044416
BR0280I BRCONNECT time stamp: 2012-10-15 23.00.45
BR0818I Number of tables found in DBDIFF for owner SAPSR3: 2
BR0280I BRCONNECT time stamp: 2012-10-15 23.00.45
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 temp 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 temp 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                           ><      14234,624 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: 2012-10-15 23.00.45
BR0807I Name of database instance: P01
BR0808I BRCONNECT action ID: cejqydjo
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: cejqtfol.chk 2012-10-14 23.00.03
BR0126I Unattended mode active - no operator confirmation required
BR0280I BRCONNECT time stamp: 2012-10-15 23.00.45
BR0969I Checking database administration...
BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 5 files on disk 3407881) 38256640 KB (> 37836620 KB)
BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 5 files on disk 3407882) 37990400 KB (> 37138068 KB)
BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 5 files on disk 3407883) 37601280 KB (> 28435996 KB)
BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 5 files on disk 3407884) 37928960 KB (> 34334328 KB)
BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3700, value: (max_extn of 4 files on disk 3407883) 30330880 KB (> 28435996 KB)
BR0280I BRCONNECT time stamp: 2012-10-15 23.00.46
BR0972I Checking database operations...
BR0280I BRCONNECT time stamp: 2012-10-15 23.00.46
BR0974I Checking database messages in /oracle/P01/saptrace/background/alert_P01.log ...
BR0976W Database message alert - level: WARNING, line: 5514984, time: 2012-10-15 00.05.47, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 5515002, time: 2012-10-15 00.05.57, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 5515020, time: 2012-10-15 00.06.16, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 5515038, time: 2012-10-15 00.06.32, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 5515056, time: 2012-10-15 00.06.47, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 5515074, time: 2012-10-15 00.07.03, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 5515092, time: 2012-10-15 00.07.18, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 5515110, time: 2012-10-15 00.07.33, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 5515128, time: 2012-10-15 00.07.48, message:
Checkpoint not complete
BR0976W Database message alert - level: WARNING, line: 5515146, time: 2012-10-15 00.08.03, message:
Checkpoint not complete
BR0280I BRCONNECT time stamp: 2012-10-15 23.00.49
BR0977I Checking database profile...
BR0280I BRCONNECT time stamp: 2012-10-15 23.00.49
BR0980I Number of changed database profile parameters: 0
BR0280I BRCONNECT time stamp: 2012-10-15 23.00.50
BR0955I Number of signaled error/warning/exception alerts for database administration: 0/5/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/10/0
BR0958I Number of signaled error/warning/exception alerts for database profile: 0/0/0
BR0806I End of BRCONNECT processing: cejqydjo.chk 2012-10-15 23.00.50
BR0280I BRCONNECT time stamp: 2012-10-15 23.00.50
BR0803I BRCONNECT completed successfully with warnings

Regards,

Sanju M S

[Former Member]

Sanju,

you asked frequently asked questions here.

Did you bother to search yourself?

Even more surprising imho is the frequently given answer regarding the CRITICAL_TABLESPACE.

Increasing the tablespace would just be wrong here. The messages would rather become more seriously.

Just think carefully about the message text. It is trying to tell you this:

One ore more datafiles of your tablespace are set to 'autoextend on'; that means they could increase up to a given limit.

But: The limit you have chosen is so high that the files wouldn't fit into the space provided by your operating system or your storage system.

Now please think yourself about what to do now,

hope this helps

[Former Member]

>> BR0976W Database message alert - level: WARNING, line: 5514984, time: 2012-10-15 00.05.47, message:

Checkpoint not complete

Please read Note 79341 - Checkpoint not complete to make a decision how to resolve this issue.

Regards,

Roman

[Former Member]

I recommend to upgrade to Oracle 11.2 and attend SAP course "ADM505 Oracle Administration" or read a good book about SAP on Oracle.

[Former Member]

Hi Sanju,

>> BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 5 files on disk 3407884) 37928960 KB (> 34334328 KB)

Increase or add a new datafile to the PSAPSR3 tablespace

>> BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3700, value: (max_extn of 4 files on disk 3407883) 30330880 KB (> 28435996 KB)

Increase or add a new datafile to the PSAPSR3700 tablespace

>> BR0976W Database message alert - level: WARNING, line: 5514984, time: 2012-10-15 00.05.47, message:

Checkpoint not complete

Increase online redolog size or add a new group

Best regards,

Orkun Gedik