Results 1 to 2 of 2

Thread: Please help me

  1. #1
    Join Date
    Feb 2003
    Location
    Thailand
    Posts
    42

    Cool Unanswered: Please help me

    I load data using dcp but log full . I stop and start database . It show error on error log . please look at . I tried to dump tran but I couldn't .
    I alter database but I couldn't . Please suggest me
    **********************************
    00:00000:00001:2003/06/03 16:54:58.64 server Recovering database 'core_sips_251_his'.
    00:00000:00001:2003/06/03 16:57:17.63 server Redo pass: 0 records done (0%); 6123160 records left.
    00:00000:00001:2003/06/03 16:58:55.72 server Redo pass: 306158 records done (5%); 5817002 records left.
    00:00000:00001:2003/06/03 16:59:48.36 server Redo pass: 612316 records done (10%); 5510844 records left.
    00:00000:00001:2003/06/03 17:00:37.47 server Redo pass: 918474 records done (15%); 5204686 records left.
    00:00000:00001:2003/06/03 17:01:27.85 server Redo pass: 1224632 records done (20%); 4898528 records left.
    00:00000:00001:2003/06/03 17:02:26.20 server Redo pass: 1530790 records done (25%); 4592370 records left.
    00:00000:00001:2003/06/03 17:03:27.35 server Redo pass: 1836948 records done (30%); 4286212 records left.
    00:00000:00001:2003/06/03 17:04:31.83 server Redo pass: 2143106 records done (35%); 3980054 records left.
    00:00000:00001:2003/06/03 17:05:39.64 server Redo pass: 2449264 records done (40%); 3673896 records left.
    00:00000:00001:2003/06/03 17:06:46.75 server Redo pass: 2755422 records done (45%); 3367738 records left.
    00:00000:00001:2003/06/03 17:07:56.13 server Redo pass: 3061580 records done (50%); 3061580 records left.
    00:00000:00001:2003/06/03 17:09:08.47 server Redo pass: 3367738 records done (55%); 2755422 records left.
    00:00000:00001:2003/06/03 17:10:19.97 server Redo pass: 3673896 records done (60%); 2449264 records left.
    00:00000:00001:2003/06/03 17:11:38.76 server Redo pass: 3980054 records done (65%); 2143106 records left.
    00:00000:00001:2003/06/03 17:12:24.87 server Redo pass: 4286212 records done (70%); 1836948 records left.
    00:00000:00001:2003/06/03 17:13:07.82 server Redo pass: 4592370 records done (75%); 1530790 records left.
    00:00000:00001:2003/06/03 17:13:54.81 server Redo pass: 4898528 records done (80%); 1224632 records left.
    00:00000:00001:2003/06/03 17:14:43.29 server Redo pass: 5204686 records done (85%); 918474 records left.
    00:00000:00001:2003/06/03 17:16:36.12 server Redo pass: 5510844 records done (90%); 612316 records left.
    00:00000:00001:2003/06/03 17:21:59.73 server Redo pass: 5817002 records done (95%); 306158 records left.
    00:00000:00001:2003/06/03 17:27:19.62 server Redo pass of recovery has processed 12 committed and 0 aborted transactions.
    00:00000:00001:2003/06/03 17:27:22.16 server Undo pass: 11 records done (0%); 6123120 records left.
    00:00000:00001:2003/06/03 17:27:22.86 server Undo pass: 306167 records done (5%); 5816964 records left.
    00:00000:00001:2003/06/03 17:27:23.56 server Undo pass: 612323 records done (10%); 5510808 records left.
    00:00000:00001:2003/06/03 17:27:24.26 server Undo pass: 918479 records done (15%); 5204652 records left.
    00:00000:00001:2003/06/03 17:27:24.96 server Undo pass: 1224635 records done (20%); 4898496 records left.
    00:00000:00001:2003/06/03 17:27:26.82 server Undo pass: 1530791 records done (25%); 4592340 records left.
    00:00000:00001:2003/06/03 17:28:38.96 server Undo pass: 1836947 records done (30%); 4286184 records left.
    00:00000:00001:2003/06/03 17:29:51.60 server Undo pass: 2143103 records done (35%); 3980028 records left.
    00:00000:00001:2003/06/03 17:34:41.01 server Undo pass: 2449259 records done (40%); 3673872 records left.
    00:00000:00001:2003/06/03 17:39:07.06 server Undo pass: 2755415 records done (45%); 3367716 records left.
    00:00000:00001:2003/06/03 17:41:45.29 server Undo pass: 3061571 records done (50%); 3061560 records left.
    00:00000:00001:2003/06/03 17:44:21.48 server Undo pass: 3367727 records done (55%); 2755404 records left.
    00:00000:00001:2003/06/03 17:46:57.83 server Undo pass: 3673883 records done (60%); 2449248 records left.
    00:00000:00001:2003/06/03 17:49:34.41 server Undo pass: 3980039 records done (65%); 2143092 records left.
    00:00000:00001:2003/06/03 17:52:12.80 server Undo pass: 4286195 records done (70%); 1836936 records left.
    00:00000:00001:2003/06/03 17:53:15.32 server Error: 1105, Severity: 17, State: 3
    00:00000:00001:2003/06/03 17:53:15.37 server Can't allocate space for object 'syslogs' in database 'core_sips_251_his' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase size of the segment.
    00:00000:00001:2003/06/03 17:53:15.37 server Error: 3475, Severity: 21, State: 7
    00:00000:00001:2003/06/03 17:53:15.37 server There is no space available in SYSLOGS for process 1 to log a record for which space has been reserved. This process will retry at intervals of one minute. The internal error number is -4.
    ---------------------------------------------
    1> use core_sips_251_his
    2> go
    Msg 921, Level 14, State 1
    , Line 1
    Database 'core_sips_251_his' has not been recovered yet - please wait and try again.

    ----------------------------------------------------
    1> ALTER DATABASE core_sips_251_his log on usrtran3=100
    2> go
    Extending database by 51200 pages on disk usrtran3
    Msg 921, Level 14, State 1
    , Line 1
    Database 'core_sips_251_his' has not been recovered yet - please wait and try again.

    ----------------------------------------------------------
    1> sp_who
    2> go
    fid spid status loginame origname
    hostname blk dbname cmd
    ------ ------ ------------ ------------------------------ ------------------------------
    ---------- ----- ------------------------------ ----------------
    0 1 background NULL NULL
    0 core_sips_251_his MAINTENANCE TOKE

  2. #2
    Join Date
    May 2003
    Location
    Rochester, NY
    Posts
    135

    Re: Please help me

    If he table has any indexes, drop them first to eliminate logging and
    recreate after the load has finished. This will eliminate some logging as
    well as speed up the load.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •