Re: Problems in 817 doing RMAN duplicate

From: Phillip Tien <tienp_at_wholefoods.com>
Date: Thu, 01 Apr 2004 16:36:36 -0600
Message-ID: <406C9974.71212D7D@wholefoods.com>

Here are my duplication scripts. This is the command file (dup_dbcopy.script) I use when I call the rman command at the command line.

run {

   set until time '02-MAR-2004 04:38:00';

   allocate auxiliary channel dupdb1 type 'sbt_tape';
   allocate auxiliary channel dupdb2 type 'sbt_tape';
   allocate auxiliary channel dupdb3 type 'sbt_tape';
   allocate auxiliary channel dupdb4 type 'sbt_tape';
   allocate auxiliary channel dupdb5 type 'sbt_tape';

  send 'NB_ORA_CLIENT=hostname';
duplicate target database to dbcopy
}

The rman command to call this script is as follows:

export NLS_LANG=AMERICAN
export NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS' rman target / catalog dbmain_at_rman auxiliary sys_at_dbcopy \ cmdfile dup_dbcopy.script log dup_dbcopy.log

This works like a charm for me on both 8i and 9i on Solaris. Hope that helps.

PF Moore wrote:

> 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

--
Phillip Tien
Database Administrator
Whole Foods Market

Received on Thu Apr 01 2004 - 16:36:36 CST