Root Fan - Page 16 of 40 - Oracle & Postgresql DBA Blog

To duplicate an Oracle database with backups you have taken with RMAN there are several ways to do it.

Make sure to have a full backup of the source database.

The backups are located at: /home/oracle/backup

The first method I will show you is with a minimal pfile, only the db_name.

The second method will be with more info in the pfile.

You can use this RMAN script to create a backup of an Oracle database and save it to a specified destination.

It is important that the BACKUP_BASE_PATH exists and the ORACLE_SID is replaced in the script.

The script will create a folder inside of BACKUP_BASE_PATH with the ORACLE_SID.