DB Error

[Former Member]

Hi Experts

Could you please help me to sort out below issue.

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:

Regrds

Bharathi

[former_member213250 · Accepted solution]

Hello Bharathi..

In general when you are looking for some help on SCN, you need to give background of what you are posting.

In here, when I looked at your post first of all I want to know what exactly you are looking for.

You just posted half output from DBCHECK report.

Mostly with BRTOOLs report in the logs  always you have to reach to the end of the log file, there

you will be able to notice the end message like

1) ' job completed succesfully with warnings'

2) 'job completed sucessfully'

3) 'job terminated with errors'

Only in third case is where you need to worry abt when job terminated with errors.

So I hope there aren't any serious errors from your CHECKDB report.

Regards

Venkat

[volker_borowski2]

Hi,

there is no issue at all.

This is just a summary of what is checked.

"Issues" are tagged

BRxxxxW for Warnings or

BRxxxxE for Errors

BRxxxxI is just information

All other lines are just detail.

So

.... BR0963I Check conditions for database operations:

just tells you in the following lines what the checks according to DB operations are defined that will be checked.

Volker

[paul_power]

Hello Bharthi,

At the beginning of the log it looks like their is a lack of space at filesystem level, I also see errors about not being able to extend tablespace.

We then see  Corrupt block which is likely due to filesystem being full.

Please check the available sapce at filesystem level.

Check operating system logs from thsi time.

See the following:

SAP Note 17163 BRARCHIVE/BRBACKUP messages and codes

To make sure check on the block corruption, perform a consistency check.

Please review and follow the note below for your reference to handle

block corruption.

540463 - FAQ: Consistency Checks + Block Corruptions

23345 - Consistency check of ORACLE database

365481 - Block corruptions

4161 - Complete recovery

regards,

Paul

[nicholas_chang]

Hi,

I believe this is the summary of DBCHECK and it just for your info. It doesn't mean that your DB got all of the errors.

You just need to navigate to the end of the result and check for "warning" and "error" section.

If you keen to learn what are those errors about, just "google" it and you'll get the answer.

Cheers,

Nicholas Chang