Topic: Database Administration >> Sysaux tablespace corrupted
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Sysaux tablespace corrupted |
| Ratnaker |
Posted: Jun 05, 2007 10:45:59 AM |
Total Post: 138
Joined: Apr, 2007
|
Hi all,
select * from v$database_block_corruption
FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
------- ---------- ---------- ------------------ ---------
3 18677 1 0 FRACTURED
3 18685 1 0 FRACTURED
select * from dba_extents
where file_id=3
and 18677 between block_id and
(block_id +( blocks -1));
OWNER SEGMENT_NAME PARTITION_NAME SEGMENT_TYPE TABLESPACE_NAME EXTENT_ID FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
------------------------------ --------------------------------------------------------------------------------- ------------------------------ ------------------ ------------------------------ ---------- ---------- ---------- ---------- ---------- ------
SYS WRI$_OPTSTAT_HISTGRM_HISTORY TABLE SYSAUX 17 3 18569 1048576 128 3
How I can repair corrupted bolck? Please send me solution.I am not able to take backup.
Ratnaker
|
|
|
 KS |
| Posted: Jun 14, 2007 11:58:37 AM |  |
|
Total Post: 63
Joined: Nov, 2006
|
Do u have any full backup (Taken Earlier) ??
|
|
|
|
|
| KS |
| Posted: Jun 15, 2007 01:56:27 AM | |
|
Total Post: 63
Joined: Nov, 2006
|
Hi,
You can use the DBVERIFY utility to solve your problem.
D:\SCRIPT~1\test>dbv
DBVERIFY: Release 10.2.0.1.0 - Production on Fri Jun 15 11:23:35 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Keyword Description (Default)
----------------------------------------------------
FILE File to Verify (NONE)
START Start Block (First Block of File)
END End Block (Last Block of File)
BLOCKSIZE Logical Block Size (8192)
LOGFILE Output Log (NONE)
FEEDBACK Display Progress (0)
PARFILE Parameter File (NONE)
USERID Username/Password (NONE)
SEGMENT_ID Segment ID (tsn.relfile.block) (NONE)
HIGH_SCN Highest Block SCN To Verify (NONE)
(scn_wrap.scn_base OR scn)
dbv FILE='CORRUPTED_DATAFILE_PATH' START=BLOCK_NUMBER END=BLOCK_NUMBER
Regards,
Sri
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 816 |
| Mohammed Taj | 746 |
| Jayanta Sur | 479 |
| positive fanatic | 418 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 250 |
| Ramesh Jois | 245 |
| neeraj sharma | 243 |
| Bishal Khetan | 207 |
|
|
