Database Backup and Recovery (MOSC)

MOSC Banner

Create database from backups of production database, but in another server

edited Apr 13, 2013 5:35AM in Database Backup and Recovery (MOSC) 4 commentsAnswered
I have a production database in server 1.
Full backups are taken each day at 2:00 am. This full backups include the controlfile.
This is the script for the full database backup:

   backup
        check logical  
        database tag='TAG${TAG_FULL}'
           filesperset 1
        current controlfile tag='TAG$(TAG_CTL)';

 Archive log files are backed up each hour and thirty minutes.

Now I want to create a new database on server2 using existing backups from the production database.

Server1 and Server2 have ASM.

What steps do I need to take in order to create the database on server2 using ASM? Do I need to move the backups from ASM server1 to ASM on server2?

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