Q

Transporting a database with no archive or backup

Our Oracle 8.0.5.2 sys1orcl.ora file is destructed, but the database works on one computer. We just want to transport the database to another computer. How can we recover it? No archive or backup is available.

Our Oracle 8.0.5.2 sys1orcl.ora file is destructed, but the database works on one computer. We just want to transport the database to another computer. How can we recover it? No archive or backup is available.
Sorry, but if you do not have a backup of the datafile for the SYSTEM tablespace, you will not be able to copy the entire database to another server. About the best that you can hope for is to open up your database and pray that it only needs instance recovery, in which case you can shut down the database and take a good backup of it. See if the following steps work:

  1. svrmgrl (or svrmgr30)
  2. connect internal
  3. startup mount
  4. alter database recover;
  5. alter database open;

If the database opens, you are fine. If the database does not open, then you have lost your database because you do not have a solid backup.

This was last published in August 2005

Dig Deeper on Oracle database backup and recovery

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

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

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close