Data Block corrupted
Received the following error when application trying to execute procedure from sqlPlus.
BEGIN
recon.rec_controller.perfo
END;
/
-- **************************
ORA-20900: ORA-20900: ORA-20101: Error in REC_controller.start_recon
ORA-01110: data file 49: '/u47/oradata/DRECS06/reco
ORA-26040: Data block was loaded using the NOLOGGING option
-- **************************
Receiving folloing errors on alert log.
Wed Jul 23 02:00:01 2008
ORA-20001: Block change tracking has been disabled
Regards
Sachin
BEGIN
recon.rec_controller.perfo
END;
/
-- **************************
ORA-20900: ORA-20900: ORA-20101: Error in REC_controller.start_recon
ORA-01110: data file 49: '/u47/oradata/DRECS06/reco
ORA-26040: Data block was loaded using the NOLOGGING option
-- **************************
Receiving folloing errors on alert log.
Wed Jul 23 02:00:01 2008
ORA-20001: Block change tracking has been disabled
Regards
Sachin
Last Comment
peter991
Is there any tracefile created when this happens?
select owner, segment_name, segment_type from dba_extents
where file_id = 42 and 12071 between block_id and block_id + blocks -1;
if the segment is the index, for example then you just need drop it and re-create it again.
or if it is a table then move to another tablespace
where file_id = 42 and 12071 between block_id and block_id + blocks -1;
if the segment is the index, for example then you just need drop it and re-create it again.
or if it is a table then move to another tablespace
Or have rman repair it.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I didn't even notice the 26040. My suggestion will do you no good here :)
Oracle Database
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
