Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Restore database to a different directory on the same host

1055464Nov 19 2013 — edited Nov 20 2013

Hi.

I have a database (name appdev) of size 200G. we are using ASM. (+DATA/appdev)

i want to restore the database as app2dev on the same diskgroup to a different directory.(+DATA/APP2DEV)

I am planning to do this:

I want to use backup and restore(not duplicate). while restoring i will stop appdev database and restore appdev database to new directory. after restore i will use nid to change the db name.

can i use logfile_name_convert and db_file_name_convert to specify restore to a different directory? if not, can anybody please point me to the right direction?

I appreciate everybody's time.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 18 2013
Added on Nov 19 2013
5 comments
735 views