Re: Problems with a datafile

Yes, I tried to resize the datafile with the command: alter database datafile '/baandata/dat2/datbaanIV03.dbf' resize 2000M; but I don't remember the message code that I got.

I'm sure there is enough space on disk, the result of "df -k" is: /dev/ora_dat2 4399104 4260940 4% 19 1% /baandata/dat2

The system is not yet in production, and there are no much data movements. Because that, I suppose the new datafile is not already used (?).

Frank, you say that I sould resetlogs again. That mince that in this way should I have the datafile online and accesible? Witch set of commands should I execute to do this job?

Another question, should I switch to archivelog mode before or after to recover from the actual situation?

Thanks
Jesus M. Lopez

Frank van Bortel wrote:

> What was the error when you tried to enlarge?
> I suppose you did:
> alter database datafile '/baandata/dat2/datbaanIV03.dbf' resize 2000M;
> and then what? You are sure /baandata/dat2 has enough space left?
>
> BTW the assumption there will be no data in this particular datafile
> is extremely dangerous! There is no garantuee that oracle will not
> have used it. There is a way to find out by inspecting rowid's,
> but putting that you have only 2400M used and over 4G available
> is not the way.
>
> Looking at your current error logs, it looks like you copied a previous
> version datbaanIV03.dbf back? You will have to do the resetlogs again,
> as you cannot afford to drop the original datafile.
>
> One tip, tho: I would switch to archivelog mode asap. I assume this
> BaanIV shop cannot afford to loose 24hrs of work.
> --
> Met vriendelijke groet/kind regards,
>
> Frank van Bortel
> Technical consultant Oracle
>
> Work: Home:
> ---------------------------------- ----------------------------
> Inter Access V&L Hunzestraat 4
> Palatijn 3, 7521 PN Enschede 7555 WB Hengelo
> PoBox 545, 7500 AM Enschede (31)074-2425046
> 053-4341500
Received on Fri Oct 29 1999 - 08:33:04 CDT