Database Backup and Recovery (MOSC)

MOSC Banner

Restore a database to a new host using RMAN backups

edited Jun 10, 2010 8:21AM in Database Backup and Recovery (MOSC) 6 commentsAnswered
Hello,

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;

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