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
db_block_buffers = 131072
shared_pool_size = 52428800
large_pool_size = 614400
java_pool_size = 20971520
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 200
log_buffer = 163840
compatible = "8.1.0"
# sort_area_size = 65536
sort_area_size = 131072
sort_area_retained_size = 65536
redolog files werte sized at 1MB each.
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.
Thanks in advance,