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 -> Re: backup and recovery question

Re: backup and recovery question

From: <kal121_at_my-deja.com>
Date: 2000/05/17
Message-ID: <8fun1f$m01$1@nnrp1.deja.com>#1/1

Oops I figured it out.

Copy files to /u02
Startup mount exclusive
Rename the datafiles
Open database
viola

In article <8fum2m$kkg$1_at_nnrp1.deja.com>,   kal121_at_my-deja.com wrote:
> I have a basic backup and recovery question. Right now I am
 practicing,
> this is not a real scenario:
>
> Let's say my hard drive gets destroyed. Fortunately, I made a cold
> backup in noarchivemode the day before. Problem is, I have to put my
> backed-up datafiles in a new location, say /u02 instead of /u01. The
> backed-up control files only know about the old datafile locations,
> i.e.) /u01. How do I tell my backed-up copy of the control file about
> the new locations of the datafiles? Unless it knows about the new
> location, it can't open the database.
>
> (And obviously, I wouldn't put all my datafiles on /u01, but I'm
 trying
> to keep it simple.)
>
> Sorry is this a basic question for you all!
>
> Thanks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed May 17 2000 - 00:00:00 CDT

Original text of this message

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