Since your error is in undo tablespace, there are several metalink
docs/methods for possibly getting around this (e.g. drop/recreate; but
do some research BEFORE you attempt). I'd also have dbverify give it a
shot. It might resolve...
M
Mike Porter
Finance Support Services
PGA of America
561-624-7646
>>> "Nkansah Derek "
<oracledba-ezmlmshield-x74618437.[Email address protected] 08/31/06 12:39
PM >>>
There is a dbms_repair stored procedure. Any reason why you don't want
to use dbverify??
D
-----Original Message-----
From: Sivashunmugam Sivaraman
[mailto:oracledba-ezmlmshield-x30862397.[Email address protected]
Sent: 31 August 2006 11:21
To: LazyDBA Discussion
Subject: Block corruption
Hi DBAs,
I got the following error while opening the DB.
I don't have a backup since it is a test DB.
Is there any way that iacn slove this problem wthout DBVERIFY utility.
Completed: alter database open
Thu Aug 31 15:12:13 2006
Errors in file /appl/oracle/admin/vtdb/bdump/vtdb_smon_4091.trc:
ORA-07445: exception encountered: core dump [0000000100504EF4] [SIGSEGV]
[Address not mapped to object] [0xFFFFF93863352EA7]
[] []
ORA-07445: exception encountered: core dump [0000000100504EF4] [SIGSEGV]
[Address not mapped to object] [0xFFFFF93863352EA7]
[] []
ORA-07445: exception encountered: core dump [0000000100504EF4] [SIGSEGV]
[Address not mapped to object] [0xFFFFF93863352EA7]
[] []
ORA-01578: ORACLE data block corrupted (file # 2, block # 546)
ORA-01110: data file 2: '/oradata02/vtdb/undotbs01.dbf'
Thu Aug 31 15:12:14 2006
Errors in file /appl/oracle/admin/vtdb/bdump/vtdb_pmon_4083.trc:
ORA-00474: SMON process terminated with error
Thu Aug 31 15:12:14 2006
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 4083
Thanks in advance,
S.SIva
'This email and any files transmitted with it are confidential and
intended
solely for the use of the individual or entity to whom they are
addressed.
If you have received this email in error please notify the system
manager.
Please note that any views or opinions presented in this email are
solely
those of the author and do not necessarily represent those of the
company.
Finally, the recipient should check this email and any attachments for
the
presence of viruses. The company accepts no liability for any damage
caused
by any virus transmitted by this email.'
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This e-mail (and any attachments) contains information, which is
confidential and intended solely for the attention and use of the named
addressee(s). If you are not the intended recipient you must not copy,
distribute or use it for any purpose or disclose the contents to any
person. If you have received this e-mail in error, please notify us
immediately at [Email address protected] The information contained in
this e-mail (and any attachments) is supplied in good faith, but the
sender shall not be under any liability in damages or otherwise for any
reliance that may be placed upon it by the recipient. Any comments or
opinions expressed are those of the originator not of NTT Europe Ltd
unless otherwise expressly stated.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page