DB13 DBCHECK giving warnings

[Former Member]

Hi gurus

while i am running the DBCHECK in DB13 it is giving the warnings like

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/DBW/sapdata3/sr3700_1/sr3700.data1, value: (max_extn) 6082560 KB (> 3744152 KB)

the Warnings at line number 275 to 313

*for further info i am posting all log here *

1

2 Detail log: cdyecdmm . chk

3

4 BR0801I BRCONNECT 7.00 (24)

5 BR0477I Oracle pfile /oracle/DBW/102_64/dbs/initDBW.ora created from spfile /oracle/DBW/102_64/dbs/spfileDBW.ora

6 BR0805I Start of BRCONNECT processing: cdyecdmm.chk 2008-06-18 10.39.20

7 BR0484I BRCONNECT log file: /oracle/DBW/sapcheck/cdyecdmm.chk

8 BR0101I Parameters

9 Name Value

10 oracle_sid DBW

11 oracle_home /oracle/DBW/102_64

12 oracle_profile /oracle/DBW/102_64/dbs/initDBW.ora

13 sapdata_home /oracle/DBW

14 sap_profile /oracle/DBW/102_64/dbs/initDBW.sap

15 system_info dbwadm/oradbw bwhdev AIX 3 5 00C917004C00

16 oracle_info DBW 10.2.0.2.0 8192 2165 22899626 bwhdev UTF8 UTF8

17 sap_info 700 SAPSR3 0002LK0003DBW0011V10958535460013NetWeaver_ORA

18 make_info rs6000_64 OCI_102 Apr 21 2007

19 command_line brconnect -u / -jid CHECK20080618103920 -c -f check

20 alert_log /oracle/DBW/saptrace/background/alert_DBW.log

21 BR0280I BRCONNECT time stamp: 2008-06-18 10.39.21

22 BR0813I Schema owners found in database DBW:

23 DBSNMP, DIP, OPS$DBWADM, OPS$ORADBW, OPS$SAPSERVICEDBW, OPS$SR3ADM, OUTLN, SAPSR3*, SAPSR3DB%, SYS,

24 SYSTEM, TSMSYS

25 BR0118I Tablespaces and data files

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

27 PSAPSR3 ONLINE+ /oracle/DBW/sapdata2/sr3_1/sr3.data1 ONLINE+ 4 2915049472 10485760000 20971520 8192 2490385 FILE NOLINK

28 PSAPSR3 ONLINE+ /oracle/DBW/sapdata2/sr3_2/sr3.data2 ONLINE+ 5 2956992512 10485760000 20971520 8192 2490385 FILE NOLINK

29 PSAPSR3 ONLINE+ /oracle/DBW/sapdata2/sr3_3/sr3.data3 ONLINE+ 6 2915049472 10485760000 20971520 8192 2490385 FILE NOLINK

30 PSAPSR3 ONLINE+ /oracle/DBW/sapdata2/sr3_4/sr3.data4 ONLINE+ 7 2873106432 10485760000 20971520 8192 2490385 FILE NOLINK

31 PSAPSR3700 ONLINE+ /oracle/DBW/sapdata3/sr3700_1/sr3700.data1 ONLINE+ 8 4257226752 10485760000 20971520 8192 2490386 FILE NOLINK

32 PSAPSR3700 ONLINE+ /oracle/DBW/sapdata3/sr3700_2/sr3700.data2 ONLINE+ 9 4592771072 10485760000 20971520 8192 2490386 FILE NOLINK

33 PSAPSR3700 ONLINE+ /oracle/DBW/sapdata3/sr3700_3/sr3700.data3 ONLINE+ 10 4404027392 10485760000 20971520 8192 2490386 FILE NOLINK

34 PSAPSR3700 ONLINE+ /oracle/DBW/sapdata3/sr3700_4/sr3700.data4 ONLINE+ 11 4383055872 10485760000 20971520 8192 2490386 FILE NOLINK

