Re: Duplicating with rman

From: Yong Huang <yong321_at_yahoo.com>
Date: Sat, 20 Dec 2003 12:24:25 -0800
Message-ID: <F001.005DA8D9.20031220122425@fatcity.com>

Hi,

I'm not sure why your RMAN output says

 LOGFILE

  GROUP  1 ( '/z01/oradata/DEVL/redo_01a.dbf',

'/z02/oradata/DEVL/redo_01b.dbf',

  GROUP 2 ( '/z01/oradata/DEVL/redo_02a.dbf',

Where's the ") reuse" shown in your RMAN script? Are you sure the script you showed here was run?

Yong Huang

you wrote:

RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DEVL" ...
 LOGFILE

  GROUP  1 ( '/z01/oradata/DEVL/redo_01a.dbf',


'/z02/oradata/DEVL/redo_01b.dbf',

  GROUP  2 ( '/z01/oradata/DEVL/redo_02a.dbf',

'/z02/oradata/DEVL/redo_02b.dbf',

...
RMAN-06136: ORACLE error from auxiliary database: ORA-02236: invalid file name
RMAN-06097: text of failing SQL statement: CREATE CONTROLFILE REUSE SET ...
 LOGFILE

  GROUP  1 ( '/z01/oradata/DEVL/redo_01a.dbf',


'/z02/oradata/DEVL/redo_01b.dbf',

  GROUP  2 ( '/z01/oradata/DEVL/redo_02a.dbf',

'/z02/oradata/DEVL/redo_02b.dbf',

...

RMAN script is:
run {

   allocate auxiliary channel d1 type disk;    set until logseq 5115 thread 1;
   set newname for datafile 1 to '/u03/oradata/DEVL/system_01.dbf'; ...

   duplicate target database to DEVL nofilenamecheck

      logfile
      group 1
('/z01/oradata/DEVL/redo_01a.dbf','/z02/oradata/DEVL/redo_01b.dbf') reuse,
      group 2
('/z01/oradata/DEVL/redo_02a.dbf','/z02/oradata/DEVL/redo_02b.dbf') reuse,
      group 3

__________________________________

Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yong Huang
  INET: yong321_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sat Dec 20 2003 - 14:24:25 CST