Duplicating with rman

From: <Stephen.Lee_at_DTAG.Com>
Date: Fri, 19 Dec 2003 09:19:25 -0800
Message-ID: <F001.005DA721.20031219091925@fatcity.com>

I was using RMAN to duplicate a database -- my first time (please be gentle).
Copied an on-disk rman backup to target box. started clone instance nomount.
rman nocatalog
connect target abc/xyz_at_original
connect auxiliary xyz/abc_at_clone
@script (see below)

Everything was going OK until
Got error:

RMAN-08523: restoring datafile 00016 to
/u03/oradata/DEVL/ora_audit_idx_01.dbf
RMAN-08023: channel d1: restored backup piece 1 RMAN-08511: piece handle=/u05/oracle/admin/HRP1/backup/dnf9b1m4_1_1_DATA tag=BACKUP_DB_FULL params=NULL
RMAN-08024: channel d1: restore complete RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DEVL" RESETLOGS ARCHIVELOG

  MAXLOGFILES     32
  MAXLOGMEMBERS      2
  MAXDATAFILES      254
  MAXINSTANCES     1
  MAXLOGHISTORY      907

 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',

  GROUP  3 ( '/z01/oradata/DEVL/redo_03a.dbf',


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

  GROUP  4 ( '/z01/oradata/DEVL/redo_04a.dbf',

'/z02/oradata/DEVL/redo_04b.dbf'

 DATAFILE
  '/u03/oradata/DEVL/system_01.dbf'
 CHARACTER SET US7ASCII

RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: Duplicate Db
RMAN-06136: ORACLE error from auxiliary database: ORA-02236: invalid file

name
RMAN-06097: text of failing SQL statement: CREATE CONTROLFILE REUSE SET DATABASE "DEVL" RESETLOGS ARCHIVELOG

  MAXLOGFILES     32
  MAXLOGMEMBERS      2
  MAXDATAFILES      254
  MAXINSTANCES     1
  MAXLOGHISTORY      907

 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',

  GROUP  3 ( '/z01/oradata/DEVL/redo_03a.dbf',


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

  GROUP  4 ( '/z01/oradata/DEVL/redo_04a.dbf',

'/z02/oradata/DEVL/redo_04b.dbf'

RMAN-06099: error occurred in source file: krmk.pc, line: 7544

RMAN> **end-of-file**

---

---

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';
   set newname for datafile 2 to '/u03/oradata/DEVL/rbs_01.dbf';
   set newname for datafile 3 to '/u03/oradata/DEVL/users_01.dbf';
   set newname for datafile 4 to '/u03/oradata/DEVL/tools_01.dbf';
   set newname for datafile 5 to '/u03/oradata/DEVL/temp_01.dbf';
   set newname for datafile 6 to '/u03/oradata/DEVL/css_temp_01.dbf';
   set newname for datafile 7 to '/u03/oradata/DEVL/css_tools_01.dbf';
   set newname for datafile 8 to '/u03/oradata/DEVL/css_tools_index_01.dbf';
   set newname for datafile 9 to '/u03/oradata/DEVL/css_data_01.dbf';
   set newname for datafile 10 to '/u03/oradata/DEVL/css_data_index_01.dbf';
   set newname for datafile 11 to '/u03/oradata/DEVL/css_pay_01.dbf';
   set newname for datafile 12 to '/u03/oradata/DEVL/css_pay_index_01.dbf';
   set newname for datafile 13 to '/u03/oradata/DEVL/css_pay2_01.dbf';
   set newname for datafile 14 to '/u03/oradata/DEVL/css_pay2_index_01.dbf';

   set newname for datafile 15 to '/u03/oradata/DEVL/ora_audit_01.dbf';    set newname for datafile 16 to '/u03/oradata/DEVL/ora_audit_idx_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
('/z01/oradata/DEVL/redo_03a.dbf','/z02/oradata/DEVL/redo_03b.dbf') reuse,
      group 4

('/z01/oradata/DEVL/redo_04a.dbf','/z02/oradata/DEVL/redo_04b.dbf') reuse; }

---

---

The error
"ORA-02236: invalid file name"
would seem to indicate a syntax problem in the rman script. But I can't figure it out.
Recreating the control file "by hand" then running: RMAN> run {

2> allocate auxiliary channel d1 type disk;
3> set until logseq 5115 thread 1;
4> recover clone database;
5> }

Worked OK.

Any suggestions?

-- 
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).

Received on Fri Dec 19 2003 - 11:19:25 CST