RE: RMAN Questions

I was not clear after re-read the document that is why I posted here to get some help.

"
set maxcorrupt for datafile datafileSpec to integer  sets a limit on the number of previously undetected physical block corruptions that Oracle will allow in a specified datafile or list of datafiles (see "datafileSpec"). If a backup or copy command detects more than the specified number of corruptions, the command aborts. The default limit is zero, meaning that RMAN tolerates no corrupt blocks. "

I have to instruct RMAN to tolerate 5 corrupt blocks. How & where should I specify maxcorrupt value?

set maxcorrupt for datafile 3 to 7

Mladen, Thanks for your answer.

Thanks
Jay

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mladen Gogala Sent: Saturday, July 10, 2004 4:28 PM
To: oracle-l_at_freelists.org
Subject: Re: RMAN Questions

On 07/10/2004 06:19:40 PM, Jay wrote:

> I have few RMAN questions.

Which can easily be answered from the documentation, but since I have to be nice, here we go:

>
> 1) What is the difference between
> a)restore controlfile;

Restores controlfile from the backups of controlfile. It doesn't look into other backups.

> b)restore controlfile from autoback;

Restores controlfile from any backup which has controlfile autobackup.

>
> a)restore controlfile restores from catalog, how about the next one?
>
>
> 2)set maxcorrupt for datafile 3 to 7
>
> maxcorrupt parameter will be set to datafile 3,4,5,6 and 7. Am I correct?
If
> so, what is the value of maxcorrupt?

Maximum numer of corrupt blocks for the datafile number 3. A malicious and bad
person would suggest you to read the f***ing manual, but, as I've said before,
I'm a nice guy, so I will not say anything like that.

>
>
> 3)restore database until sequence 100 thread 1;
>
> what is "thread 1"?

A long, thin string, first among the many. Bundled together, you can call them a rope,
OPS or RAC, depending on the material they're made of.

>
> Thanks
> Jay

Michael from Utah will probably have something to say about your question, but please, pay
no attention. You're welcome.

--
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------