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: Sanjeev Sagar <sanjeevsagar_at_hotmail.com>
Date: Mon, 16 Aug 1999 10:07:28 -0500
Message-ID: <37B8292F.1DD9400C@hotmail.com>

Alex, It's a bug only on solaris with Oracle 8.0.5 It's resolved in 8.0.5.1 which i did. Now it's working fine. Can you verify my another question about creation of tablespaces with raw devices. Let me explain it once again.

I have a raw device like '/dev/c0t0d0r1' i created link to that raw device like '/ix/ora_system.dbf'

When i create the tablespace it's giving me error that file exists. So i used the keyword 'REUSE'. It worked fine. IS it a right way to configure raw with Oracle or there are some other way?

I will highly appreciate you for the same.

Alex Hudghton wrote:

> 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 Mon Aug 16 1999 - 10:07:28 CDT

Original text of this message

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