Warnings in dbcheck

[Former Member]

Dear Gurus,

I am getting the following warnings in the DBCHECK on my prod server

BR0280I BRCONNECT time stamp: 2010-12-12 23.59.55

BR0818I Number of tables found in DBDIFF for owner SAPPRD: 2

BR0280I BRCONNECT time stamp: 2010-12-12 23.59.55

BR0818I Number of tables found in DBSTATC for owner SAPPRD: 403

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

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

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

Any suggestions?

[Former Member · Accepted solution]

Dear Gurus / friends,

I guess not everyone is genius and thus they ask their (sometimes silly) queries to this talent bank called SDN, for some technical advice

The said warnings are occurring from past 7-8 days and I have faced this situation for the first time so before doing anything silly, I sought opinion / technical inputs on the same as this is our Production Server

Nevertheless, many thanks for your time and all the esteemed technical inputs

Rgds..../-

[Former Member · Accepted solution]

Hi Sandy,

Please paste your complete checkdb log here.

perform a consistency check from Brtools and post that log as well here.

Thanks.

[Former Member · Accepted solution]

Hello Sandy_ECC, SDN community is to help consultants to resolve technical queries.

As I already mentioned there are no issues in your case as they are check conditions for your db check.

Have you checked the db check logs for you development or quality systems? You should get the same warnings.

[Former Member]

Hi,

your filesystem, tablespace are getting full.

Adress the other issues like each one.

Yes these are all serious problems if they showup in your dbcheck log file.

Regards,

Sitarama.

[Former Member]

If you read his orignal question, he simply copied the DB13 DB check logs which are Check conditions for database administration.

They are not a real issue with him. And all the DB check error/warning shold start with BRnnnn for example as below:

(BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 14222336 (<> 14289920)

[Former Member]

Hi sunil,

I agree he copied and pasted content from DB13 dbcheck log, but his posting begin with sentence

" I am getting the following warnings in the DBCHECK on my prod server"

I guess he was not having all problems same time, but he might be facing at different times.

I also had a doubt in my mind, he posted the query just to get information on how to handle various warning/error.

He did posting without any ground work(my guess).

Regards....

[Former Member]

Thats correct, he should do some research before posting on SDN.

[Syamkriz]

Hey you need to have a look at your filesystem. Check the space available. check the tablespace status in db02

[Former Member]

Hi,

1. Ensure that you have enough disk space for oraarch

2. Mirror your control files to the 3 locations in ur system

3. One of your datafile is in offline mode, bring it to online.

4. Few of your datafiles are missing, goto db02 and check the datafiles.

Dude, i think you have very serious problem.

Regards,

SBK

[Former Member]

>>Dude, i think you have very serious problem.

SBK, You sure he is in very serious problem? I don't think so.

Do you have access to your production system, can you plesae check the checkdb log? and see whether you have above entries in your log.

[Former Member]

These are from DB17. for more inforamtion about db17 visit help.sap.com

Whats the version of your Database? for 10g check note 830576 Parameter recommendations for Oracle 10g