on 11-24-2012 11:27 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.