Database crash during hot backup

Our Oracle 8.0.4 database crashed while doing a hot backup with CA BrightStor. Now one of our databases will not start. Event viewer shows it starting and then shutting down again. Our dbaora7.log shows that all tables and control files associated with the affected database are in backup mode.

Brian Peasland

Published: 22 Aug 2005

Our Oracle 8.0.4 database crashed while doing a hot backup with CA BrightStor. Now one of our databases will not start. Event viewer shows it starting and then shutting down again. Our dbaora7.log shows that all tables and control files associated with the affected database are in backup mode.

I cannot start the database. Starting it via services produces the result above with the following error logged...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

in the ALRT.log:

ORA-1122 signalled during: alter database "cafe" open

Attempting to start the database via the svrmgr30 program produces the following errors:

LCC-00161: Message 161 not found; product=RDBMS80; facility=MGR
ORA-12203: TNS: unable to connect to destination

You'll have to start the instance manually and take the datafiles out of backup mode. Use these steps:

svrmgr30
connect internal
startup mount
alter database datafile '/directory/filename' end backup
Repeat step 4 for each and every datafile.
alter database open
shutdown immediate
Take a cold backup of your database.

You will not be able to open the database until all of your datafiles are out of backup mode. Once you have opened the database, you will want to take a backup of your database so that you will have a good clean backup to start from after recovery from this failure.

Dig Deeper on Oracle database backup and recovery

Which backup strategy should I use for my Oracle 10g database? Database Backup and Recovery expert Brian Peasland explains how multiple backup strategies exist to backup an Oracle database.

Missing datafile due to hard disk failure In Oracle 8i, one of the datafiles is missing due to a hard disk failure problem. Is it possible to drop the datafile which is missing without dropping the tablespace?

Datafiles on different backup disk from controlfile I need to restore the controlfiles and datafiles to a new location. I first restored the controlfile, but the datafiles are on the different backup disk. How can the controlfile know where to locate these datafiles?

Opening a database with a missing datafile Can you tell me the procedure to open a database that has a missing datafile because of deletion? The database is in noarchivelog mode, there's not any backup and the version is 10g Release 2.

Recovering lost datafile How can you recover a datafile which is lost and is not in your backup?

Command to open database with missing datafile Can you tell me the command(s) or procedure to open a database that has a missing datafile due to a media failure (external device)? The database is in noarchivelog mode, there's not any backup and the version is 10g Release 2. It doesn't matter if the data is lost or inaccesible, I just want at least to open the database.

Related Q&A from Brian Peasland

Managing Oracle connections from third-party apps

Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading

Perfect the Oracle RMAN duplicate 10g command

One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading

Managing SQL parent table-child table relations

Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading

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

SearchDataManagement

How AI could save the enterprise data catalog

Enterprise data catalogs record all the databases and files in a corporation, but sometimes it can become out of date. Advances ...

With Vitess 4.0, database vendor matures cloud-native platform

Scaling a MySQL database in the cloud is not easy, but the open source Vitess project manages the project at scale for ...

Managing unstructured data is crucial to enterprises' AI goals

Unstructured data makes up a huge portion of most businesses' data volume. But, with data-hungry AI systems coming online, making...

SearchBusinessAnalytics

Salesforce acquisition of Tableau finally getting real

With Salesforce and Tableau finally free to start integrating, Andrew Beers, Tableau's chief technology officer, talks about what...

Tableau analytics platform upgrades driven by user needs

In a Q&A, Tableau chief technology officer Andrew Beers talks about the driving factors behind recent product upgrades centered ...

Tableau or Qlik: What separates the data visualization tools?

While leading data visualization vendors Tableau and Qlik may seem similar, there are substantial differences. Understanding the ...

SearchSAP

How to use Qualtrics employee experience tool to gather feedback

SAP Qualtrics is meant to be a powerful employee experience tool. Discover its features, feedback software and which products are...

SAP partner program strives for long-term relationship with customers

In this Q&A, SAP chief partner officer Karl Fahrbach discusses why the company has evolved its partner program to reward customer...

SMBs focus on future with S/4HANA and SAP intelligent enterprise

Medical device startup Enable Injections is small now but intends to be big soon, so it's implementing SAP S/4HANA in phases to ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

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 ...

TheServerSide.com

Ideas on how to hold a successful code hackathon

Want to host a hackathon? Here are some ideas on what a company can do to host an event that solves problems and reenergizes the ...

A Jenkins tutorial for beginners with examples

If you're ready to try Jenkins, this quick start tutorial lays out the specific steps you'll need to take to download and install...

Why AI application development isn't as far away as you think

The distance between application development and AI development continues to narrow. Here's how to integrate AI into your app dev...

SearchDataCenter

Microsoft quantum development turns toward hardware

Microsoft revealed plans to jump into the quantum hardware business with a chip capable of running quantum software.

Top 5 options for Linux certifications

Are you ready to expand your Linux knowledge? Here's a look at the latest courses, training content and exams available from ...

New hardware, use cases shape server benchmarking needs

Advancements in server hardware help admins address the latest data-intensive use cases. But this brings questions about the ...

SearchContentManagement

Acquia cloud CMS on AWS, Vista cash flow raise user expectations

Acquia's new venture backing and customer experience cloud apps precipitate a need for easier integrations and setup for future ...

Adobe Sign introduces updates targeting mobile device users

The updates include a new home screen and a page for users to track the signing process, the ability to zoom and navigation ...

Acquia, Drupal founder Dries Buytaert on open source, Vista, CDPs

Acquia and Drupal founder Dries Buytaert discusses his company's move into marketing automation, CDPs and what's next after Vista...

SearchHRSoftware

Discover the key elements of talent management systems

Discover the four components of talent management systems: recruiting, performance management, corporate learning and ...

Kronos introduces its latest time clock, Kronos InTouch DX

The newly launched time clock integrates with Workforce Dimensions, Kronos' workforce management suite, providing real-time ...

HRIS department an essential bridge between HR, IT

Emerson Electric's VP of HRIS explains why it's important to have a team that can translate HR needs into the black and white of ...

Dig Deeper on Oracle database backup and recovery

Related Q&A from Brian Peasland

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.