Home » RDBMS Server » Server Utilities » Full Import error
Full Import error [message #314569] Thu, 17 April 2008 03:21 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
i have a development db server machine with oracle version 8.1.7 at Redhat AS 3

Now i am trying to do a full import on this machine (full export was done at another machine with the same db and os versions)
but when export was going on ,after 1-day the machine was held and didn't respond properly and we couldn't even logged on this machine ,after waiting 4 days we reboot the machine and checked that the import didn't complete and then i check the alertlog file and got the following entries:

Thread 1 advanced to log sequence 593554
  Current log# 3 seq# 593554 mem# 0: /u03/oracle/oradata/qamfg2/redo03.log
Sun Apr 13 22:55:11 2008
kccrsz: denied expansion of controlfile section 9 by 65535 record(s)
  the number of records is already at maximum value (65535)
krcpwnc: following controlfile record written over:
 RECID #528019 Recno 3739 Record timestamp
 04/13/08 16:26:16
 Thread=1 Seq#=528019 Link-Recid=528018
  Low
scn: 0x0000.009d762a
 04/13/08 16:26:16
 Next
scn: 0x0000.009d763c
Thread 1 advanced to log sequence 593555
  Current log# 1 seq# 593555 mem# 0: /u03/oracle/oradata/qamfg2/redo01.log

Please suggest!
thanx
Re: Full Import error [message #314571 is a reply to message #314569] Thu, 17 April 2008 03:32 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
the number of records is already at maximum value (65535)


The control file record reached at maximum value. Set it to low. Like,
CONTROL_FILE_RECORD_KEEP_TIME = 0 in init.ora and perform import now.
Re: Full Import error [message #314577 is a reply to message #314569] Thu, 17 April 2008 03:48 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Care about RMAN backup before setting CONTROL_FILE_RECORD_KEEP_TIME to zero.
Previous Topic: How to Check For Successful Exp/Imp
Next Topic: EXDP ERROR
Goto Forum:
  


Current Time: Sun Dec 04 10:57:10 CST 2016

Total time taken to generate the page: 0.07649 seconds