Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2013

Added on Nov 19 2013

#11g, #backup, #database, #db, #oracle, #performance-availability, #recovery-manager-rman, #rman

5 comments

962 views