Server Administration :: Block Corruption - Segment Not Found

May 16, 2012

I have a database where view v$database_block_corruption shows a corrupted block

SQL> select * from v$database_block_corruption;

FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
4 756652 1 5.5157E+12 CORRUPT

I am not able to get the relevant segment from the above information

SQL> select segment_name, segment_type, owner
2 from dba_extents
3 where file_id = 4
4 and 756652 between block_id
5 and block_id + blocks -1;

no rows selected

DBVERIFY Summary
DBVERIFY - Verification complete
Total Pages Examined : 3932160
Total Pages Processed (Data) : 3119107
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 755048

[code]....

I have uploaded the complete logfile.

Below is a part of logfile

DBVERIFY - Verification starting : FILE = /prd/dvp/ora/oradata/LHF/disk06/gds_t01_01.dbf
Block Checking: DBA = 21728172, Block Type = KTB-managed data block
**** kdxcoavs = -84 < 0, avail = 3129
---- end index block validation
Page 756652 failed with check code 6401
##not here that 756652 is the same block# mentioned in v$database_block_corruption

here i tried finding the OBJECT ID as below

SELECT dbms_utility.data_block_address_block(21728172) "BLOCK", dbms_utility.data_block_address_file(21728172) "FILE" FROM dual;
BLOCK FILE
---------- ----------
756652 5

Now for the same BLOCK it is giving different File, again the segment_name or segment_id could not be found from the above information.

View 4 Replies


ADVERTISEMENT

Server Administration :: Data Block Corruption

May 12, 2011

1) What is PHYSICAL/LOGICAL Corruption.
2) How it occurs.
3) Will RMAN works on both the types of corruption or only Physical (My senior told it works on both).

View 3 Replies View Related

Server Administration :: Ora / 1043 User Side Memory Corruption

Nov 20, 2002

I'm using Oracle8i, with VB6 as front end When i try to connect Oracle using RDO in VB i get an error message from Oracle It is S1000:Oracle ODBC.ora Ora:1043 User Side Memory Corruption.

View 11 Replies View Related

Server Administration :: How Segment Different From Object

Dec 26, 2012

Are the terms object and segment same ? what are the differences between them? what are similarities between them?

View 3 Replies View Related

Server Administration :: Segment Size?

Dec 28, 2011

I am working to understand the space allocation of table with the value we provided with the data type. For that I have created a table with varchar2 and length 50. Size of table created is of 65536 Bytes. This is when we don't have any insertion in the table. Later when we insert some rows, total size if the segment still remain same that is 65536 bytes.

Now again when I created table with varchar2 and length this time is 500 but still it is created with same size that is 65536. So can you just explain, on what values segment size depends on and how the length effect the size & space allocation.

db_block_size is 8192.

View 2 Replies View Related

Possible To Recover BLOCK Corruption With Exp Backups

Jul 9, 2013

While taking a full export i came to know there was a block corruption in SYSAUX tablespace. I dont have any COLD/HOTBACKUPS/RMAN BACKUPS. As i have only the Exp backups and the database is in archive log mode. Whether is it possible to recover the BLOCK CORRUPTION with exp backups.

View 12 Replies View Related

Server Administration :: ORA-10637 / The Segment Does Not Exist

Sep 26, 2011

Does It can not shrink in manual space managment tablespace?

I was confused by the error ORA-10637: The segment does not exist

create tablespace test_manual
datafile 'd:oracleoradataorcl est_manual.dbf' size 100m
segment space management manual
create user test_man identified by hxl
default tablespace test_manual;
grant create session to test_man;
grant resource to test_man;

[code]....

View 3 Replies View Related

Server Administration :: Segment Space Management?

Oct 13, 2010

am using Oracle 10.2.0.4 on win 2008 server SP2. I would like to know if we can set the Segment Space Management feature to AUTO for RBS and Temporary tablespaces. As the data is not permanent in these tablespaces, will it manage automatically?

Presently its Segment Space Mgmt is manual for System, RBS, Temporary tablespaces.

View 4 Replies View Related

