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 -> Oracle 8.0.5 RMAN restore problem

Oracle 8.0.5 RMAN restore problem

From: Sanjeev Sagar <sanjeevsagar_at_hotmail.com>
Date: Tue, 10 Aug 1999 17:31:20 -0500
Message-ID: <37B0A838.BA0B8CA7@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.

I will highly appreciate if anyone can help me out.

Thanks

Sanjeev K. Sagar Received on Tue Aug 10 1999 - 17:31:20 CDT

Original text of this message

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