123йй,

SYSTEM as SYSDBA
alter database open
*
ошибка в строке 1:
ORA-01034: ORACLE not available

По третьему пункту и контрольному можно подробнее?)

123йй,

Прописываю в SQL*Plus Worksheet
Соединено
При попытке открыть базу сразу уходит в Shutdown и все

123йй,

Wed Oct 03 13:53:49 2018
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 192937984
large_pool_size = 142606336
java_pool_size = 33554432
control_files = C:\oracle\oradata\GAS\control01.ctl, C:\oracle\oradata\GAS\control02.ctl, C:\oracle\oradata\GAS\control03.ctl
db_block_size = 8192
db_cache_size = 578813952
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = GAS
dispatchers = (PROTOCOL=TCP) (SERVICE=GASXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\GAS\bdump
user_dump_dest = C:\oracle\admin\GAS\udump
core_dump_dest = C:\oracle\admin\GAS\cdump
sort_area_size = 524288
db_name = GAS
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 513802240
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Oct 03 13:53:52 2018
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Oct 03 13:53:53 2018
/* OracleOEM */ ALTER DATABASE MOUNT
Wed Oct 03 13:53:57 2018
Successful mount of redo thread 1, with mount id 1491708337
Wed Oct 03 13:53:57 2018
Database mounted in Exclusive Mode.
ORA-1991 signalled during: /* OracleOEM */ ALTER DATABASE MOUNT...
Wed Oct 03 13:59:53 2018
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Oct 03 14:04:10 2018
/* OracleOEM */ ALTER DATABASE OPEN
Wed Oct 03 14:04:11 2018
Beginning crash recovery of 1 threads
Wed Oct 03 14:04:11 2018
Started redo scan
Wed Oct 03 14:04:11 2018
Completed redo scan
388 redo blocks read, 130 data blocks need recovery
Wed Oct 03 14:04:11 2018
Started recovery at
Thread 1: logseq 3251, block 3, scn 0.0
Wed Oct 03 14:04:12 2018
Recovery of Online Redo Log: Thread 1 Group 1 Seq 3251 Reading mem 0
Mem# 0 errs 0: C:\ORACLE\ORADATA\GAS\REDO01.LOG
Wed Oct 03 14:04:12 2018
Completed redo application
Wed Oct 03 14:04:13 2018
Ended recovery at
Thread 1: logseq 3251, block 391, scn 0.544335645
130 data blocks read, 130 data blocks written, 388 redo blocks read
Crash recovery completed successfully
Wed Oct 03 14:04:14 2018
Thread 1 advanced to log sequence 3252
Thread 1 opened at log sequence 3252
Current log# 2 seq# 3252 mem# 0: C:\ORACLE\ORADATA\GAS\REDO02.LOG
Successful open of redo thread 1
Wed Oct 03 14:04:14 2018
SMON: enabling cache recovery
Wed Oct 03 14:04:15 2018
Successfully onlined Undo Tablespace 1.
Wed Oct 03 14:04:15 2018
SMON: enabling tx recovery
Wed Oct 03 14:04:15 2018
Database Characterset is CL8MSWIN1251
Wed Oct 03 14:04:15 2018
SMON: Restarting fast_start parallel rollback
SMON: ignoring slave err,downgrading to serial rollback
ORACLE Instance gas (pid = 6) - Error 1578 encountered while recovering transaction (9, 16) on object 33423.
Wed Oct 03 14:04:15 2018
Errors in file c:\oracle\admin\gas\bdump\gas_smon_5044.trc:
ORA-01578: ORACLE data block corrupted (file # 1, block # 2115854)
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\GAS\SYSTEM01.DBF'

Wed Oct 03 14:04:16 2018
Errors in file c:\oracle\admin\gas\bdump\gas_smon_5044.trc:
ORA-00600: internal error code, arguments: [17182], [0x425834C], [], [], [], [], [], []
ORA-01578: ORACLE data block corrupted (file # 1, block # 2115854)
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\GAS\SYSTEM01.DBF'

Wed Oct 03 14:04:16 2018
replication_dependency_tracking turned off (no async multimaster replication found)
Wed Oct 03 14:04:20 2018
Errors in file c:\oracle\admin\gas\bdump\gas_pmon_5268.trc:
ORA-00474: SMON process terminated with error

Wed Oct 03 14:04:20 2018
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 5268


И снова все вот так

Мне просто интересно возможно ли каким либо образом вытащить только то, что нужно? Есть вот в списке, который я приложил таблица, которая нужна (видимо, и какая-то часть из других системных файлов). Остальное можно потерять.

123йй,

Нет, не короткая, это вопрос в дополнение. С Вашими ответами я полезной информации не получил то ли из-за непонимания (взаимного), то ли из-за моей непрофессиональности.

maverick2104,

Я честно говоря думал, что форумы созданы для помощи) Ну такое себе, конечно. В каждой теме нет практически ни одного дельного совета, только "тыканье котенка". В общем-то снова все понятно, спасибо, что хотя бы не послали. На форумах по Firebird поговорим)

Если можно, закройте тему.