Backup & Recovery :: Block Corruption In Expdp?

Feb 15, 2011

I am facing issue of block corruption in my exp backup which I am taking through expdp command. (Refer Attachment of Screen shot of error)

I want to know few things about the block corruption.

1. Why the block corruption occur.

2. How can I resolve this.

3. Can I rosolve this by deleting the same record on which this error is coming. if yes then how can I track that row in a table.

I already tried for DB verify utility. It shows the below result.

===================================================================
C:Documents and SettingsAdministrator>dbv file='E:ORADATAAFCCV1MONETA01.DBF' blocksize=8192
DBVERIFY: Release 11.1.0.6.0 - Production on Wed Feb 16 10:13:11 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = E:ORADATAAFCCV1MONETA01.DBF
DBV-00600: Fatal Error - [28] [27070] [0] [0]
C:Documents and SettingsAdministrator>
================================================================

View 12 Replies View Related

Backup & Recovery :: How To Find Corruption Block

Jun 9, 2012

how to find the corruption block and judge whether it is physical corruption or logical corruption?

View 3 Replies View Related

Replication :: Block Corruption While Accessing Some Table

Mar 16, 2011

The database is running in archivelog mode and we have a standby with Maximum performance.There is no RMAN backup..We have noticed there is block corruption while accessing some tables.Now i would like to know are the corrupted blocks also replicated to the physical standby? Is there a way to recover the data from these corrupted blocks without shutting down the database ?

View 1 Replies View Related

Server Administration :: Rollback Segment Too Small ORA-01555

Jan 19, 2012

One of the users received the error
ora-01555: rollback segment too small

I have read about the error and saw that it is caused by transactions made upon same data, filling to maximum one of the UNDOTBS rollback segments.It happens only once in a while, each time on a different Rollback Segment.

I've read that i should do a few things to enlarge those segments, such as bring a 1. segment offline, 2. drop it and then 3. create it with a bigger size & possibly a bigger extent setting

i've also read that those actions aren't relevant if you have the parameter UNDO_MANAGEMENT set on AUTO, which is actually the case.is that why when i execute ALTER ROLLBACK SEGMENT RB_SEG_NAME_11$ OFFLINE;

1. How do i solve my issue with the Rollback segment being too small to contain the snapshot with the requested SCN?

2. what does the parameter UNDO_MANAGEMENT mean? should i change it, in order to adjust my Rollback Segments attributes, to prevent my error of re-occurring?

View 10 Replies View Related

Server Administration :: Segment Space Management Is Auto?

Oct 18, 2010

the syntax to make a tablespace's segment space mnagement auto which is segement management is *manual* and exent management is *local autoallocate*.

View 2 Replies View Related

Backup & Recovery :: Block Corruption In System Datafile?

Dec 25, 2011

I have noticed a block corruption issue in my RAC database. Its an index , how to recover a corrupted index in system datafile.

SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents WHERE file_id = 5
3 and 147551 between block_id AND block_id + blocks - 1;
TABLESPACE_NAME SEGMENT_TYPE OWNER

[code]....

We are using OCFS2 and O/S is RHEL 4.7.

View 3 Replies View Related

Server Administration :: Deferred Segment Creation - Default True?

Jan 20, 2010

What do you think of this 11.2 parameter? It can give some pretty weird results.

SQL> create tablespace ts1 datafile size 10m;
Tablespace created.
SQL> create table t1 (c1 date) tablespace ts1;
Table created.
SQL> drop tablespace ts1;
Tablespace dropped.
SQL> insert into t1 values(sysdate);
insert into t1 values(sysdate)

[code]...

View 5 Replies View Related

Backup & Recovery :: Ora-01578 - Oracle Data Block Corruption

Jun 24, 2013

We are facing block corruption error and it's refer to system datafile (SYSTEM01.DBF).Below is the script through it, we can come to know about the extent.

select segment_name, segment_type from dba_extents
where file_id=1 and 134144 between block_id and block_id+blocks-1;

select owner,index_name,index_type, table_name from dba_indexes
where index_name='I_CDEF3';

