Problems in 817 doing RMAN duplicate

Giganews Newsgroups
Subject: Problems in 817 doing RMAN duplicate
Posted by:  PF Moore (pf_moo…@yahoo.co.uk)
Date: Thu, 01 Apr 2004

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

Replies