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: Jerome Vitalis <vitalismanREMOVETHAT_at_gmail.com>
Date: Wed, 26 Apr 2006 09:47:40 +0200
Message-Id: <pan.2006.04.26.07.47.30.200000@gmail.com>


On Tue, 25 Apr 2006 19:14:00 -0700, fitzjarrell_at_cox.net wrote:

>
> 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;
>
> You may want to consider the following command instead:
>
> BACKUP VALIDATE DATABASE;
> BLOCKRECOVER CORRUPTION LIST;
>
> which will find, list and then recover all corrupted blocks in the
> database using the V$DATABASE_BLOCK_CORRUPTION view.
>
> Yes, the database can be open when this is executed.

Very good explanation. "=" is optional though. Received on Wed Apr 26 2006 - 02:47:40 CDT

Original text of this message

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