Oracle Database Recovery Manager Concepts:Script to Restore Oracle Database from RMAN Backup

During Oracle Database Cloning,restore Oracle database from RMAN backup taken on Source environment to the Target environment.





Steps for Database restore using Oracle Recovery Manager (RMAN)


1.Connect to target database 


Startup the Target database in Nomount stage


SQL> Startup nomount


2.Run the below Command to Restore Oracle database using RMAN 


rman auxiliary / 
run
{
duplicate database to ‘DEV’ backup location ‘/DB_BACKUP/Daily_Backup/daily_bkp_04102018’;
}




Where DEV is the target instance for Restore
Backup Location – Directory where RMAN backup is located


3. Verify that Oracle database is up and running.

Leave a Reply

Your email address will not be published. Required fields are marked *