Set the parameter recovery_parallelism to 0 (default). In 8.1.7 there
is a lovely "feature" which occasionaly breaks recovery if it's done in
parallel.
On 01/29/2004 01:00:24 PM, Raghu Kota (WBTQ) wrote:
> Thank you Rachel, But its not because of that! I got sense that
> because =
> of "Stuck Recovery", I don't know what makes stuck at particular
> block? =
> I though file was corrupted, I restored file again, But now its not =
> complaining regarding file corruptions, But still iam getting ora-600
> =
> [3020]..
> ORA-00283: recovery session cancelled due to errors
> ORA-00600: internal error code, arguments: [3020], [37872141], [1], =
> [19588], [20
> 4585], [92], [], []
>
> Thanks to all who replied...
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Rachel Carmichael
> Sent: Thursday, January 29, 2004 12:41 PM
> To: oracle-l_at_freelists.org
> Subject: Re: recovery from hotbackup...
>
>
> a quick check on Metalink for 0ra-600 3020 seems to indicate the
> "corruption" might be due to a "nologging" activity that took place
> on
> the database. Is that possibly what happened in your case?
>
>
> --- "Raghu Kota (WBTQ)" <RKota_at_WestonBakeries.com> wrote:
> >=20
> >=20
> > I am recovering from hot backup, alert log says one of file
> > corrupted! =3D
> > and I checked with dbv utility no corruption!! My environment is
> > AIX, =3D
> > Oracle 8174. Any ideas?
> >=20
> > SVRMGR> recover database until cancel using backup controlfile;
> > ORA-00279: change 212761575 generated at 01/28/2004 17:48:01 needed
> > for =3D
> > thread 1
> > ORA-00289: suggestion : /data4/archive/arch19588.log
> > ORA-00280: change 212761575 for thread 1 is in sequence #19588
> > Specify log: {<RET>=3D3Dsuggested | filename | AUTO | CANCEL}
> >=20
> > ORA-00283: recovery session canceled due to errors
> > ORA-00600: internal error code, arguments: [3020], [54630506], [1],
> =
> =3D
> > [19588], [20
> > 4403], [500], [], []
> >=20
> > From alert.log
> >=20
> > Thu Jan 29 09:22:26 2004
> > Errors in file
> > /software/app/oracle/admin/BAAN/udump/ora_53944_baan.trc:
> > ORA-01578: ORACLE data block corrupted (file # 14, block # 176614)
> > ORA-01110: data file 14: '/data3/oradata/BAAN/comp010idx03.dbf'
> > ORA-00600: internal error code, arguments: [6102], [6], [2], [],
> [],
> > [], =3D
> > [], []
> > Thu Jan 29 09:22:27 2004
> > Errors in file
> > /software/app/oracle/admin/BAAN/udump/ora_53944_baan.trc:
> > ORA-00600: internal error code, arguments: [3020], [54630506], [1],
> =
> =3D
> > [19588], [20
> > 4403], [500], [], []
> > Media Recovery failed with error 600
> > ORA-283 signalled during: ALTER DATABASE RECOVER CONTINUE
> DEFAULT=20
> > ..
> >=20
> > Thanks
> >=20
> > ----------------------------------------------------------------
> > 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
> > -----------------------------------------------------------------
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free web site building tool. Try it!
> http://webhosting.yahoo.com/ps/sb/
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
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
-----------------------------------------------------------------
Received on Thu Jan 29 2004 - 12:16:32 CST
