Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: recovery from hotbackup...
Raghu,
You may want to read Metalink note 35512.1 on dbv. A workaround may be to take the datafile offline, and recover all the other tablespaces individually, and then rebuild this tablespace, and then recreate the indexes in this tablespace. I am assuming that since the name of your tablespace has idx in it, that only indexes are in it.
HTH,
Mike
"Raghu Kota (WBTQ)" To: <oracle-l_at_freelists.org> <RKota_at_WestonBaker cc: ies.com> Subject: recovery from hotbackup... Sent by: oracle-l-bounce_at_fr eelists.org 01/29/2004 09:41 AM Please respond to oracle-l
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: change 212761575 generated at 01/28/2004 17:48:01 needed for =
thread 1
ORA-00289: suggestion : /data4/archive/arch19588.log
ORA-00280: change 212761575 for thread 1 is in sequence #19588
Specify log: {<RET>=3Dsuggested | filename | AUTO | CANCEL}
ORA-00283: recovery session canceled due to errors
ORA-00600: 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: 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], [], [], [], =[], []
Thanks
-- 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 - 09:06:22 CST