Author: mac

  • PRM-DUL在Linux/Unix VNC下的显示问题

    PRM-DUL在Linux/Unix  VNC下的显示问题,PRM-DUL在Linux VNC远程图形化下若出现无法显示菜单栏的问题,那么可以使用快捷键AlT+F7后来拖动窗口,显示出 PRM-DUL的图形化界面。 注意当使用PRM-DUL在恢复大数据量的数据库时优先考虑启用VNC,否则若Xmanager之类的工具出现中断,那么可能需要从头再。

  • Oracle STARTUP GIVES ORA-1172 AND ORA-600[3020]

    PROBLEM: Received ora-1172: recovery of thread %s stuck at block 15902 of file 6 during a startup of their database after a backup. It looks like their database was NOT shutdown normal before the backup, but instead was aborted. On trying to issue: recover datafile ‘<file 6>’, ct then receives ora-600[3020][402669086][1][64][1]…… 402669086 being the dba…

  • Oracle ASM COMMUNICATION ERROR CAUSING THE INSTANCE TO CRASH

    ASM communication error has been reported by RDBMS which is leading to instance crash. This has happened couple of times in last few months. There are two kind of ASM communication error happened: WARNING: ASM communication error: op 17 state 0x40 (21561) WARNING: ASM communication error: op 0 state 0x0 (15055) We are seeing this…

  • Oracle ASM DISKGROUP WILL NOT MOUNT AFTER ADDING DISKS

    This environment is using secure file. There is no backup due to customer ordering wrong hardware from Sun to perform the backup to. Customer tried to add 8 disks to the diskgroup. One of the disks added was slice2 which had the partition table for the disk on it. After the add failed and they…

  • Oracle ORA-600 [3020] , ORA-353 DURING DATABASE RECOVERY

    this happened 3 times  on 3 different archivedlogs in a recent recovery. Finally customers had to abort the recovery process and then use DUL to rebuild the database. About DUL & third party DUL-like tools Refer  http://parnassusdata.com/en/emergency-services  for more info. Are you sure that they have write-back caching rather than write-through caching?  If so, how did…

  • Oracle CORRUPTING DATABASE OPEN FAILS WITH ORA-704, ORA-376 AND ORA-1092

    full database restore from hot backup taken 03-SEPT. There has never been a backup of the undo tablespace so it was not restored. We updated the init.ora parameters to offline and corrupt the rollback segments and to allow corruption at resetlogs. After restore before recover the undo datafile (3) files 2, 103, and 103 were…

  • ORA-600 [KTSSDRO_SEGMENT1] ON STARTUP – DB OPENS, BUT CRASHES IMMEDIATELY

    CT was initially receiving an ORA-600[25012][1][3] This was doing an insert into a user table.  CT attempted to do an index rebuild on an index on the table, and the instance crashed.  Now, all attempts to open the DB result in ORA-600[ktssdro_segment1][1][12621530][0]. /* * Since we are committing after freeing every eight extents it is…

  • ORA-00600 [KDDUMMY_BLKCHK] RECURRING

    The exact error in that file is: ORA-600: internal error [kddummy_blkchk], [255], [2392], [6401] the error 6401 was detected for file 255 block 2392. Block Checking: DBA = 1069549912, Block Type = KTB-managed data block *** actual free space = 2612 < kdxcoavs = 2617 —- end index block validation rechecking block failed with error…

  • ORA-600 [KTSPSCANINIT-D]

    PROBLEM: ——– Ran the script and came back with table_act_entry. Can select from table_act_entry table with rownum<200 but other rownum options give error. Also attempted to analyze “SA”.”TABLE_ACT_ENTRY” table but receive same ORA-600 error. You can see from pasted data.  Can’t anaylze table_act_entry? SQL> select * from TABLE_ACT_ENTRY where rownum>100 and rownum<150; select * from…

  • Oracle system01.dbf corruption

    my oracle database died. The datafile system01.dbf was corrupt after a power outage. the server disks have several files corrupt including archivelogs the backup was lost Anyone know a strategy to recover this database? if not I need to extract data from an oracle to dbf csv someone knows a tool to do this?   Depending on the ‘corruption’  and condition of the other files, Oracle support may be able to help you force the database open in an inconsistent manner just…