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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.0.5 RMAN restore problem

Re: Oracle 8.0.5 RMAN restore problem

From: Alex Hudghton <alex_at_alenda.freeserve.co.uk>
Date: Wed, 11 Aug 1999 09:31:47 +0100
Message-ID: <7orcdl$n4$1@taliesin.netcom.net.uk>

Sanjeev Sagar wrote in message <37B0A838.BA0B8CA7_at_hotmail.com>...
>
>Hello ALL,
>
>Environmnet : Oracle 8.0.5 on Solaris 2.6 [no parallel options or
>partition]
>
>First, I am using raw devices for all the tablespaces. Correct me if i
>am wrong
>
>I used "reuse" option while i created my tablespaces b'coz i am using
>links to my physical devices which will be always there. If i do not use
>"reuse" opting while creating tablespace, it comes out with error that
>device name exists. I am not very expert hand in oracle, so i just want
>to make sure that i am hitting the right way.
>
>The main problem is :
>
>I am using RMAN for my backup and restore. I am taking all the backup on
>disk. Backup worked fine. I am facing error during restore
>
>restore database - It came out with the error that data file exists.
>
>Q : How can i tell RMAN to overlaid existing data files without abort.
>
>I did check all the documentation for RMAN but it does not talk about
>that. It talk about how to replace the location of data files by using
>set command but it does not talk about how to overlaid the existing data
>files.

We are using raw filesystems for our databases and have never come across this problem - in fact the opposite - Oracle will overwrite datafiles with no error message at all. What is the error message you are getting on restore ?

Alex Received on Wed Aug 11 1999 - 03:31:47 CDT

Original text of this message

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