If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Sys.dbms_backup_restore

The SYS.DBMS_BACKUP_RESTORE package can be used to do the restore, but you will need to open a service request with Oracle to get the instructions on how to use it (there is no 'public' documentation available).

"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Restore RMAN backup to different machine

Vasant,

I know this post is many years old, but did you find a solution to this restore problem that says unable to open file ? I am running into the same problem and wondered if you ever found out. I am trying to restore my RMAN backup from production server(9i) to a test server(9i). I was able to do all the steps upto restoring the database. It's exactly like you mentioned in your post. RMAN does not find the new back up. Let me know please.