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.