Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN block lever recovery question

Re: RMAN block lever recovery question

From: <frank.van.bortel_at_gmail.com>
Date: 26 Apr 2006 00:57:25 -0700
Message-ID: <1146038245.833436.249770@j33g2000cwa.googlegroups.com>

fitzjarrell_at_cox.net schreef:

> joebayer (nospam) wrote:
> > Group,
> >
> > I am using Oracle 9206 on windows. I have a corrupted block on system
> > tablespace. And I am using block level recovery (RNAN) to resolve this
> > problem.
> >
> > I used
> > blockrecover file=?? block=?? where database is open? Is this correct?
> >
> > The command seems to hang there for hours.
> >
> > Any suggestions?
>
> The command syntax you used is not correct; the '=' sign is not used
> and 'file' should be 'datafile'. Your example should look like:
>
> BLOCKRECOVER DATAFILE ? BLOCK ??;
>
> where ? is a single number and ?? can be one or more blocks, delimited
> by commas. If you need more blocks recovered in other files you can
> list those in additional DATAFILE ? BLOCK ?? lists, as in the example
> below:
>
> BLOCKRECOVER DATAFILE 2 BLOCK 12, 13 DATAFILE 3 BLOCK 5, 98, 99
> DATAFILE 4 BLOCK 19;
>

Eh... wasn't that a 10g RMAN feature? The OP is on 9.2. Needs to have Enterprise Edition anyway. Received on Wed Apr 26 2006 - 02:57:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US