If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I finished creating a 10GB oracle 8.1.7 database on a 64 bit IBM AIX platform. I was forced to lacate the datafiles on an EMC IP4700 box (hybrid ofg EMC Symmetrix and Clariion).
The details of the databse is as follows:

Everything went fine for one week. I was then importing a 4.5 GB table and I suddenly got the first error

"This memory-realm does not exist".
End of communication channel
Oracle not available.

I had to reboot the server and the database could only be mounted. Could not open as it says there is corruption in one fo the redologs. :
*** SESSION ID:(4.1) 2001-03-21 17:26:59.254
***
Corrupt block relative dba: 0x00000001 (file 0, block 1)
Bad check value found during control file header read
Data in bad block -
type: 21 format: 2 rdba: 0x00000001
last change scn: 0xffff.00006166 seq: 0x1 flg: 0x04
consistency value in tail: 0x61661501
check value in block header: 0xe949, computed block checksum: 0xe083
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
***
What could be the problem ???
Please help. I just created the database and did not get time to take bachkup measures.

Check the alert log and any trace files for further info. Seems like a block corruption. I would advise you to call Tech Support. Increase the size of the redo log files. 1M is way too small, esp for imports.

Databse crash -- suggestions

Thanks for the advise.
But could you please suggest a better sizing for the reodlogs and logbuffers ?
Is a redolog of size 5M okay. I will be doing lot of large file import, extraction and exports. also, I intend to cahce a feew tables. I have 8GB of memory at my disposal. So theoritically I can use 4GB of Memory for oracle.