RE: cross node restore

From: <Joel.Patterson_at_crowley.com>
Date: Tue, 28 Jul 2009 09:49:39 -0400
Message-ID: <0684DA55864E404F8AD2E2EBDFD557DA03163B53_at_JAXMSG01.crowley.com>

I didn't look it up... but I believe this means it wants a string 'xxx' and you gave it a date.

Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discover.com
Sent: Monday, July 27, 2009 6:34 PM
To: oracle-l_at_freelists.org
Subject: Re: cross node restore

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_at_dis

             cover.com>

             Sent by:
To

             oracle-l-bounce_at_f oracle-l_at_freelists.org

             reelists.org
cc    

Subject

             07/23/2009 05:08 cross node restore

             PM    

             Please respond to

             genegurevich_at_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_at_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 /_at_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.

--

http://www.freelists.org/webpage/oracle-l

Please consider the environment before printing this email.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jul 28 2009 - 08:49:39 CDT