I will say this much... working with Oracle has proved to be a humbling
experience..
I forgot to check v$datafile view to see what I was trying to rename.

Thanks for the help anyway!

-----Original Message-----
From: Nelson, Paula [mailto:Paula.[Email Address Removed] Monday, June 30, 2003 9:21 AM
To: LazyDBA.com Discussion
Subject: RE: Standby problem


Is there a command to rename the datafile referencing the datafile number
instead of the datafile name?

-----Original Message-----
From: Nelson, Paula
Sent: Monday, June 30, 2003 9:17 AM
To: 'Ankur Shah'; LazyDBA.com Discussion; Nelson, Paula
Subject: RE: Standby problem


I have that. All datafiles are in place already from a coldbackup.

-----Original Message-----
From: Ankur Shah [mailto:[Email Address Removed] Monday, June 30, 2003 9:15 AM
To: LazyDBA.com Discussion; Nelson, Paula
Subject: Re: Standby problem


U need to have a physical OS file created ahead of that

> create a emty file on the folder - writable by Oracle

========================

HTHU

Ankur Shah
Oracle DBA
DHR-GA


----- Original Message -----
From: "Nelson, Paula" <Paula.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Monday, June 30, 2003 12:08 PM
Subject: Standby problem


> Hi Gurus,
>
> I am creating a standby database for one of our off-site databases. I
need
> to change the drive designation for the datafiles on the standby database
> because the server has a different configuration than their primary. I
was
> successful in doing this before by use 'alter database rename file
> <e:\oldfile> to <d:\newfile>' command.
>
> This time I am getting the folowing:
>
> ORA-01511: error in renaming log/data files
> ORA-01516: nonexistent log file, datafile or tempfile
> 'E:\ORADATA\sid\SYSTEM\SYS01.DBF'
>
> I will not be able to recover the standby without renaming the
datafiles...
> any suggestions?
>
> Thanks,
> Paula
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page