recovery from hotbackup... 2004-01-29 - By Rachel Carmichael
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@(protected) > wrote:
>
>
> I am recovering from hot backup, alert log says one of file
> corrupted! > and I checked with dbv utility no corruption!! My environment is
> AIX, > Oracle 8174. Any ideas?
>
> SVRMGR > recover database until cancel using backup controlfile;
> ORA-00279 (See ORA-00279.ora-code.com): change 212761575 generated at 01/28/2004 17:48:01 needed
> for > thread 1
> ORA-00289 (See ORA-00289.ora-code.com): suggestion : /data4/archive/arch19588.log
> ORA-00280 (See ORA-00280.ora-code.com): change 212761575 for thread 1 is in sequence #19588
> Specify log: { <RET >=suggested | filename | AUTO | CANCEL}
>
> ORA-00283 (See ORA-00283.ora-code.com): recovery session canceled due to errors
> ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [3020], [54630506], [1], > [19588], [20
> 4403], [500], [], []
>
> From alert.log
>
> Thu Jan 29 09:22:26 2004
> Errors in file
> /software/app/oracle/admin/BAAN/udump/ora_53944_baan.trc:
> ORA-01578 (See ORA-01578.ora-code.com): ORACLE data block corrupted (file # 14, block # 176614)
> ORA-01110 (See ORA-01110.ora-code.com): data file 14: '/data3/oradata/BAAN/comp010idx03.dbf '
> ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [6102], [6], [2], [], [],
> [], > [], []
> Thu Jan 29 09:22:27 2004
> Errors in file
> /software/app/oracle/admin/BAAN/udump/ora_53944_baan.trc:
> ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [3020], [54630506], [1], > [19588], [20
> 4403], [500], [], []
> Media Recovery failed with error 600
> ORA-283 (See ORA-283.ora-code.com) signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT
> ..
>
> Thanks
>
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> To unsubscribe send email to: oracle-l-request@(protected)
> 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
