how to restore into new db, same server, asm file system
we plan to take a backup of db DATA01, and restore it into another database DATA02, both uses asm file system.
1) we might want to restore from 3 month old backup. suggestion of cloning current DATA01 into DATA02 is not applicable.
2) totally different db (including name) different instance name but same db_name or unique name is not applicable ( so I guess I need to remember to set db id)
3) what worries me most is the overwriting of current DATA01 files with old files from the backup should I miss a step.
- datafile can set newname.
- also use convert as a backup in case i missed one in set newname ? what option here should i use