Oracle Database Discussions

All

I have a database 10.2.0.3 running on Solaris 10 OS.

I have performed a full back up (level 0) of this database using rman utility with auto back up on. I am trying to worl on a scenario where I could restore this backup on another linux machine. so I copied over all the backup pieces into the target linux server. from a local RDBMS installation (10.2.0.3) on the linux machine I am trying to restore the database... but not successful yet..

when I issue restore spfile or restore control file from +<backup file name>+; the prompt continues to search in some location is responding back saying no back up piece found.. below is the sequece of step I am trying ..


1 set up env on the linux server

2 rman target /

(instance not started but rman allows connection)

3 set DBID=+<DB ID of the source database running on Solaris>+

it executes set dbid=

4 startup nomount

as the pfile/spfile is not available under $ORACLE_HOME/dbs on linux machine it picks up default pfile however but the instance stars no mount..

5 restore spfile from '/u01/app/oracle/product/10.2.0/rman_bkp/c-300009955'

here it is not able to restore any thing.same is the case with control file.

Any ideas please advice

Sarat