Re: recovery from hotbackup...
- From: Michael Boligan <michael.boligan.b@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 29 Jan 2004 10:06:22 -0500
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@xxxxxxxxxxxxx>
<RKota@WestonBaker cc:
ies.com> Subject: recovery from
hotbackup...
Sent by:
oracle-l-bounce@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], [], [], [], =
[], []
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], =
[19588], [20
4403], [500], [], []
Media Recovery failed with error 600
ORA-283 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@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:
