Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

what is the best way to change a file name within the same asm disk group?

1 view
Skip to first unread message

emdpro...@hotmail.com

unread,
Jun 2, 2008, 10:39:49 PM6/2/08
to
Dear group,

I am using Oracle 10.2.03 on linux.

I used nid to change the dbname from "test" to "dev", but select name
from v$datafile still show
filename as "+data1/test/users.xxxx", so I have to use RMAN "copy
datafile 'xxx' to '+data1' to change the file path, it is very slow.

It there any better way to do this?

Thanks for your help

Vladimir M. Zakharychev

unread,
Jun 3, 2008, 5:03:10 AM6/3/08
to

Why do you want to rename ASM files anyway? What problem will it cause
if they stay '+data1/test/...'?

Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

emdpro...@hotmail.com

unread,
Jun 3, 2008, 6:58:28 AM6/3/08
to
> Why do you want to rename ASM files anyway? What problem will it cause
> if they stay '+data1/test/...'?
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com

What if I want to create another test, or move test from another
server?

DA Morgan

unread,
Jun 3, 2008, 1:08:41 PM6/3/08
to

Why is the name of an ASM data file, or for that matter the name
of a database relevant to its use? I'd have changed the entry in
the tnsnames.ora and gone to something more interesting.

My advice: The file name is an irrelevancy ... ignore it.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damo...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Frank van Bortel

unread,
Jun 4, 2008, 4:14:47 AM6/4/08
to
DA Morgan wrote:

> My advice: The file name is an irrelevancy ... ignore it.

Technically correct, but wait till you get to work a governmental
organizations - they have rules for filenames :)
--

Regards,
Frank van Bortel

Shakespeare

unread,
Jun 4, 2008, 7:13:16 AM6/4/08
to

"Frank van Bortel" <frank.va...@gmail.com> schreef in bericht
news:170bb$48464ef8$524b5c40$28...@cache2.tilbu1.nb.home.nl...

> DA Morgan wrote:
>
>> My advice: The file name is an irrelevancy ... ignore it.
>
> Technically correct, but wait till you get to work a governmental
> organizations - they have rules for filenames :)

... and change them all the time as they see fit.......

> --
>
> Regards,
> Frank van Bortel

Shakespeare


Vladimir M. Zakharychev

unread,
Jun 4, 2008, 8:11:00 AM6/4/08
to

ASM filenames are unique anyway, you have no actual control over them,
ASM does. You can add your own aliases for ASM filenames so that the
same file can be resolved using two or more names, but that's about
it. If you create another test db, ASM will create new unique
filenames for its files. If you move or clone a db with RMAN, ASM will
create new unique filenames for its files either (and I know of no
other way to import files into ASM than RMAN.)

Hth,

0 new messages