RE: RMAN Recovery - RBS (Non System) tbs

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Mon, 07 Apr 2003 12:59:02 -0800
Message-ID: <F001.0057C49B.20030407125902@fatcity.com>

Here is one of several solutions in this area...

Situation: Full restore error occurs with the error

---

PLS-00553: character set name is not recognized

Solution: Set the NLS_LANG parameter on target database ======== and it solved the problem

>export NLS_LANG=american_america.we8iso8859p1

---

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: d1
RMAN-08031: released channel: d2
RMAN-08031: released channel: d3
RMAN-08031: released channel: d4
RMAN-08031: released channel: d5
RMAN-08031: released channel: d6
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-06010: error while looking up datafile: 1

RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.

-----Original Message-----
Sent: Monday, April 07, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L

Thanks for the suggestion. Shall work on it and post back the results.

---

Not so Lazy DBA

---

• "Spears, Brian" <BSpears_at_Limitedbrands.com> wrote:
  > OK, maybe its not hundreds.. but there is a lot.. I
  > guess the Nice new
  > features
  > like virtual restores (validate) are the
  > compensating factor.
  > Overall I am quite dissappointed with Oracle with
  > this..they could have
  > easily
  > made it better (my opinion). I just imagine what it
  > would be like if Billy
  > wasnt
  > putting some pressure on Oracle to simply stuff.
  >
  > Brian
  >
  > -----Original Message-----
  > Sent: Monday, April 07, 2003 11:14 AM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  >
  > See that little error below... character set..
  > and people think I am so
  > nuts
  > to be over paranoid when it comes to backups.
  >
  > If your character set of the catalog is not a super
  > set of target you get
  > probs.
  > If you ever re-import your Catalog with a different
  > Charset I found problems
  >
  > Set your NLS_LANG environ variable before do the
  > recovery..this fixed most
  > issues..that could be fixed easily. It my testing I
  > found Rman could do more
  > but
  > also have a hundred more loop holes.
  >
  >
  > ORA-01110: data file 3:
  > '/u001/oracle/oradata/REPX/rbs01.dbf'
  > ORA-06508: PL/SQL: could not find program unit being
  > called
  > ORA-06512: at line 1
  > RMAN-04015: error setting target database character
  > set to US7ASCII
  >
  > RMAN> quit
  >
  >
  >
  >
  > -----Original Message-----
  > Sent: Saturday, April 05, 2003 10:29 PM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  >
  > --- Layzee DBA <layzeedba2_at_yahoo.com> wrote:
  > > Hi DBA's
  > >
  > > I am in the process of establishing Crash Recovery
  >
  > > scenarios using RMAN and i came across one
  > situation
  > >
  > > wherein i am able to recover a tbs having (non
  > > system
  > > tbs) rbs in it using svrmgrl but the same damn
  > thing
  > >
  > > does not work with rman.
  > >
  > > I want to know where i am going wrong with rman.
  > > Info
  > > is avbl.in
  > >
  > >
  > http://www.geocities.com/layzeedba/rman0000_rbs.html
  > >
  > > Any input on this would be highly appreciated.
  > >
  > > Please reply to me and directly to the list.
  > >
  > > ===============
  > > Not so Lazy DBA
  > > ===============
  >
  > Hi Guys,
  >
  > Lot of RMAN talk has been going on in this forum.
  > Good. But can any gentleman help me sort out this
  > issue?.
  >
  > Thanks
  >
  >
  >
  

  ---

Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Layzee DBA
  INET: layzeedba2_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Spears, Brian
  INET: BSpears_at_Limitedbrands.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Apr 07 2003 - 15:59:02 CDT