Error when trying to restore my database using RMAN 
Author Message
 Error when trying to restore my database using RMAN

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.



Fri, 08 Oct 2004 22:38:10 GMT
 Error when trying to restore my database using RMAN


Quote:
>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.

Apparently your NLS_LANG environment variable / registry variable (I
might be missing something, but I'm still not sure why people never
mention version and platform) is different from the characterset of
the database.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address



Sat, 09 Oct 2004 02:33:53 GMT
 Error when trying to restore my database using RMAN
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

Quote:

> 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.



Sat, 09 Oct 2004 02:43:29 GMT
 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.
===========================================================

Quote:

> 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.



Sat, 09 Oct 2004 06:34:53 GMT
 Error when trying to restore my database using RMAN
OK I think it is my NLS_LANG parameter which was incorrect.
So I have written in my initSID.ora file :

#date format parameter
NLS_DATE_FORMAT='Mon DD YYYY HH24:MI:SS'
NLS_LANG=American_America.WE8ISO8859P1
(it is the charset answer from the request :
select * from v$nls_parameters where parameter='NLS_CHARACTERSET';)

But when I try now to startup my instance, I have this error :

SVRMGR> startup
LRM-00101: unknown parameter name 'NLS_LANG'
ORA-01078: failure in processing system parameters
SVRMGR>

Oracle version : 8.1.7
Sever : Tru64 Alpha server Compaq



Sat, 09 Oct 2004 18:12:00 GMT
 Error when trying to restore my database using RMAN
NLS_LANG is the environmental variable. So it needs to
be set up at o/s level. Since it is not a database variable,
you cannot set it up in init.ora. For example, in unix, you
can use export NLS_LANG=....

Chandan Dutta
========================================================

Quote:

> OK I think it is my NLS_LANG parameter which was incorrect.
> So I have written in my initSID.ora file :

> #date format parameter
> NLS_DATE_FORMAT='Mon DD YYYY HH24:MI:SS'
> NLS_LANG=American_America.WE8ISO8859P1
> (it is the charset answer from the request :
> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';)

> But when I try now to startup my instance, I have this error :

> SVRMGR> startup
> LRM-00101: unknown parameter name 'NLS_LANG'
> ORA-01078: failure in processing system parameters
> SVRMGR>

> Oracle version : 8.1.7
> Sever : Tru64 Alpha server Compaq



Sun, 10 Oct 2004 00:59:12 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. Error 603 when trying to restore a SQL 6.5 database

2. Error whilst trying to restore a database

3. Error when trying to restore a database

4. Exactly what does RMAN store in the control file when RMAN is used without recovery catalog

5. Restoring a database using the RESTORE (T-SQL)

6. Help Using VB4.0 - Trying to open database using Dynaset in Dim Statment

7. RMAN syntax errors in OEM backup jobs, using a recovery catalog

8. Errors During Recovery Using RMAN

9. backup 9.2.0 database using RMAN

10. error 14274 (trying to edit job after restoring msdb)

11. Sector Size Error When Trying To Restore

12. SQL-DMO Error while trying to restore


 
Powered by phpBB® Forum Software