Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> restore database

restore database

From: Adas <a_at_a.com>
Date: Tue, 18 May 2004 15:20:03 +0200
Message-ID: <c8d2i2$37e$1@news.onet.pl>


Hi all

I have files from Oracle database (8.1.6.3) from AIX. This is:

    control0x.ctl
    *.dbf

Is it possible to restore this files to Oracle on Windows XP running any other version of Oracle Database when backup was made as copy of dabatase files.
Is following errors caused by version difference ? I tried to restore it to 10.1

When I tried to make restore i got following error:

Error in Restoring Control File
Recovery Manager: Release 10.1.0.2.0 - Production Copyright (c) 1995, 2004, Oracle. All rights reserved. RMAN> connected to target database: orcl (not mounted) using target database controlfile instead of recovery catalog RMAN> executing command: SET CONTROLFILE AUTOBACKUP FORMAT RMAN> 2> 3> 4> allocated channel: oem_restore channel oem_restore: sid=160 devtype=DISK Starting restore at 04/05/18 recovery area destination: C:\oracle\product\10.1.0\flash_recovery_area database name (or lock name space) used for search: ORCL channel oem_restore: no autobackups found in the recovery area autobackup search outside recovery area not attempted because DBID was not set released channel: oem_restore RMAN-00571:
=========================================================== RMAN-00569:
=============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571:
=========================================================== RMAN-03002:
failure of restore command at 05/18/2004 15:16:53 RMAN-06172: no autobackup found or specified handle is not a valid copy or piece RMAN> Oracle instance shut down RMAN> connected to target database (not started) Oracle instance started database mounted Total System Global Area 171966464 bytes Fixed Size 787988 bytes Variable Size 145750508 bytes Database Buffers 25165824 bytes Redo Buffers 262144 bytes RMAN> Recovery Manager complete.

Please help

Adam Received on Tue May 18 2004 - 08:20:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US