Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help : TS rollbacks corrupted

Help : TS rollbacks corrupted

From: Olivier Bercovitz <olivier.bercovitz_at_steria.fr>
Date: Wed, 23 Jun 1999 11:56:36 GMT
Message-ID: <3770CBE1.D30750CE@steria.fr>


since we shutdown our db (with archivelog mode) we can't re-open it because we have an "ORA-27046 : file size is not a multiple of logical block size" in alert.log.
So what can we do ?
Recreate the tablespace rollbacks (with active rollback segments and a db mounted and not opened) ? What are the risk with this operation ? (We can't do an export with a db not mounted) The database is 8.0.3 with archivelog mode on AIX 4.2.1.

Thanks for your quick answer (it's a critical operational application !)

Regards.
Olivier Received on Wed Jun 23 1999 - 06:56:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US