Problems in 817 doing RMAN duplicate

From: PF Moore <pf_moore_at_yahoo.co.uk>
Date: Thu, 01 Apr 2004 19:08:41 +0100
Message-ID: <smfnr2om.fsf@yahoo.co.uk>

I'm trying to do an RMAN duplicate of a database, and I'm getting errors I can't sort out. This is a duplicate from a cold backup to tape, from one server to another. The RMAN script is

run {

    allocate auxiliary channel t1 type 'SBT_TAPE' parms 'ENV=(NB_ORA_CLIENT=client,NB_ORA_SRV=server,NLS_DATE_FORMAT=YYYY-MM-DD:HH24:MI:SS,NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1)';
    allocate auxiliary channel t2 type 'SBT_TAPE' parms 'ENV=(NB_ORA_CLIENT=client,NB_ORA_SRV=server,NLS_DATE_FORMAT=YYYY-MM-DD:HH24:MI:SS,NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1)';
    allocate auxiliary channel t3 type 'SBT_TAPE' parms 'ENV=(NB_ORA_CLIENT=client,NB_ORA_SRV=server,NLS_DATE_FORMAT=YYYY-MM-DD:HH24:MI:SS,NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1)';
    allocate auxiliary channel t4 type 'SBT_TAPE' parms 'ENV=(NB_ORA_CLIENT=client,NB_ORA_SRV=server,NLS_DATE_FORMAT=YYYY-MM-DD:HH24:MI:SS,NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1)';

    send 'NB_ORA_CLASS=DB_COLD_CATALOG_TAPE';     send 'NB_ORA_SCHED=Daily';
    sql "alter session set nls_date_format=''YYYY-MM-DD HH24:MI:SS''";     set until time '2004-04-01 07:00:00';     duplicate target database to DBCOPY; }

The error I get is

RMAN-03022: compiling command: recover(1)
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: t1
RMAN-08031: released channel: t2
RMAN-08031: released channel: t3
RMAN-08031: released channel: t4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: Duplicate Db
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover(1)
RMAN-06136: ORACLE error from auxiliary database: ORA-06550: line 1, column 166:

PLS-00553: character set name is not recognized ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated RMAN-06031: could not translate database keyword

I think this relates to the database character set, but the source DB has characterset and NCHAR characterset of WE8ISO8859P1, which is what I have set in the client NLS_LANG environment variable.

I've tried all sorts of variations, but can't get anything to work. This is pretty urgent, as I have developers waiting for this database. Does anyone have any suggestions?

Thanks,
Paul.

-- 
This signature intentionally left blank

Received on Thu Apr 01 2004 - 12:08:41 CST