How to resolve the problem as it is related to system datafile? We tried to drop the index but system is not allowing to do.

ORA-00701 - object necessary for warmstarting database cannot be altered.

View 7 Replies View Related

Server Administration :: ORA-01652 - Unable To Extend Temp Segment By 128 In Tablespace DATA_01

Mar 10, 2012

When i try to create a duplicate table from an existing table i get error.

SQL> create table COMP_TEMP as select * from COMPETITIVE;
create table COMP_TEMP as select * from COMPETITIVE
*
ERROR at line 1:
ORA-01652: unable to extend temp segment by 128 in tablespace DATA_01
The table size is 15 gb.

Currently the tablespace has 2GB free space. If i need to increase the size of the tablespace DATA_01,how much space is required.

View 9 Replies View Related

Server Administration :: ORA-01658 / Unable To Create INITIAL Extent For Segment In Tablespace?

Aug 11, 2011

I have executed the below statement to move a bulk of table from source table space-SHOP3_DATA to destination tablespace -LINUX_CATA. Before executing the statement the source table space was having 85% full message . While executing the statement this is giving the error for the source tablespace means the the tablespace is getting consumed in the source TS. Currently no-one is using the tablespace SHOP3_DATA' . If I add datafile to the SHOP3_DATA the problem may be solved but why the space is getting consumed in the source. Now the tablespace SHOP3_DATA is 95% full

SQL> alter table LINUX_CATA.TST_FOLDERS move tablespace LINUX_CATA;
Table altered.
SQL> alter table LINUX_CATA.TST_SEARCH_TESTS move tablespace LINUX_CATA;
alter table LINUX_CATA.TST_SEARCH_TESTS move tablespace LINUX_CATA
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment in tablespace SHOP3_DATA

[code]....

View 10 Replies View Related

Backup & Recovery :: Logical Block Corruption - Recreate SYSMAN Schema Index

Mar 3, 2010

I am facing problem of logical block curruption.

SQL> select * from v$database_block_corruption;

FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
3 61454 1 1417157166 LOGICAL
3 31256 1 1417011117 LOGICAL

OWNER CONSTRAINT_NAME C TABLE_NAME
------------------------------ ------------------------------ - ------------------------------
SYSMAN MGMT_METRICS_RAW_PK P MGMT_METRICS_RAW

Can i recreate the SYSMAN schema index by dropping this one?

View 17 Replies View Related

Server Administration :: System View Cannot Found

Feb 22, 2012

There are some sys views can not found. why?

SQL> connect / as sysdba
Connected.
SQL> show user;
USER is "SYS"
SQL> desc dba_users;
ERROR:
ORA-04043: object dba_users does not exist

View 2 Replies View Related

Server Administration :: Listener Log - No Appropriate Service Handler Found?

May 22, 2012

On last Saturday we encountered error 'TNS-12519: TNS:no appropriate service handler found" in our listener log for some moment of time let say around 5mins and later it got all right itself.

View 3 Replies View Related

Server Administration :: ORA-19821 / Intentionally Corrupt Log File Was Found

Aug 15, 2011

don't know if I can repeat it. It occured while converting a database to archivelog mode, after completing a Data Pump export/import upgrade from 11.1.0.7. I fixed it like this: juno> startup mount;

ORACLE instance started.

Total System Global Area 1.7108E+10 bytes
Fixed Size 2175440 bytes
Variable Size 8858373680 bytes
Database Buffers 8220835840 bytes
Redo Buffers 26886144 bytes
Database mounted.

juno> alter database archivelog; alter database archivelog

ERROR at line 1: ORA-19821: an intentionally corrupt log file was found

juno> recover database until cancel; Media recovery complete.

juno> alter database open resetlogs;
Database altered.
juno> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
juno> startup mount;
ORACLE instance started.
[code]...

View 2 Replies View Related

Server Administration :: How To Repair Blocks That Gets Corrupted Found In Dbverify

Aug 8, 2013

how to repair the blocks that gets corrupted found in dbverify

View 8 Replies View Related

Server Administration :: ORA-02291 / Integrity Constraint Violated - Parent Key Not Found

