Database Software

Hi All,

OS version- solaris

Database version 11.1.0.7.0

rman backup location source- u25/rman/test_bkp

I copied the above backup pieces to the below target location

rman backup location target- test/rman/backup

datafile location in source-u100/oradata/DATABASE_NAME/

datafile location in target - u210/oradata/database_name


I have tried the below ways to restoring the oracle database in different host and different directory stucture.

1) edit the init file and up the database in nomount phase.-success

2) restore the control file from and up the database in mount phase.-success

3) catloging the the backup piece using the command catalog start with '/tmp/';-success

4) rename the log file -succes

5) set new name the datafile for new location-success (set newname for datafile to 1 '/datafileloc';)

6) if i execute 'restore database'-failed. it given the below error: (even though my backup it's avilable). also it tried o restore the datafile in source location


ORA-19504: failed to create file
failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 332 found to restore


But if i tried to execute the 'restore database validate' that has been success, after tried to execute the switch command in run block, it won't give any output, just immediately switch to rman prompt again.

I have checked the permiision of backup pieces-ok

even I tried instead of set new name using db_file_name_convert=('/u100/oradata/DATABASE_NAME', '/u210/oradata/database_name') even tried without quotes & double quotes also.



Note: I have taken my backup last week (12-oct-2012).(after refesh by production), so it won't store any old value in control file. also i execute the list incarnation of database; it's shows the old incarnation value.(parent 13-sep-2006,current 07-oct-12).

am using only no catalog.

So please try to help me to resolve the issue.

If I made any mistakes in above steps please correct me.


Regards
RK