4 Replies Latest reply on May 16, 2002 4:11 PM by nshe_dba

    ORA-19510 failed to set size of 12288 blocks for file "/sisdev01/dbs/log01b.dbf

    276231
      My company's harddisk has corrupted and files under /sisdev01/dbs/ cannot list and don't have any backup, then I have to create a new database again after changing the disk and recovering the data. I plan to reuse the /sisdev01/dbs/ as following.

      I fail in creating database by using the following script:
      CREATE DATABASE SISDEV01
           LOGFILE GROUP 1 '/sisdev01/dbs/log01a.dbf' SIZE 10M
           ,     GROUP 1 '/sisdev01/dbs/log01b.dbf' SIZE 10M
           ,     GROUP 2 '/sisdev01/dbs/log02a.dbf' SIZE 10M
           ,     GROUP 2 '/sisdev01/dbs/log02b.dbf' SIZE 10M
           NOARCHIVELOG
           CHARACTER SET ZHT16BIG5
           NATIONAL CHARACTER SET ZHT16BIG5
           DATAFILE '/sisdev01/dbs/system01.dbf'      
                SIZE 210M AUTOEXTEND OFF
           , '/sisdev01/dbs/rbs01.dbf'
      SIZE 105M AUTOEXTEND OFF
           , '/sisdev01/dbs/temp01.dbf'
      SIZE 105M AUTOEXTEND OFF
           , '/sisdev01/dbs/users01.dbf'
      SIZE 1050M AUTOEXTEND OFF
           , '/sisdev01/dbs/ts_index_ivr01.dbf'
      SIZE 105M AUTOEXTEND OFF
           , '/sisdev01/dbs/ts_ivr01.dbf'
      SIZE 21M AUTOEXTEND OFF
           , '/sisdev01/dbs/ts_ems01.dbf'
      SIZE 21M AUTOEXTEND OFF
           , '/sisdev01/dbs/ts_index_ems01.dbf'
      SIZE 21M AUTOEXTEND OFF
      ;

      but I receive error message:
      CREATE DATABASE SISDEV01
      *
      ORA-01501: CREATE DATABASE failed
      ORA-19510: failed to set size of 12288 blocks for file "/sisdev01/dbs/log01b.dbf
      " (blocksize=512)
      ORA-27059: skgfrsz: could not reduce file size
      IBM AIX RISC System/6000 Error: 28: No space left on device
      Additional information: 1
      ORA-19502: write error on file "/sisdev01/dbs/log01b.dbf", blockno 8193 (blocksi
      ze=512)
      ORA-27063: skgfospo: number of bytes read/written is incorrect
      IBM AIX RISC System/6000 Error: 28: No space left on device
      Additional information: -1
      Additional information: 524288

      Here is the content of my parameter file:
      db_file_multiblock_read_count = 8 # SMALL
      # db_file_multiblock_read_count = 16 # MEDIUM
      # db_file_multiblock_read_count = 32 # LARGE

      # db_block_buffers = 60 # SMALL
      db_block_buffers = 550 # MEDIUM
      # db_block_buffers = 3200 # LARGE

      # shared_pool_size = 3500000 # SMALL
      shared_pool_size = 5000000 # MEDIUM
      # shared_pool_size = 9000000 # LARGE

      log_checkpoint_interval = 10000

      processes = 400 # SMALL
      # processes = 100 # MEDIUM
      # processes = 200 # LARGE

      dml_locks = 100 # SMALL
      # dml_locks = 200 # MEDIUM
      # dml_locks = 500 # LARGE

      # log_buffer = 8192 # SMALL
      log_buffer = 32768 # MEDIUM
      # log_buffer = 163840 # LARGE

      # audit_trail = true # if you want auditing
      # timed_statistics = true # if you want timed statistics
      max_dump_file_size = 10240 # limit trace file size to 5 Meg each

      # Uncommenting the line below will cause automatic archiving if archiving has
      # been enabled using ALTER DATABASE ARCHIVELOG.
      log_archive_start = false
      log_archive_dest = /u01/sisdev01_arch
      log_archive_format = arch%s.dbf

      # If using private rollback segments, place lines of the following
      # form in each of your instance-specific init.ora files:
      rollback_segments = (r01, r02)

      # If using public rollback segments, define how many
      # rollback segments each instance will pick up, using the formula
      # # of rollback segments = transactions / transactions_per_rollback_segment
      # In this example each instance will grab 40/10 = 4:
      transactions = 40
      transactions_per_rollback_segment = 10

      # Global Naming -- enforce that a dblink has same name as the db it connects to
      global_names = TRUE

      # Edit and uncomment the following line to provide the suffix that will be
      # appended to the db_name parameter (separated with a dot) and stored as the
      # global database name when a database is created. If your site uses
      # Internet Domain names for e-mail, then the part of your e-mail address after
      # the '@' is a good candidate for this parameter value.

      # db_domain = us.acme.com # global database name is db_name.db_domain

      # define two control files by default
      # control_files = (/sisuat02/dbs/ctl01.ora,/sisuat02/dbs/ctl02.ora)
      control_files = (/sisdev01/dbs/ctl01.ora,/sisdev01/dbs/ctl02.ora)
      DB_NAME=sisdev01
      DB_BLOCK_SIZE=8192
      # DB_BLOCK_LRU_LATCHES=4
      DB_FILES=500
      DB_DOMAIN=shk.sony.com.hk
      background_dump_dest = /u01/dba/sisdev01/log
      user_dump_dest = /u01/dba/sisdev01/log
      NLS_LANGUAGE="traditional chinese"
      NLS_TERRITORY="hong kong"
      NLS_CURRENCY="HK$ "
      NLS_DATE_FORMAT="DD/MM/YYYY"
      NLS_NUMERIC_CHARACTERS=".,"

      utl_file_dir = *

      compatible = 8.1.5
      remote_os_authent = TRUE

      sort_area_size = 65536
      sort_area_retained_size = 65536

      It always fail during creation of logfile log01b.dbf.

      I have tried to send same size logfiles to the directory but it fails too when inserting the second logfile log01b.dbf too.
      NETOUT: 10054
      452 Error writing file: Error 0

      Can anyone kindly help me?