Oct 13, 2010

I have Oracle 9i and yesterday I wanted to create new DB(datebase) but I couldn't did it.

In Database Configuration Assistant chose Create database then New database. Used configuration by default. On 92% I got this error

Quote:ORA-02291: integrity constraint (SH. COSTS_PRODUCT_FK) violated - parent key not found

View 2 Replies View Related

Server Administration :: Location Of A DB Block?

Feb 7, 2011

) How to find out, whether my Query return the output from the block of BUFFER CACHE or from DATAFILES?

2) How to calculate the no of data blocks were used to return a single output.

View 2 Replies View Related

Server Administration :: Non Standard Block Size

Aug 15, 2011

I am using oracle 10g with sga_max_size =4GB and db block size 16k. Now i am creating a tablespace with block size 32 kb , whats value i select for the parameter db_32k_cache_size.

Is there any standard way to calculate the value of this parameter.

View 4 Replies View Related

Server Administration :: How To Get Number Of Empty Block

Mar 31, 2012

①SQL> SELECT OBJECT_ID FROM DBA_OBJECTS WHERE OBJECT_NAME='T2012';
OBJECT_ID
---------
57082

②SQL> SELECT HEADER_BLOCK,BLOCKS FROM DBA_SEGMENTS WHERE SEGMENT_NAME = 'T2012';
HEADER_BLOCK BLOCKS
------------- --------
683 8

③SQL> SELECT DBMS_ROWID.rowid_block_number(ROWID)USED_BLOCK_NUMBER FROM SCOTT.T2012;
USED_BLOCK_NUMBER
----------------
684

④SQL> SHUTDOWN IMMEDIATE;

⑤SQL> STARTUP;

⑥SQL> SELECT BLOCK#,CLASS# FROM V$BH WHERE OBJD = '57082';
no data found

⑦SQL> SELECT * FROM SCOTT.T2012;
ID
-----
1

⑧SQL> SELECT BLOCK#,CLASS# FROM V$BH WHERE OBJD='57082';
BLOCK# CLASS#
------- ----------
686 1
684 1
687 1
685 1
688 1
683 4

⑨SQL> SELECT EMPTY_BLOCKS FROM DBA_TABLES WHERE TABLE_NAME='T2012';
EMPTY_BLOCKS
------------
3

QUESTIONS ONE:
in the ⑧ step,why block#685,block#686,block#687,block#688 in the buffer cache after i query data from scott.T2012?

QUESTIONS TWO:
in the ⑨ step,what's the block number of the empty block?just like DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID).

View 2 Replies View Related

Server Administration :: Calculate Used Space In A Block

Nov 17, 2011

Is there any way I can calculate percentage of space used in a block.Eg if a table size is 100 blocks,How Can I check the percentage of used space in block.

View 6 Replies View Related

Server Administration :: How To Know Which Block Contains Free Space

Feb 26, 2013

for some reason,i want to know which data block contains free space,or which table/index contains free space.

View 6 Replies View Related

SQL & PL/SQL :: No Data Found Stops The Loop Action Inside Block?

Jul 1, 2013

I am trying to create an anonymous PL/SQL block to output privilege information for each of the users listed in DBA_USERS In a loop. This is my block so far (not finished):

declare
v_usr varchar2(30);
v_out_header varchar2(100);

[Code]....

The output is as follows:

***User-Role Privilege report***
-----------------------------------
username: ANDREY , profile: DEFAULT
SYSTEM privileges granted directly to the user(not through ROLE) :
no_data_found

A problem I am encountering is that for some users I have no direct privileges that are not granted through roles, And when I have the expression v_qry (which is basically "'select grantee ||'',''|| privilege from DBA_SYS_PRIVS where grantee not in (select role from dba_roles) and grantee ='||'''' ||v_usr||''''") not initialized with values because the select statement retrieved 0 results, I have the process interfered by the no_data_found error/exception.

Questions: how I can preferrably simply, avoid/overcome my problem? Some way to make the loop go on in spite of no data found? maybe something similar to NVL?

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved