Re: Error when trying to restore my database using RMAN

The character sets must be same between the recovery catalog and target database sites:

execute the sql to determine the nls_characterset:

select * from v$nls_parameters where parameter='NLS_CHARACTERSET';

Then set the environmental variable NLS_LANG before starting RMAN to match the target database character set.

hilmarcher_at_yahoo.com (Caroline) wrote in message news:<8f934c98.0204220638.2d013a28_at_posting.google.com>...
> Hi all,
>
> I have the following error when I try to restore my database. Anyone
> has already seen this error ?
>
> RMAN> run {
> 2> allocate channel ch1 type disk;
> 3> allocate channel ch2 type disk;
> 4> allocate channel ch3 type disk;
> 5> restore database;
> 6> }
>
> RMAN-03022: compiling command: allocate
> RMAN-03023: executing command: allocate
> RMAN-08030: allocated channel: ch1
> RMAN-08500: channel ch1: sid=10 devtype=DISK
>
> RMAN-03022: compiling command: allocate
> RMAN-03023: executing command: allocate
> RMAN-08030: allocated channel: ch2
> RMAN-08500: channel ch2: sid=11 devtype=DISK
>
> RMAN-03022: compiling command: allocate
> RMAN-03023: executing command: allocate
> RMAN-08030: allocated channel: ch3
> RMAN-08500: channel ch3: sid=12 devtype=DISK
>
> RMAN-03022: compiling command: restore
>
> RMAN-03022: compiling command: IRESTORE
> RMAN-03026: error recovery releasing channel resources
> RMAN-08031: released channel: ch1
> RMAN-08031: released channel: ch2
> RMAN-08031: released channel: ch3
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> ===============
> RMAN-00571: ===========================================================
> RMAN-03002: failure during compilation of command
> RMAN-03013: command type: restore
> RMAN-03002: failure during compilation of command
> RMAN-03013: command type: IRESTORE
> RMAN-06003: ORACLE error from target 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
>
> Many Thanks,
>
> C.H.
Received on Mon Apr 22 2002 - 17:34:53 CDT