数保软件服务热线

您当前的位置:主页 > 成功案例 > 助吉林XX数据库无数据丢失恢复(成功)

  2010-4-15晚上,远程支持吉林XX行业oracle 9i数据库,进行数据恢复。

    故障现象:oracle 9i for aix 平台,基于裸设备管理方式,oracle 无法打开,表现为current redolog  坏掉(联机事务日志故障)。oracle数据库,没有备份,非归档方式下进行数据恢复。

 

    atafile 68: '/dev/rdatafile_026_2g'
Media Recovery Log 
ORA-279 signalled during: ALTER DATABASE RECOVER  database until cancel  ...
Thu Apr 15 21:30:00 2010
ALTER DATABASE RECOVER    CANCEL  
ORA-1547 signalled during: ALTER DATABASE RECOVER    CANCEL  ...
Thu Apr 15 21:30:01 2010
ALTER DATABASE RECOVER CANCEL 
ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL ...
Thu Apr 15 21:47:00 2010
Starting ORACLE instance (normal)
Thu Apr 15 21:49:08 2010
alter database open resetlogs
Thu Apr 15 21:49:08 2010
RESETLOGS is being done without consistancy checks. This may result
in a corrupted database. The database should be recreated.
RESETLOGS after incomplete recovery UNTIL CHANGE 11130549508528
Resetting resetlogs activation ID 481851456 (0x1cb87840)
Thu Apr 15 21:49:42 2010
Assigning activation ID 481804476 (0x1cb7c0bc)
Thread 1 opened at log sequence 1
  Current log# 3 seq# 1 mem# 0: /dev/rlog3a_512m
Successful open of redo thread 1.
Thu Apr 15 21:49:42 2010
SMON: enabling cache recovery
Thu Apr 15 21:49:43 2010
Errors in file /oracle/app/product/9.2.0/admin/ora9/udump/ora9_ora_561230.trc:
ORA-00600: internal error code, arguments: [2662], [2591], [2289244597], [2591], [2291418205], [8388617], [], []
Thu Apr 15 21:49:43 2010
Errors in file /oracle/app/product/9.2.0/admin/ora9/udump/ora9_ora_561230.trc:
ORA-00600: internal error code, arguments: [2662], [2591], [2289244597], [2591], [2291418205], [8388617], [], []
Thu Apr 15 21:49:43 2010
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Thu Apr 15 21:49:43 2010
Errors in file /oracle/app/product/9.2.0/admin/ora9/bdump/ora9_pmon_598070.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
Thu Apr 15 21:49:45 2010
Errors in file /oracle/app/product/9.2.0/admin/ora9/bdump/ora9_ckpt_549026.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
Thu Apr 15 21:49:46 2010
Errors in file /oracle/app/product/9.2.0/admin/ora9/bdump/ora9_dbw0_581718.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
Thu Apr 15 21:49:46 2010
Errors in file /oracle/app/product/9.2.0/admin/ora9/bdump/ora9_lgwr_565388.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
Thu Apr 15 21:49:53 2010
Instance terminated by USER, pid = 561230
ORA-1092 signalled during: alter database open resetlogs...

       经过晚上努力配合,远程支持服务,实现联机远程处理,终于完成oracle 9i数据库恢复。

相关案例


Copyright © 2015-2022 长沙数保信息科技有限公司 ┇ 湘ICP备08103633号 湘公网安备 43011102000746号

地址:长沙市岳麓区润花园D1-903 公司邮箱:dpisi@163.com
7*24小时技术支持服务热线:0731-85057097/13607439515 QQ: 400528 或 156462627

湘公网安备 43011102000746号