Back to jobs

Oracle 11g XE recovery — ORA-00333 corrupt redo log, need schema export

Search - MySQL · local_filter_skipped · UID ~022085119024943401017

Open Job

Job Details

Budget $20.00 - $58.00/hr
ExperienceIntermediate
DurationUnknown
Weekly hoursUnknown
Client countryUnknown
ProposalsUnknown
InterviewingUnknown
Invites sentUnknown
First seenThu, Aug 6, 2026 2:57 PM
Last seenThu, Aug 6, 2026 2:57 PM

Description

Oracle 11g Express Edition 11.2.0.2.0 on Windows 7, NOARCHIVELOG, no backups predating the failure. Power loss corrupted the current online redo log mid-write. Crash recovery aborts during redo scan with ORA-00333 (block 20417 count 7083). Confirmed so far: All 4 datafiles ONLINE, matching checkpoint_change# 160559489, all FUZZY=YES v$recover_file returns no rows ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1 → ORA-01624 (log needed for crash recovery) RECOVER DATABASE UNTIL CANCEL → CANCEL → ORA-01547, ORA-01194 file 1 needs more recovery Goal: get the database open by whatever means, then Data Pump export one schema (LOGO). We accept data loss from the last redo log. Full cold backup of oradata, FRA, and dbs is in hand — work will be done on a copy. Access via TeamViewer, you drive. Need a fixed price and an estimated duration.

Skills

SQL Oracle Database Administration Database Programming Oracle Database Database +1

Notification History

ChannelTypeStatusSentError
No notifications.

User Actions

ActionActed at
No actions.