Ora 01110 data file needs media recovery

Automatic archival Enabled. Oldest online log sequence 2. Next log sequence to archive 4. Current log sequence 4. Make some transactions inorder to generate archive logs. Table created. ORA error in opening database file 1. ORA unable to open file. Additional information: 3.

Total System Global Area bytes. Fixed Size bytes. Variable Size bytes. Database Buffers bytes. Redo Buffers bytes. Database mounted. ORA database not open. Database dismounted. Restore the system Create a free Team What is Teams?

Learn more. Asked 10 years, 4 months ago. Active 1 month ago. Viewed 45k times. What can I do? I cant restart database Improve this question. Derek Downey Add a comment. Active Oldest Votes. Improve this answer. Please ask the "one more question" in the body of your question in stead of in your answer or possibly as a new question if you think that would work better! It will not wait until the other datafile s are full.

Uwe Hesse Uwe Hesse 1, 7 7 silver badges 4 4 bronze badges. I thought like that and fortunately did not delete that datafile If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page.

All rights reserved by Burleson. Karam Question: I get this error when starting my Oracle database. The Oracle docs note this on the ORA error: ORA file string needs media recovery Cause: An attempt was made to online or open a database with a file that is in need of media recovery.

Search BC Oracle Sites.