Q

Problem solve

ORA-01113 and ORA-01110 errors on restarting database

I experienced an error(ORA-01033) that was posted here before. I follwed the instructions that were in the posting:

    sqlplus /nolog
    shutdown abort
    startup

But after I started it up there were errors. I got ORA-01113 and ORA-01110 stating that the file needs media recovery. Please help.

The ORA-1113 error is telling you that you need to apply recovery to the database. The ORA-1110 message is telling you which file needs recovery. Since the database was up and running, and you just did a SHUTDOWN ABORT, all you should need to do is force Oracle to apply recovery. Instead of STARTUP, issue "STARTUP MOUNT" followed by "RECOVER DATABASE;". Once recovery is complete, issue "ALTER DATABASE OPEN;".

This was last published in November 2004

Dig Deeper on Oracle error messages

All
Evaluate
Manage
Problem Solve

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

Start the conversation

Send me notifications when other members comment.

-ADS BY GOOGLE

SearchDataManagement

11 real-time data streaming roadblocks and how to overcome them

Experts detail common challenges that IT teams encounter when deploying and managing real-time data streaming platforms and offer...
Snowflake product VP expounds on data warehouse for the cloud

In this Q&A, Christian Kleinerman, vice president of product development at cloud data warehouse vendor Snowflake, talks about ...
RavenDB Cloud automates database management

RavenDB's managed cloud database service, RavenDB Cloud, intends to automate security processes, reduce overhead and cater to ...

SearchBusinessAnalytics

Updated AtScale platform streamlines analysis of big data

By improving the machine learning and augmented intelligence capabilities of its platform, AtScale's newest release attempts to ...
ThoughtSpot strategic partnerships help add capabilities

Through its partnership strategy, ThoughtSpot is adding to its capabilities as a BI software vendor the same way others are ...
IBM battling to change perception of Cognos Analytics BI platform

While some see IBM's BI suite as being too complicated and expensive for citizen data scientists, the company is adding updates ...

SearchSAP

As SaaS ERP, S/4HANA Cloud not meant to replicate ECC

In a Q&A, Jan Gilg, SAP's new global head of S/4HANA, joined SVP Sven Denecken to explain the differences between the on-premises...
SAP Leonardo technologies seek to empower the digital enterprise

Learn the fundamentals of Leonardo, how it has evolved over the years and key steps to using its advanced technologies to build a...
SAP PartnerEdge initiative offers free S/4HANA Cloud resources

SAP now offers free access to S/4HANA and C/4HANA test and demonstration systems to qualified partners. The new partner program ...

SearchSQLServer

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...
How SQL Server DevOps processes help break down data silos

DevOps can help organizations dismantle data silos in SQL Server and other database systems -- and replace organizational silos ...
Key features to create a SQL Server audit trail in databases

SQL Server offers a set of built-in auditing tools that can help make the process of tracking logins and other database ...

TheServerSide.com

Weigh cost, flexibility in your Java cloud IDE comparisons

What's in a cloud IDE for Java developers? Flexibility and integration for starters. Consider these four options in your ...
What are the differences between EAR, JAR and WAR files?

JAR, WAR and EAR files provide options in a Java application deployment. Let's compare these file types and determine which one ...
4 great Java-based CMS options

Open source Java CMS tools come in a wide variety of shapes and sizes. Explore these four platforms to see if they would be a ...

SearchDataCenter

3 ways to benefit from open source infrastructure

Using open source infrastructure can reduce operating costs and streamline upgrades, but it's important to weigh the pros and ...
IBM mainframes face competitive pressures inside and out

IBM's mainframe business continues to be under pressure from cloud-based competitors, and perhaps even its own Power server. ...
Linux features beyond server management

Due to its open source nature, Linux is constantly gaining new capabilities. Here's a look at some common use cases and features.

SearchContentManagement

Alfresco cloud migration service moves content off premises

With new cloud migration services, Alfresco promises to move content from IBM, SharePoint, Documentum and other legacy ECM ...
Using AI in content creation can streamline publishing

Companies using AI in content creation can generate short-form material automatically, which frees up humans to handle more ...
New Contentful CMS targets content delivery for retailers

Contentful's content infrastructure is a CMS that intends to bring more flexibility and benefits than a traditional or headless ...

SearchHRSoftware

Eliminating bias in AI is no easy feat, but fixes do exist

As more companies turn to AI to reduce workplace and recruiting bias, it is important to be aware that the data AI tools draw ...
Immigrant visa reform poised to complicate hiring plans

Legislators plan to act on a bill that will remove per-country caps for immigrant workers, making it more difficult for companies...
Continuous performance management comes with benefits, drawbacks

Many companies are ditching yearly performance reviews in favor of continuous performance management. The new method has its ...

Close