Re: Error when trying to restore my database using RMAN

From: svr <subbarao_at_telocity.com>
Date: 22 Apr 2002 11:43:29 -0700
Message-ID: <5eb61ed1.0204221043.62334c86@posting.google.com>

I saw this error message,
Check all the NLS environment variables sourced properly, before logging to rman shell.
sometimes, even after sourcing varaibles also rman couldn't find these, may be a bug.
The best way is

---

allocate channel t1 type disk;
restore (database);
sql "alter database mount";
restore archivelog all;
recover database;
sql "alter database open resetlogs";
release channel t1;

---

If this single script did not work, keep the same in two scripts execute restore first and log out rman and log in again and execute recover.
It does the trick.

HTH
svr

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 - 13:43:29 CDT