Database Backup and Recovery (MOSC)

MOSC Banner

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 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center