35 PSAPSR3DB ONLINE+ /oracle/DBW/sapdata4/sr3db_1/sr3db.data1 ONLINE+ 13 2097160192 10485760000 20971520 8192 2490387 FILE NOLINK

36 PSAPSR3DB ONLINE+ /oracle/DBW/sapdata4/sr3db_2/sr3db.data2 ONLINE+ 14 2097160192 10485760000 20971520 8192 2490387 FILE NOLINK

37 PSAPSR3DB ONLINE+ /oracle/DBW/sapdata4/sr3db_3/sr3db.data3 ONLINE+ 15 1048584192 10485760000 20971520 8192 2490387 FILE NOLINK

38 PSAPSR3USR ONLINE+ /oracle/DBW/sapdata4/sr3usr_1/sr3usr.data1 ONLINE+ 12 20979712 10485760000 20971520 8192 2490387 FILE NOLINK

39 PSAPTEMP ONLINE# /oracle/DBW/sapdata1/temp_1/temp.data1 ONLINE+ -1 1048584192 10485760000 20971520 8192 2490384 FILE NOLINK

40 PSAPUNDO ONLINE- /oracle/DBW/sapdata1/undo_1/undo.data1 ONLINE+ 2 6396321792 10485760000 20971520 8192 2490384 FILE NOLINK

41 SYSAUX ONLINE+ /oracle/DBW/sapdata1/sysaux_1/sysaux.data1 ONLINE+ 3 209723392 10485760000 20971520 8192 2490384 FILE NOLINK

42 SYSTEM ONLINE+ /oracle/DBW/sapdata1/system_1/system.data1 SYSTEM+ 1 545267712 10485760000 20971520 8192 2490384 FILE NOLINK

43 BR0119I Redo log files

44 File Status Group Size Device Type Link

45 /oracle/DBW/origlogA/log_g11m1.dbf INUSE 1 52429312 2490378 FILE NOLINK

46 /oracle/DBW/mirrlogA/log_g11m2.dbf INUSE 1 52429312 2490380 FILE NOLINK

47 /oracle/DBW/origlogB/log_g12m1.dbf INUSE 2 52429312 2490379 FILE NOLINK

48 /oracle/DBW/mirrlogB/log_g12m2.dbf INUSE 2 52429312 2490381 FILE NOLINK

49 /oracle/DBW/origlogA/log_g13m1.dbf INUSE 3 52429312 2490378 FILE NOLINK

50 /oracle/DBW/mirrlogA/log_g13m2.dbf INUSE 3 52429312 2490380 FILE NOLINK

51 /oracle/DBW/origlogB/log_g14m1.dbf INUSE 4 52429312 2490379 FILE NOLINK

52 /oracle/DBW/mirrlogB/log_g14m2.dbf INUSE 4 52429312 2490381 FILE NOLINK

53 BR0120I Control files

54 File Size Device Type Link

55 /oracle/DBW/origlogA/cntrl/cntlrDBW.dbf 9388032 2490378 FILE NOLINK

56 /oracle/DBW/origlogB/cntrl/cntrlDBW.dbf 9388032 2490379 FILE NOLINK

57 /oracle/DBW/sapdata1/cntrl/cntrlDBW.dbf 9388032 2490384 FILE NOLINK

58 BR0982I Database disk volumes

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

60 /oracle/DBW/102_64 2490376 7929856 4059508 48.81 0 0

61 /oracle/DBW 2490375 458752 191872 58.18 0 0

62 /oracle/DBW/mirrlogA 2490380 524288 421472 19.61 0 0

63 /oracle/DBW/mirrlogB 2490381 524288 421472 19.61 0 0

64 /oracle/DBW/origlogA 2490378 524288 412288 21.36 0 0

65 /oracle/DBW/origlogB 2490379 524288 412288 21.36 0 0

66 /oracle/DBW/sapdata1 2490384 20971520 13058468 37.73 33059764 20001296

67 /oracle/DBW/sapdata2 2490385 20971520 9581020 54.31 29573120 19992100

68 /oracle/DBW/sapdata3 2490386 20971520 3744152 82.15 23736320 19992168

