RE: Duplicating with rman

2003-12-22 Thread Stephen.Lee

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:[EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).


Re: Duplicating with rman

2003-12-20 Thread Yong Huang
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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).