I am tying to login in to a the database as sys as sysdba or / as sysdba , but i get the following erro
the database wass working fine, but suddenly the power went off on the server, and I could't log in to Oracle
when i try to loging as sysdba it takes a while to give me the error message ora-12560
I tried to copy ORADATA and install oracle on another computer with same specs and same path and still got the same error message
Tue Dec 27 12:33:20 2016
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V6.1 Service Pack 1
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2059M/3504M, Ph+PgF:5276M/7007M, VA:1929M/2047M
Tue Dec 27 12:33:20 2016
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 260046848
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 335544320
compatible = 10.2.0.3.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\oracle\product\10.2.0\flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 10000
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=4372
PSP0 started with pid=3, OS id=5220
MMAN started with pid=4, OS id=6068
DBW0 started with pid=5, OS id=1344
LGWR started with pid=6, OS id=5804
CKPT started with pid=7, OS id=4888
SMON started with pid=8, OS id=5324
RECO started with pid=9, OS id=616
CJQ0 started with pid=10, OS id=1832
MMON started with pid=11, OS id=2396
Tue Dec 27 12:33:20 2016
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=4496
Tue Dec 27 12:33:20 2016
starting up 1 shared server(s) ...
Tue Dec 27 12:33:20 2016
alter database mount exclusive
Tue Dec 27 12:33:25 2016
Setting recovery target incarnation to 2
Tue Dec 27 12:33:25 2016
Successful mount of redo thread 1, with mount id 1459492752
Tue Dec 27 12:33:25 2016
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue Dec 27 12:33:25 2016
alter database open
Tue Dec 27 12:33:26 2016
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Tue Dec 27 12:33:26 2016
Started redo scan
Tue Dec 27 12:33:27 2016
Completed redo scan
88431 redo blocks read, 5255 data blocks need recovery
Tue Dec 27 12:33:30 2016
Hex dump of (file 3, block 47941) in trace file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p001_5120.trc
Corrupt block relative dba: 0x00c0bb45 (file 3, block 47941)
Fractured block found during crash/instance recovery
Data in bad block:
type: 6 format: 2 rdba: 0x00c0bb45
last change scn: 0x0000.158fc63a seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x12de0601
check value in block header: 0x6774
computed block checksum: 0xd4e4
Tue Dec 27 12:33:30 2016
Hex dump of (file 3, block 38605) in trace file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p002_5360.trc
Tue Dec 27 12:33:30 2016
Reread of rdba: 0x00c0bb45 (file 3, block 47941) found same corrupted data
Tue Dec 27 12:33:30 2016
Hex dump of (file 3, block 29653) in trace file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p000_5472.trc
Corrupt block relative dba: 0x00c073d5 (file 3, block 29653)
Fractured block found during crash/instance recovery
Data in bad block:
type: 6 format: 2 rdba: 0x00c073d5
last change scn: 0x0000.160d286a seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0xfcb40601
check value in block header: 0x89c5
computed block checksum: 0xd6df
Tue Dec 27 12:33:30 2016
Hex dump of (file 3, block 47933) in trace file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p001_5120.trc
Corrupt block relative dba: 0x00c0bb3d (file 3, block 47933)
Fractured block found during crash/instance recovery
Data in bad block:
type: 6 format: 2 rdba: 0x00c0bb3d
last change scn: 0x0000.160cdbc0 seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0xd9ba0601
check value in block header: 0x10bd
computed block checksum: 0x179
Tue Dec 27 12:33:30 2016
Reread of rdba: 0x00c073d5 (file 3, block 29653) found same corrupted data
Tue Dec 27 12:33:30 2016
Reread of rdba: 0x00c0bb3d (file 3, block 47933) found same corrupted data
Hex dump of (file 3, block 47925) in trace file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p001_5120.trc
Corrupt block relative dba: 0x00c0bb35 (file 3, block 47925)
Fractured block found during crash/instance recovery
Data in bad block:
type: 6 format: 2 rdba: 0x00c0bb35
last change scn: 0x0000.160d0f24 seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0xd9ba0601
check value in block header: 0xf28
computed block checksum: 0xd59d
Reread of rdba: 0x00c0bb35 (file 3, block 47925) found same corrupted data
Hex dump of (file 3, block 1325) in trace file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p001_5120.trc
Corrupt block relative dba: 0x00c0052d (file 3, block 1325)
Fractured block found during crash/instance recovery
Data in bad block:
type: 6 format: 2 rdba: 0x00c0052d
last change scn: 0x0000.159d9e99 seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x93060601
check value in block header: 0x6d6c
computed block checksum: 0xd9f
Reread of rdba: 0x00c0052d (file 3, block 1325) found same corrupted data
Hex dump of (file 3, block 1317) in trace file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p001_5120.trc
Corrupt block relative dba: 0x00c00525 (file 3, block 1317)
Fractured block found during crash/instance recovery
Data in bad block:
type: 6 format: 2 rdba: 0x00c00525
last change scn: 0x0000.160d0f24 seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x02bb0601
check value in block header: 0x4e26
computed block checksum: 0xd9f
Reread of rdba: 0x00c00525 (file 3, block 1317) found same corrupted data
Corrupt block relative dba: 0x00c096cd (file 3, block 38605)
Fractured block found during crash/instance recovery
Data in bad block:
type: 6 format: 2 rdba: 0x00c096cd
last change scn: 0x0000.15f21533 seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0xf6f50601
check value in block header: 0x3114
computed block checksum: 0xe1c7
Tue Dec 27 12:33:31 2016
Reread of rdba: 0x00c096cd (file 3, block 38605) found same corrupted data
Hex dump of (file 3, block 38597) in trace file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p002_5360.trc
Corrupt block relative dba: 0x00c096c5 (file 3, block 38597)
Fractured block found during crash/instance recovery
Data in bad block:
type: 6 format: 2 rdba: 0x00c096c5
last change scn: 0x0000.15f3ece2 seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x0f240601
check value in block header: 0x5b78
computed block checksum: 0xe1c7
Reread of rdba: 0x00c096c5 (file 3, block 38597) found same corrupted data
Tue Dec 27 12:33:31 2016
Started redo application at
Thread 1: logseq 4131, block 72312
Tue Dec 27 12:33:31 2016
Recovery of Online Redo Log: Thread 1 Group 2 Seq 4131 Reading mem 0
Mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Tue Dec 27 12:33:31 2016
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p002_5360.trc:
ORA-00600: internal error code, arguments: [6122], [15], [2], [0], [], [], [], []
Tue Dec 27 12:33:33 2016
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p002_5360.trc:
ORA-01578: ORACLE data block corrupted (file # 3, block # 43837)
ORA-01110: data file 3: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF'
ORA-10564: tablespace SYSAUX
ORA-01110: data file 3: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 4216
ORA-00600: internal error code, arguments: [6122], [15], [2], [0], [], [], [], []
Tue Dec 27 12:33:33 2016
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p001_5120.trc:
ORA-00600: internal error code, arguments: [6104], [13], [], [], [], [], [], []
Tue Dec 27 12:33:35 2016
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p001_5120.trc:
ORA-01578: ORACLE data block corrupted (file # 3, block # 47938)
ORA-01110: data file 3: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF'
ORA-10564: tablespace SYSAUX
ORA-01110: data file 3: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 4216
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [6104], [13], [], [], [], [], [], []
Tue Dec 27 12:33:35 2016
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p001_5120.trc:
ORA-00600: internal error code, arguments: [6102], [194], [3], [], [], [], [], []
Tue Dec 27 12:33:37 2016
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p001_5120.trc:
ORA-01578: ORACLE data block corrupted (file # 3, block # 47934)
ORA-01110: data file 3: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF'
ORA-10564: tablespace SYSAUX
ORA-01110: data file 3: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 4216
ORA-00600: internal error code, arguments: [6102], [194], [3], [], [], [], [], []