RE: Duplicating with rman

Yeah. I noticed that too and wondered about it. The script that was posted was, in fact, the script that was run. Maybe same kind of line length limitation?

> -----Original Message-----
> From: Yong Huang [mailto:yong321_at_yahoo.com]
> Sent: Saturday, December 20, 2003 2:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Duplicating with rman
>
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <Stephen.Lee_at_DTAG.Com
  INET: Stephen.Lee_at_DTAG.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).