69 /oracle/DBW/sapdata4 2490387 20971520 15827444 24.53 35819520 19992076

70 /oracle/DBW/saparch 2490375 458752 191872 58.18 0 0

71 /oracle/DBW/sapbackup 2490375 458752 191872 58.18 0 0

72 /oracle/DBW/sapcheck 2490375 458752 191872 58.18 0 0

73 /oracle/DBW/sapreorg 2490383 1048576 1048044 0.05 0 0

74 /oracle/DBW/saptrace 2490375 458752 191872 58.18 0 0

75 BR0280I BRCONNECT time stamp: 2008-06-18 10.39.24

76 BR0814I Number of tables/partitions in schema of owner SAPSR3: 21718/406

77 BR0836I Number of info cube tables found for owner SAPSR3: 2458

78 BR0814I Number of tables in schema of owner SAPSR3DB: 640

79 BR0814I Number of tables/partitions in schema of owner SYS: 621/153

80 BR0814I Number of tables/partitions in schema of owner SYSTEM: 134/27

81 BR0280I BRCONNECT time stamp: 2008-06-18 10.39.26

82 BR0815I Number of indexes/partitions in schema of owner SAPSR3: 30043/964

83 BR0815I Number of indexes in schema of owner SAPSR3DB: 959

84 BR0815I Number of indexes/partitions in schema of owner SYS: 675/161

85 BR0815I Number of indexes/partitions in schema of owner SYSTEM: 175/32

86 BR0280I BRCONNECT time stamp: 2008-06-18 10.39.32

87 BR0816I Number of segments in schema of owner DBSNMP: 25

88 BR0816I Number of segments in schema of owner OPS$DBWADM: 1

89 BR0816I Number of segments in schema of owner OUTLN: 8

90 BR0816I Number of segments/LOBs in schema of owner SAPSR3: 54565/1339

91 BR0816I Number of segments/LOBs in schema of owner SAPSR3DB: 2109/255

92 BR0816I Number of segments/LOBs in schema of owner SYS: 1725/85

93 BR0816I Number of segments/LOBs in schema of owner SYSTEM: 353/22

94 BR0816I Number of segments in schema of owner TSMSYS: 4

95 BR0280I BRCONNECT time stamp: 2008-06-18 10.39.32

96 BR0961I Number of conditions found in DBCHECKORA: 118

97 BR0983I Tablespace fragmentation

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

99 PSAPSR3 4 21409 29602 70593 11386880 99.82 20288 4 40960000+ 20951040+ 54.25+ 9584448+ 7434240:2129920:18368:960:896

100 PSAPSR3700 4 304 437 6147 17223680 99.83 28992 5 40960000+ 20951040+ 82.07+ 3756352+ 3727360+:16320:8128:3008:960

101 PSAPSR3DB 3 640 959 4176 5120000 72.17 1424896 3 30720000+ 20930560+ 17.65+ 17235456+ 9216000:6594560:735168:689088:640

102 PSAPSR3USR 1 5 4 11 20480 3.75 19712 1 10240000+ 10240000+ 0.01+ 10239232+ 10219520+:19712:0:0:0

103 PSAPTEMP 1 0 0 0 1024000 0.00 1024000 0 10240000+ 10240000+ 0.00+ 10240000+ 9216000+:0:0:0:0

104 PSAPUNDO 1 0 0 0 6246400 0.00 6246336 123 10240000+ 10240000+ 0.00+ 10239936+ 3993600+:3637248:2183104:144384:139264

105 SYSAUX 1 252 282 1808 204800 84.84 31040 59 10240000+ 10240000+ 1.70+ 10066240+ 10035200+:14272:4352:1024:640

106 SYSTEM 1 503 568 2389 532480 97.61 12736 2 10240000+ 10240000+ 5.08+ 9720256+ 9707520+:12224:512:0:0

107 Total: 16 23113 31852 85124 41758720 78.91 8808000 197 114032640 28.90 81081920 63549440:12424256:2949632:838464:142400

