Create a new database using RMAN backup

[ganjisb]

Hi,
I want to create a new databse using the backup done with RMAN tool. Is is possible ?

For example I have a Database "sourceDB" and i have taken full database backup 2 days ago with RMAN . And now i want to create a new databse "NewDB" with the backup existing . Is it possible ? If yes how can we go about !

Any help would be appreciated.

Thanks

[stmontgo]

yes it is possible
investigate 'duplicate database' from the rman guide
http://tahiti.oracle.com

steve

[ganjisb]

But, I guess we cannot create a new database with the existing backup . duplicate command creates new database with the online database and requires the source DB down all along.
I am right ?

[Sameer]

Originally posted by ganjisb
But, I guess we cannot create a new database with the existing backup . duplicate command creates new database with the online database and requires the source DB down all along.
I am right ?

You can create duplicate database from the backup. RMAN DUPLICATE command to create a duplicate database from target database backups while still retaining the original target database

refer to
http://download-west.oracle.com/docs...pdb.htm#442479

Sameer