Hi folks,

I hope you can help me. My situation is as follows:

1. I have some year-old files that I'd like to restore. It's a full backup generated with RMAN. I have the control file and the BAKs, as well

2. It has to be restored away from the production database. I created another instance in a separate box for that.

3. The RMAN catalog is no longer available.

My questions are:

Since I have a new instance and can change the DBID, can I instruct RMAN to use the old controlfile I restored and show me the backup list?

One more thing: the backup was originally generated on the F:\ drive, while the new Oracle instance has the backup files on D:. Will that be an issue?

I managed to restore the controlfile, but when I run RESTORE DATABASE, it says that some tablespaces are missing (SYSTEM being one of them). When I ask for a list of what's backed up, it is there. What is that?

Also, even when using SET NEWNAME or CONFIG AUXNAME, the restore still tries to write on the OLD folder.

Thanks in advance for any help