RMAN Duplicate failure - looking in v$archived_log

From: BD <bobby_dread_at_hotmail.com>
Date: 29 Sep 2005 09:51:50 -0700
Message-ID: <1128012710.625577.254040@g47g2000cwa.googlegroups.com>

Hey, all...

I'm working through RMAN database duplication (8i, AIX 5.2). Same server, different filepaths.

I've got the auxiliary (duplicate) instance up, and have the command string to reassign the paths for the datafiles constructed correctly (at least it's being parsed).

RMAN runs the command string, but fails on the actual duplicate command.

Error is:

"RMAN-06003: ORACLE error from target database: ORA-01405: fetched column value is NULL
RMAN-06097: text of failing SQL statement: select min(maxnc) ,min(maxnc) into :b1,:b2 from (select max(next_change#) maxnc from v$ archived_log group by thread#)"

I've checked the v$archived_log view, and it's empty. I did do a recovery recently in another recent RMAN exercise, and ran a RESETLOGS afterwards.

My guess is that it's not finding any archive logs, and so that portion of the script cannot be validated and fails

Should I be omitting the 'logfile' portion of the duplication if the database is in this state (no data changes have occurred since I RESETLOGS)? Here's my script:

run {

     allocate auxiliary channel dupdb1 type disk;
     allocate auxiliary channel dupdb2 type disk;
     allocate auxiliary channel dupdb3 type disk;
     allocate auxiliary channel dupdb4 type disk;
     set newname for datafile  1    TO

'/rs01/oradata/CTD2_DUP/system_CTD2_01.dbf';
.
.
.

     set newname for datafile 43 TO
'/rs01/oradata/CTD2_DUP/arch_tbl_CTD2_01.dbf';

    duplicate target database to CTD2_DUP logfile

      group 1 ('/rs02/oradata/CTD2/redo_log_1a.dbf',
               '/rs02/oradata/CTD2/redo_log_1b.dbf') size 200K reuse,
      group 2 ('/rs02/oradata/CTD2/redo_log_2a.dbf',
               '/rs02/oradata/CTD2/redo_log_2b.dbf') size 200K reuse,
      group 3 ('/rs02/oradata/CTD2/redo_log_3a.dbf',
               '/rs02/oradata/CTD2/redo_log_3b.dbf') size 200K reuse

   nofilenamecheck;
  }

Thanks for all insights!

BD Received on Thu Sep 29 2005 - 11:51:50 CDT