108 BR0280I BRCONNECT time stamp: 2008-06-18 10.39.32

109 BR0818I Number of tables found in DBDIFF for owner SAPSR3: 218

110 BR0280I BRCONNECT time stamp: 2008-06-18 10.39.33

111 BR0818I Number of tables found in DBSTATC for owner SAPSR3: 100

112 BR0962I Check conditions for database administration:

113 Pos. Act. Lev. Condition Object

114 Description

115 1 Y W ARCHIVER_STUCK

116 Out of space in archive directory - more than 90% space used

117 2 Y E CONTROL_FILE_MIRROR

118 Control file not mirrored

119 3 Y E CONTROL_FILE_MISSING

120 Control file missing on disk

121 4 Y W CRITICAL_FILE

122 File autoextend can cause file system overflow

123 5 Y W CRITICAL_SEGMENT

124 Segment can cause tablespace overflow - by allocating up to 2 next extent(s)

125 6 Y W CRITICAL_TABLESPACE

126 Tablespace files autoextend can cause file system overflow

127 7 Y E DATA_FILE_MISMATCH

128 Data file marked as missing in control file

129 8 Y E DATA_FILE_MISSING

130 Data file missing on disk

131 9 Y E FILE_OFFLINE

132 Database file offline

133 10 Y W FILE_SYSTEM_FULL

134 File system full - more than 99% space used

135 11 Y E HARMFUL_STATISTICS

136 Table or index has harmful optimizer statistics

137 12 Y E INVALID_FILE_TYPE

138 Invalid operating system file type

139 13 Y W IN_WRONG_TABLESPACE

140 Table or index in wrong tablespace

141 14 Y E MISSING_INDEX

142 Table has no index

143 15 Y E MISSING_STATISTICS

144 Table or index has no optimizer statistics

145 16 Y E NOARCHIVELOG_MODE

146 Database in NOARCHIVELOG mode

147 17 Y W PCTINCREASE_NOT_ZERO

148 PCTINCREASE value not equal zero

149 18 Y E REDOLOG_FILE_MIRROR

150 Redo log file not mirrored

151 19 Y E REDOLOG_FILE_MISSING

152 Redo log file missing on disk

153 20 Y W TABLESPACE_FULL

154 Tablespace full - more than 95% space used

155 21 Y W TABLESPACE_IN_BACKUP

156 Tablespace in backup mode

157 22 Y E TABLESPACE_OFFLINE

158 Tablespace offline

159 23 Y W TOO_MANY_EXTENTS

160 Segment has too many extents - more than 90% of MAXEXTENTS used

161 BR0963I Check conditions for database operations:

162 Pos. Act. Lev. Condition Description

163 1 Y W ARCHIVE_TOO_OLD Last successful archive log backup older than 10 days (or has not been run)

164 2 Y W BACKUP_TOO_OLD Last successful complete database backup older than 10 days (or has not been run)

165 3 Y W LAST_ARCHIVE_FAILED Last archive log backup failed

166 4 Y W LAST_BACKUP_FAILED Last complete database backup failed

167 5 Y W LAST_OPERATION_FAILED Last 'chk' operation failed

168 6 N W LAST_OPERATION_FAILED Last DBA operation failed

169 7 Y W LAST_STATS_FAILED Last update optimizer statistics failed

170 8 Y W OPERATION_TOO_OLD Last successful 'chk' operation older than 10 days (or has not been run)

171 9 N W OPERATION_TOO_OLD Last successful DBA operation older than 10 days (or has not been run)

172 10 Y W STATS_TOO_OLD Last successful update optimizer statistics older than 10 days (or has not been run)

173 BR0964I Check conditions for database messages:

174 Pos. Act. Lev. Message Description

175 1 Y W ORA-00060 Deadlock while waiting for resource

176 2 Y E ORA-00255 Error archiving log file

177 3 Y E ORA-00257 Archiver error

178 4 Y E ORA-00270 Error creating archive log

179 5 Y E ORA-00272 Error writing archive log

