Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

276231May 16 2002
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?

Comments

30614
This may be a blindingly obvious question but do you have sufficient disk space on /sisdev01/dbs/ partition?
276231
Would you mind telling me how to check it?

Thanks,
Victor
30614
If it's AIX it's

cd /sisdev01
df -k .

for all volumes use

df -k


nshe_dba
df will work but you'll get more info on HP-UX with
bdf
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 13 2002
Added on May 16 2002
4 comments
1,764 views