pavnru
Дата: 11.12.2007 14:05:16
Доброе время суток...всем.
Есть, сервер NT4 sp6, ORACLE RDBMS Version: 8.1.6.3.0., база \\.\xxxxxxx.ODF,
control_files= \\.\ctl1back.ocf, \\.\ctl2back.ocf.
Работал бы еще сто лет, да недоследили,- переполнился диск OS.
После того как почистили, потеряли controlfile
alter database mount exclusive
Tue Dec 11 09:56:21 2007
ORA-00202: controlfile: '\\.\ctl2back.ocf'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
,
но один то живой, трудность в том, что живет он не на логическо диске OS NT4, а на логич.диске оракла. Как скопировать, переименовать данный файл в sqlplus?
Заранее спасибо.
P.S. alert вот такой,
Shutting down instance (immediate)
License high water mark = 4
Tue Dec 11 09:51:54 2007
alter database close normal
ORA-1507 signalled during: alter database close normal...
Dump file c:\data\ora\back\btrace\backALRT.LOG
Tue Dec 11 09:56:10 2007
ORACLE V8.1.6.3.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows NT Version 4.0 Service Pack 6, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.3.0.
System parameters with non-default values:
processes = 96
sessions = 110
timed_statistics = TRUE
shared_pool_size = 16777716
java_pool_size = 1000000
pre_page_sga = TRUE
enqueue_resources = 1500
control_files = \\.\ctl1back.ocf, \\.\ctl2back.ocf
db_block_buffers = 4096
db_block_size = 8192
compatible = 8.1.6.0.0
log_archive_start = TRUE
log_archive_dest = f:\data\ora\back\rlog\arc
log_archive_format = %S.olf
log_buffer = 524288
log_checkpoint_interval = 300000
db_files = 64
db_file_multiblock_read_count= 32
dml_locks = 500
transactions = 100
transactions_per_rollback_segment= 2
rollback_segments = RB00, RB01, RB02, RB03, RB04, RB05, RB06, RB07, RB08, RB09, RB10, RB11, RB12, RB13, RB14, RB15
max_enabled_roles = 140
remote_login_passwordfile= NONE
dblink_encrypt_login = TRUE
audit_trail = DB
sort_area_size = 16777716
sort_area_retained_size = 131072
db_name = back
open_cursors = 150
os_authent_prefix = OPS$
optimizer_mode = ALL_ROWS
always_anti_join = NESTED_LOOPS
utl_file_dir = c:\data\ora\back\utrace
job_queue_processes = 3
job_queue_interval = 5
parallel_max_servers = 0
hash_join_enabled = TRUE
hash_area_size = 131072
background_dump_dest = c:\data\ora\back\btrace
user_dump_dest = c:\data\ora\back\utrace
max_dump_file_size = 40960
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
Tue Dec 11 09:56:14 2007
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
ARC0: Archival started
Tue Dec 11 09:56:20 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue Dec 11 09:56:21 2007
alter database mount exclusive
Tue Dec 11 09:56:21 2007
ORA-00202: controlfile: '\\.\ctl2back.ocf'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.