Sitemap

Amicuk Programming Answers

Restore Oracle XE database to another machine

2015-10-11   Views:3

Advertisement

I have an oracle XE database on a Windows XP machine, and I want to copy it to a Windows 7 machine. On the XP, I performed a backup through the "Backup Database" from the GUI (BACKUP.BAT). The Oracle backup created 3 new folders underneath C:\OR

I have an oracle XE database on a Windows XP machine, and I want to copy it to a Windows 7 machine.
On the XP, I performed a backup through the "Backup Database" from the GUI (BACKUP.BAT). The Oracle backup created 3 new folders underneath C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\
ARCHIVELOG
AUTOBACKUP
BACKUPSET
I installed XE on the Windows 7 machine and it seems to work well.
Then I coped the 3 backup folders onto a jump drive and put them in the corresponding folder structure on the new Windows 7 machine. I ran the Restore from the GUI as an administrator (RESTORE.BAT). The restore failed, and I can't seem to figure out why. I'm not sure what the Sequence Numbers are all about.
Now I can't get into Apex or Apex_Admin
Thanks for taking a look at this.
The contents of the OXE_RESTORE file are as follows:
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jan 8 18:33:11 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Windows NT Version V6.1
CPU : 8 - type 586, 4 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:6031M/8183M, Ph+PgF:13737M/16364M, VA:1973M/2047M
Starting with debugging turned off
connected to target database: xe (not mounted)
RMAN> set echo on;
2> restore (spfile from autobackup db_recovery_file_dest='C:\oraclexe\app\oracle\flash_recovery_area\');
3> startup nomount force;
4> restore (controlfile from autobackup);
5> alter database mount;
6> configure controlfile autobackup off;
7> restore database;
8>
echo set on
Starting restore at 08-JAN-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=37 devtype=DISK
recovery area destination: C:\oraclexe\app\oracle\flash_recovery_area\
database name (or database unique name) used for search: XE
channel ORA_DISK_1: autobackup found in the recovery area
channel ORA_DISK_1: autobackup found: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\AUTOBACKUP\2011_01_07\O1_MF_S_739828107_6LHF2W3X_.BKP
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 08-JAN-11
Oracle instance started
Total System Global Area 805306368 bytes
Fixed Size 1289996 bytes
Variable Size 239075572 bytes
Database Buffers 562036736 bytes
Redo Buffers 2904064 bytes
Starting restore at 08-JAN-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=36 devtype=DISK
recovery area destination: C:\oraclexe\app\oracle\flash_recovery_area
database name (or database unique name) used for search: XE
channel ORA_DISK_1: autobackup found in the recovery area
channel ORA_DISK_1: autobackup found: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\AUTOBACKUP\2011_01_07\O1_MF_S_739828107_6LHF2W3X_.BKP
channel ORA_DISK_1: control file restore from autobackup complete
output filename=C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
Finished restore at 08-JAN-11
database mounted
released channel: ORA_DISK_1
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters are successfully stored
Starting restore at 08-JAN-11
Starting implicit crosscheck backup at 08-JAN-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=35 devtype=DISK
Crosschecked 1 objects
Finished implicit crosscheck backup at 08-JAN-11
Starting implicit crosscheck copy at 08-JAN-11
using channel ORA_DISK_1
Finished implicit crosscheck copy at 08-JAN-11
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ARCHIVELOG\2011_01_07\O1_MF_1_375_6LHF31CQ_.ARC
File Name: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ARCHIVELOG\2011_01_07\O1_MF_1_376_6LHF3DCQ_.ARC
File Name: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\AUTOBACKUP\2011_01_07\O1_MF_S_739828107_6LHF2W3X_.BKP
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF
restoring datafile 00002 to C:\ORACLEXE\ORADATA\XE\UNDO.DBF
restoring datafile 00003 to C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF
restoring datafile 00004 to C:\ORACLEXE\ORADATA\XE\USERS.DBF
restoring datafile 00005 to C:\ORACLEXE\ORADATA\XE\APEX_1244616068553754.DBF
channel ORA_DISK_1: reading from backup piece C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\BACKUPSET\2011_01_07\O1_MF_NNNDF_TAG20110107T194642_6LHDZM3X_.BKP
channel ORA_DISK_1: restored backup piece 1
piece handle=C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\BACKUPSET\2011_01_07\O1_MF_NNNDF_TAG20110107T194642_6LHDZM3X_.BKP tag=TAG20110107T194642
channel ORA_DISK_1: restore complete, elapsed time: 00:00:56
Finished restore at 08-JAN-11
Recovery Manager complete.
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jan 8 18:34:37 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Windows NT Version V6.1
CPU : 8 - type 586, 4 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:6021M/8183M, Ph+PgF:13238M/16364M, VA:1973M/2047M
Starting with debugging turned off
connected to target database: XE (DBID=2604800077, not open)
RMAN> set echo on;
2> recover database;
3> alter database open resetlogs;
4>
echo set on
Starting recover at 08-JAN-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=38 devtype=DISK
starting media recovery
archive log thread 1 sequence 375 is already on disk as file C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ARCHIVELOG\2011_01_07\O1_MF_1_375_6LHF31CQ_.ARC
archive log thread 1 sequence 376 is already on disk as file C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ARCHIVELOG\2011_01_07\O1_MF_1_376_6LHF3DCQ_.ARC
archive log filename=C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ARCHIVELOG\2011_01_07\O1_MF_1_375_6LHF31CQ_.ARC thread=1 sequence=375
archive log filename=C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ARCHIVELOG\2011_01_07\O1_MF_1_376_6LHF3DCQ_.ARC thread=1 sequence=376
unable to find archive log
archive log thread=1 sequence=377
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/08/2011 18:34:47
RMAN-20000: abnormal termination of job step
RMAN-06054: media recovery requesting unknown log: thread 1 seq 377 lowscn 11715842
Recovery Manager complete.

The replay answer
Advertisement
After playing around a little bit I fixed the problem.
There are a total of four folders in \FLASH_RECOVERY_AREA\XE\ I had only copied three of the four.
ARCHIVELOG
AUTOBACKUP
BACKUPSET
The Windows services keep the files in ONLINELOG open, so I had to shut down the services and then work with the folder. Therefore four folders have to be transported and copied onto the new machine:
ARCHIVELOG
AUTOBACKUP
BACKUPSET
ONLINELOG
If you run as an administrator "Backup" from the GUI, it executes BACKUP.BAT, a batch file which calls RMAN. Once that's done, copy the four folders to the same location on the target machine and then run as an administrator "Restore" (RESTORE.BAT).
In another forum someone said to be sure that the "Archive Logs" are copied. It should be interpreted to mean not just the "ARCHIVELOG" folder, but all four folders.
Edited by: PhilMan2 on Jan 11, 2011 11:28 AM

Go to See the other 2 answers

Restore Oracle XE database to another machine

Category:DefaultRelease time:2015-10-11Views:130

I have an oracle XE database on a Windows XP machine, and I want to copy it to a Windows 7 machine. On the XP, I performed a backup through the "Backup Database" from the GUI (BACKUP.BAT). The Oracle backup created 3 new folders underneath C:\OR[More]

How to migrate data from oracle 9i database to new machine 11gr2 RAC ASM

Category:DefaultRelease time:2015-10-11Views:130

Hi Expert I need your expertise to advise me what is the best method to move data from oracle 9i database to new machine running oracle 11r2 RAC database with ASM. Currently my production server running on HPUX ORACLE 9I database with normal file sys[More]

Restore Oracle XE 10g Database to another machine

Category:DefaultRelease time:2015-10-11Views:130

Hello, I have an oracle XE database on a Windows XP machine, and I want to copy it to a Windows 7 machine. On the XP, I performed a backup through the "Backup Database" from the GUI. The Oracle backup created 3 new folders underneath C:\ORACLEXE[More]

Backing up and Restoring/Recovering an Oracle 9i Database

Category:DefaultRelease time:2015-10-11Views:130

I am fairly new at this and have been tasked with managing off site backups for customer data on a 9i database. I am carrying out a user managed backup of the following data files to the offsite data centre. User File USERS01.DBF Control File CONTROL[More]

Hot
Does anyone know why iTunes is delivered in French on my new iPod Touch and how I can change to English UK? It is soooooooooo frustrating?Yes, that is unfortunate! Simply click settings - the cogs. Labelled regalez or something in french probably. Th [More]
hi, may i know why need to use F.13 to clear the GR and IR clearing account? why same clearing account in GR and IR not able to be cleared automatically when do miro? thanksHi We use F.13 because, This process matches goods receipt and invoice receip [More]
This is my first time working with Java and databases so I'm very green. I need to read a delimited .txt file in (I know how to do this), separate the text by delimiters (I know how), open the connection to database (don't know), write to database ta [More]
My wife and I share a MacBook Pro, and just now decided to have seperate users accounts on the computer.  I have files saved under her user name, how do I copy them over to my user account?Transferring files from one User Account to another StefanRea [More]
Hello I back up all my images well on my MBP but  the videos don't appear on Iphoto. I need  to delete to liberate space but I can't find the videos. What is the problem? Thanks OIs your phone recognized in iTunes on your MBP? Maybe check this articl [More]
Hi Experts, I have an error in SLG1 coming from web dynpro application ERC_A_DEL_EXT_CAND I am not sure how to debug this issue.  Where do I put the breakpoint to get the debugger to launch? Thanks in advance. ShaneHi, Here is the error: The error oc [More]
Hi, I have an ear file. I am not getting any error when I deploy on one server but the same ear file when I deploy on other server, I am getting following error. Can anyone help me on this please [2009-08-17 11:24:11,525] [main] ERROR - Parse Error a [More]
I loaded the FlexSQLadmin sample into Builder. When I click the green "run"button, I get a "Windows - No Disk" popup with the message "There is no disk in the drive. Plese insert a disk into drive." Any ideas? I re-installed [More]
Hi,      I've Macbook Air connected to office network through Wifi. My Office printer such as Canon IR C4080 and Ricoh Africo SP C242DN are not responding after Maverick upgraded. I tried to install new driver but still not working. Do you have any i [More]
I have Windows 7 64 bit OS running on an Acer Adspire 5740.  Despite reinstalling the Officejet G85 driver a couple of times it only recognises it as a scanner and fax, so I cannot use it as a printer.  If I try to download a printer driver it tells [More]