180 6 Y E ORA-00376 Database file cannot be read

181 7 Y E ORA-00447 Fatal error in background process

182 8 Y E ORA-00470 LGWR process terminated with error

183 9 Y E ORA-00471 DBWR process terminated with error

184 10 Y E ORA-00472 PMON process terminated with error

185 11 Y E ORA-00473 ARCH process terminated with error

186 12 Y E ORA-00474 SMON process terminated with error

187 13 Y E ORA-00600 Oracle internal error

188 14 Y E ORA-00603 Oracle server session terminated by fatal error

189 15 Y E ORA-01113 Data file needs media recovery

190 16 Y E ORA-01114 I/O error writing database file

191 17 Y E ORA-01115 I/O error reading database file

192 18 Y E ORA-01122 File verification check failed

193 19 Y E ORA-01135 Database file is offline

194 20 Y W ORA-01149 Cannot shutdown - data file in backup mode

195 21 Y W ORA-01555 Snapshot too old

196 22 Y W ORA-01562 Failed to extend rollback segment

197 23 Y E ORA-01578 Database block corrupted

198 24 Y E ORA-01628 Max. extents reached for rollback segment

199 25 Y E ORA-01629 Max. extents reached saving undo for tablespace

200 26 Y E ORA-01630 Max. extents reached in temp segment in tablespace

201 27 Y E ORA-01631 Max. extents reached in table

202 28 Y E ORA-01632 Max. extents reached in index

203 29 Y E ORA-01650 Unable to extend rollback segment in tablespace

204 30 Y E ORA-01651 Unable to extend save undo segment for tablespace

205 31 Y E ORA-01652 Unable to extend temp segment in tablespace

206 32 Y E ORA-01653 Unable to extend table in tablespace

207 33 Y E ORA-01654 Unable to extend index in tablespace

208 34 Y E ORA-01655 Unable to extend cluster in tablespace

209 35 Y E ORA-01656 Max. extents reached in cluster

210 36 Y E ORA-01680 Unable to extend LOB segment in tablespace

211 37 Y E ORA-01681 Max. extents reached in LOB segment in tablespace

212 38 Y E ORA-01683 Unable to extend index partition

213 39 Y E ORA-01684 Max. extents reached in table partition

214 40 Y E ORA-01685 Max. extents reached in index partition

215 41 Y E ORA-01688 Unable to extend table partition

216 42 Y E ORA-01691 Unable to extend lob segment in tablespace

217 43 Y E ORA-01692 Unable to extend lob segment partition in tablespace

218 44 Y E ORA-01693 Max. extents reached in lob segment

219 45 Y E ORA-01694 Max. extents reached in lob segment partition

220 46 Y E ORA-03113 End-of-file on communication channel

221 47 Y E ORA-07445 Exception encountered: core dump

222 48 Y E ORA-16014 Destination not available for archiving log file

223 49 Y E ORA-16038 Log file cannot be archived

224 50 Y E ORA-19502 Write error on log file

225 51 Y E ORA-19504 Failed to create log file

226 52 Y E ORA-19510 Failed to set size of blocks for file

227 53 Y E ORA-27044 Unable to write the header block of file

228 54 Y E ORA-27063 Number of bytes read/written is incorrect

229 55 Y E ORA-27072 File I/O error

230 56 Y E ORA-30036 Unable to extend segment in undo tablespace

231 57 Y W Checkpoint not complete

232 58 Y E Corrupt block

233 BR0965I Check conditions for database profile:

234 Pos. Act. Lev. Parameter Condition Value Unit

235 1 Y E COMPATIBLE <> 10.2.0

236 2 Y W CONTROL_FILE_RECORD_KEEP_TIME < 30

237 3 Y E DB_BLOCK_SIZE <> 8192

238 4 Y W DB_FILES < 254

239 5 Y W DB_FILE_MULTIBLOCK_READ_COUNT

240 6 Y E FILESYSTEMIO_OPTIONS <> SETALL

241 7 Y W LOG_ARCHIVE_START

