Restore a database to a new host using RMAN backups
We have the production database RMAN backups. Now we want to restore the rman backup to a different server.
The two servers have the same structures, for example: the same data file location,the same backup location...
Here's what I did but got an 'ORA-01180: can not create datafile 1' error:
1. I created the database in the new host using the createDB_scripts which we saved while creating production database
2. scp the backup files to the new host at the same location as where the backups located on prouction server.
3. rman target / catalog rman/pwd@catalog_database
4. rman>restore database;