Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help : TS rollbacks corrupted
On Wed, 23 Jun 1999 11:56:36 GMT, Olivier Bercovitz
<olivier.bercovitz_at_steria.fr> wrote:
>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
Since you have run in archive log mode. You can recover you database
from the last backup made after you last changed in archivelog mode.
Take all the the datafiles file from the backup (not the redolog
files, and controlfiles. And put them in the right place .They are
supposed to be fine.
Which files? Mount the database and select name from v$datafiles,
which gives you the exact location of all datafiles.
Starup nomount:
SVRMGR> Recover database
>
>
Received on Thu Jul 15 1999 - 14:24:12 CDT