242 8 Y W LOG_BUFFER >< 4096,512 K

243 9 Y W LOG_CHECKPOINTS_TO_ALERT <> TRUE

244 10 Y W MAX_DUMP_FILE_SIZE >< 100000,10000

245 11 Y W OPEN_CURSORS >< 2000,800

246 12 Y W OPTIMIZER_FEATURES_ENABLE

247 13 Y W OPTIMIZER_INDEX_COST_ADJ

248 14 Y W OPTIMIZER_MODE

249 15 Y W PARALLEL_EXECUTION_MESSAGE_SIZE >< 16384,4096

250 16 Y W PARALLEL_THREADS_PER_CPU >< 2,1

251 17 Y E QUERY_REWRITE_ENABLED <> FALSE

252 18 Y E RECYCLEBIN <> OFF

253 19 Y E REMOTE_OS_AUTHENT <> TRUE

254 20 Y E REPLICATION_DEPENDENCY_TRACKING <> FALSE

255 21 Y W SHARED_POOL_SIZE < 400 M

256 22 Y W STAR_TRANSFORMATION_ENABLED <> TRUE

257 23 Y W STATISTICS_LEVEL

258 24 Y W TIMED_STATISTICS

259 25 Y W TRACE_ENABLED

260 26 Y E UNDO_MANAGEMENT <> AUTO

261 27 Y W UNDO_TABLESPACE <> PSAPUNDO

262 BR0280I BRCONNECT time stamp: 2008-06-18 10.39.33

263 BR0807I Name of database instance: DBW

264 BR0808I BRCONNECT action ID: cdyecdmm

265 BR0809I BRCONNECT function ID: chk

266 BR0810I BRCONNECT function: check

267 BR0951I Number of active/inactive check conditions for database administration: 23/0

268 BR0952I Number of active/inactive check conditions for database operations: 8/2

269 BR0953I Number of active/inactive check conditions for database messages: 58/0

270 BR0954I Number of active/inactive check conditions for database profile: 27/0

271 BR0960I Last successful BRCONNECT check run: cdxypqbh.chk 2008-05-20 10.51.29

272 BR0126I Unattended mode active - no operator confirmation required

273 BR0280I BRCONNECT time stamp: 2008-06-18 10.39.33

274 BR0969I Checking database administration...

275 BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/DBW/sapdata3/sr3700_1/sr3700.data1, value: (max_extn) 6082560 KB (> 3744152 KB)

276 BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/DBW/sapdata3/sr3700_2/sr3700.data2, value: (max_extn) 5754880 KB (> 3744152 KB)

277 BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/DBW/sapdata3/sr3700_3/sr3700.data3, value: (max_extn) 5939200 KB (> 3744152 KB)

278 BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/DBW/sapdata3/sr3700_4/sr3700.data4, value: (max_extn) 5959680 KB (> 3744152 KB)

279 BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 4 files on disk 2490385) 29573120 KB (> 9581020 KB)

280 BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3700, value: (max_extn of 4 files on disk 2490386) 23736320 KB (> 3744152 KB)

281 BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3DB, value: (max_extn of 3 files on disk 2490387) 25600000 KB (> 15827444 KB)

282 BR0280I BRCONNECT time stamp: 2008-06-18 10.39.34

283 BR0972I Checking database operations...

284 BR0973W Database operation alert - level: WARNING, operation: cdxypqbh.chk, time: 2008-05-20 10.51.29, condition: Last successful 'chk' operation older than 10 days

285 BR0973W Database operation alert - level: WARNING, operation: Archive log backup, condition: Operation too old or has not been run in clean-up period

286 BR0973W Database operation alert - level: WARNING, operation: Complete database backup, condition: Operation too old or has not been run in clean-up period

287 BR0280I BRCONNECT time stamp: 2008-06-18 10.39.34

288 BR0974I Checking database messages in /oracle/DBW/saptrace/background/alert_DBW.log ...

289 BR0976W Database message alert - level: WARNING, line: 1406992, time: 2008-05-23 12.01.02, message:

