Hello: I am moving with my restore and I just hit the following error: SQL> alter session set nls_date_format="mm-dd-yyyy hh24:mi"; Session altered. SQL> recover database until time to_date('07-21-2009 20:00:00','mm-dd-yyyy hh24:mi:ss') using backup controlfile; ORA-00285: TIME not given as a string constant SQL> recover database until cancel using backup controlfile; ORA-00283: recovery session canceled due to errors ORA-01110: data file 2: '/oradata/oradatax06/pdwgr05/undo_01.dbf' ORA-01157: cannot identify/lock data file 2 - see DBWR trace file ORA-01110: data file 2: '/oradata/oradatax06/pdwgr05/undo_01.dbf' The reason this file is not found is that I don't have a direcotory /oradata/oradatax06. I have however a db_file_name_convert parameter that points this directory to another one that does exist on the server and there undi_01 file is located. Why is this parameter being ignored? And what can I do to point oracle to a different set of the directories? thank you Gene Gurevich <genegurevich@dis cover.com> Sent by: To oracle-l-bounce@f oracle-l@xxxxxxxxxxxxx reelists.org cc Subject 07/23/2009 05:08 cross node restore PM Please respond to genegurevich@disc over.com Hello: I am trying to restore couple of DB files (v10.2.0.3) from the rman backup to another server where I have 10.2.0.4 binaries. Here is the error I am seeing and I am not sure what it is referring to. If someone can provide some guidance, I would appreciate that. rman Recovery Manager: Release 10.2.0.4.0 - Production on Thu Jul 23 16:58:47 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. RMAN> connect target sys/XXX@sourceDB PL/SQL package SYS.DBMS_BACKUP_RESTORE version 10.02.00.03 in TARGET database is not current PL/SQL package SYS.DBMS_RCVMAN version 10.02.00.03 in TARGET database is not current connected to target database: DDWGR04 (DBID=1559685648) RMAN> connect auxiliary / connected to auxiliary database: PDWGR05 (not mounted) RMAN> connect catalog /@sourceCAT connected to recovery catalog database RMAN> run { 2> allocate auxiliary channel ch1 type 'SBT_TAPE'; 3> Allocate channel t1 type 'SBT_TAPE'; 4> restore controlfile to '/oradata/oradata01/pdwgr05/control01_01.ctl'; 5> replicate controlfile from '/oradata/oradata01/pdwgr05/control01_01.ctl'; 6> release channel t1; 7> release channel ch1; 8> } allocated channel: ch1 channel ch1: sid=787 devtype=SBT_TAPE channel ch1: NMO v4.2.0.0 allocated channel: t1 channel t1: sid=702 devtype=SBT_TAPE channel t1: NMO v4.2.0.0 Starting restore at 23-JUL-09 released channel: ch1 released channel: t1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 07/23/2009 16:59:43 RMAN-06026: some targets not found - aborting restore RMAN-06101: no channel to restore a backup or copy of the control file thank you Gene Gurevich Please consider the environment before printing this email. -- //www.freelists.org/webpage/oracle-l Please consider the environment before printing this email. -- //www.freelists.org/webpage/oracle-l