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?