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:
Total System Global Area 1183438972 bytes
Fixed Size 116860 bytes
Variable Size 109408256 bytes
Database Buffers 1073741824 bytes
Redo Buffers 172032 bytes
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.
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.