290 Checkpoint not complete

291 BR0976W Database message alert - level: WARNING, line: 1408850, time: 2008-06-03 16.09.42, message:

292 Checkpoint not complete

293 BR0976W Database message alert - level: WARNING, line: 1408899, time: 2008-06-03 16.42.00, message:

294 Checkpoint not complete

295 BR0280I BRCONNECT time stamp: 2008-06-18 10.39.35

296 BR0977I Checking database profile...

297 BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 14258176 (>< 4096,512 KB)

298 BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_FEATURES_ENABLE, value: 10.2.0.1 (set in parameter file)

299 BR0978W Database profile alert - level: WARNING, parameter: PARALLEL_EXECUTION_MESSAGE_SIZE, value: 2152 (>< 16384,4096)

300 BR0978W Database profile alert - level: ERROR, parameter: QUERY_REWRITE_ENABLED, value: TRUE (<> FALSE)

301 BR0978W Database profile alert - level: ERROR, parameter: REPLICATION_DEPENDENCY_TRACKING, value: TRUE (<> FALSE)

302 BR0978W Database profile alert - level: WARNING, parameter: STAR_TRANSFORMATION_ENABLED, value: FALSE (<> TRUE)

303 BR0978W Database profile alert - level: WARNING, parameter: STATISTICS_LEVEL, value: TYPICAL (set in parameter file)

304 BR0280I BRCONNECT time stamp: 2008-06-18 10.39.35

305 BR0980I Number of changed database profile parameters: 0

306 BR0280I BRCONNECT time stamp: 2008-06-18 10.39.35

307 BR0955I Number of signaled error/warning/exception alerts for database administration: 0/7/0

308 BR0956I Number of signaled error/warning/exception alerts for database operations: 0/3/0

309 BR0957I Number of signaled error/warning/exception alerts for database messages: 0/3/0

310 BR0958I Number of signaled error/warning/exception alerts for database profile: 2/5/0

311 BR0806I End of BRCONNECT processing: cdyecdmm.chk 2008-06-18 10.39.35

312 BR0280I BRCONNECT time stamp: 2008-06-18 10.39.35

313 BR0803I BRCONNECT completed successfully with warnings

Thanks in advance

[Former Member]

Hi,

the following errors

275 BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/DBW/sapdata3/sr3700_1/sr3700.data1, value: (max_extn) 6082560 KB (> 3744152 KB)

276 BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/DBW/sapdata3/sr3700_2/sr3700.data2, value: (max_extn) 5754880 KB (> 3744152 KB)

277 BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/DBW/sapdata3/sr3700_3/sr3700.data3, value: (max_extn) 5939200 KB (> 3744152 KB)

278 BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/DBW/sapdata3/sr3700_4/sr3700.data4, value: (max_extn) 5959680 KB (> 3744152 KB)

279 BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 4 files on disk 2490385) 29573120 KB (> 9581020 KB)

280 BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3700, value: (max_extn of 4 files on disk 2490386) 23736320 KB (> 3744152 KB)

281 BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3DB, value: (max_extn of 3 files on disk 2490387) 25600000 KB (> 15827444 KB)

282 BR0280I BRCONNECT time stamp: 2008-06-18 10.39.34

are due to the fact that your datafiles are in autoextend ON and the max size is higher than the space available on file systems.

So, if you want avoid this warning, you have 2 possibilities:

1. increase the size of file system

2. deincrease the max size of data files or put the data files in autoextend OFF

You have some other warnings, due to:

- you are not scheduling the backup database with BrBackup

- some Oracle parametrs are not matchin with the parameter definitions in transaction DB17.

I think this help you

By

Stefano

[stefan_koehler]

Hello Balaji,

here is the documentation for the errors:

http://help.sap.com/saphelp_nw70/helpdata/en/4d/a241ecee0d11d5996600508b5d5211/content.htm

Just search for the keywords "CRITICAL_TABLESPACE" or "CRITICAL_FILE" and you will find the explanation of the problem.

Regards

Stefan