Solved

Oracle XE restore problem

Posted on 2011-02-14
11
665 Views
Last Modified: 2012-05-11
Dear experts,

I have a server where oracle express was installed.
I was doing backups using rman and then zipping the flash_recovery_area and saving this file.
The server died and I am now trying to restore the databases.
I think the server was installed with Oracle XE 8i and I am trying to restore on Oracle XE 10i
I installed a new server with Oracle XE, unzipped my backup in the new flash_recovery_area and ran the restore script.
When I do that on linux, I receive :
    channel ORA_DISK_1: no autobackup in 7 days found
The output of the script on windows is attached to this message.
Is it the correct way to restore the database?
I can't find the Oracle XE 8i installation file. Could it be the reason why the restore is not working?
A link to download it would be greatly appreciated.
Do you have any idea why it is failing and how to solve the problem?
Many thanks

restore.txt
0
Comment
Question by:stermeau
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 2
11 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 250 total points
ID: 34888796
There is no such thing as XE 8i,

XE was introduced at 10gR2 and remains at 10gR2 as of today.

If you're trying to restore an 8i backup to 10g XE, you won't be able to.

You'll have to restore to your original 8i version, from there you can export and import into XE, provided your application is small enough (only 4Gb of data) and doesn't use any features that aren't supported in XE (like java)
0
 
LVL 5

Author Comment

by:stermeau
ID: 34888894
Thanks for your answer.
OCS was running on the server and in the software inventory it says that the version of Oracle was : Oracle Database 10g Express Edition       10.2.1015
Should I try to restore the backup on oracle 10g XE instead of Oracle 10i XE?
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 34888915
There is no 10i XE,  there is only 10g XE,  so yes,  use 10g XE
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
ID: 34888923
There is no 10i XE.

The error message from the report you posted talks about a 'bad' archived redo log file.  It might have been being copied over when you performed the ZIP and is incomplete.  You might need to recover until file.
0
 
LVL 5

Author Comment

by:stermeau
ID: 34888970
Indeed there is 10i XE, don't know where I got that. I am running 10g XE.
What do you mean by "recover until file"?
If a full restore is not possible because of the bad redo log, is it possible to do a partial restore?
0
 
LVL 5

Author Comment

by:stermeau
ID: 34888974
Please read "Indeed there is no 10i XE" in my previous post.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34889039
>>Indeed there is 10i XE, don't know where I got that.

Then you didn't get it from Oracle.  I'm with sdstuber, I've never seen  or heard of 10i XE.

>> is it possible to do a partial restore?

Yes.  Either cancel or log based.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/backrec.htm#sthref2365
0
 
LVL 5

Author Comment

by:stermeau
ID: 34889251
Here is an update:
I was able to use the database after the restore by using :
   alter database open resetlogs;

The database is working but I have lost 1 week of data.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34889311
>>The database is working but I have lost 1 week of data.

Glad it's up and running.  

Since you lost data can I suggest you take some time to solidify your disaster recovery procedures to make sure this this doesn't happen in the future.
0
 
LVL 5

Author Comment

by:stermeau
ID: 34889334
That's a good idea.
Any idea why the redo log file was corrupted?
I tested the backup/restore procedure some time ago bu I cannot test all the backups ...
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34889367
>>Any idea why the redo log file was corrupted?

From the error message it looks like your redo log file was in the process of being copied when you zipped it up.  Therefore the ZIP didn't contain a complete log file.

I would keep multiple copies around just for this reason.  Say you copy a 'partial' file tonight, tomorrows backup should copy a complete version of that file.  Then when you go to recover and see this message again, you just go to the next backup to recover a clean copy of that file.
0

Featured Post

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Many businesses neglect disaster recovery and treat it as an after-thought. I can tell you first hand that data will be lost, hard drives die, servers will be hacked, and careless (or malicious) employees can ruin your data.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question