RE: recovery from hotbackup...
- From: "Raghu Kota (WBTQ)" <RKota@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Jan 2004 13:00:24 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Rachel Carmichael
Sent: Thursday, January 29, 2004 12:41 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
