数据库恢复历史再次刷新到Oracle 7.3.2版本—redo异常恢复

有网友在QQ上找我,说Oracle 7.3的数据库,因为redo异常咨询我是否可以恢复 检查数据库得到以下信息 SVRMGR select * from v$version;BANNER—————————————————————-Oracle7 Workgroup Server Release 7.3.2.2.1 – P

有网友在QQ上找我,说Oracle 7.3的数据库,因为redo异常咨询我是否可以恢复

SVRMGR> select * from v$version;BANNER----------------------------------------------------------------Oracle7 Workgroup Server Release 7.3.2.2.1 - Production ReleasePL/SQL Release 2.3.2.2.0 - ProductionCORE Version 3.5.2.0.0 - ProductionTNS for 32-bit Windows: Version 2.3.2.1.0 - ProductionNLSRTL Version 3.2.2.0.0 - Production已选择 5 行

数据文件信息

License high water mark = 2Starting up ORACLE RDBMS Version: 7.3.2.2.1.System parameters with non-default values:  processes                = 800  shared_pool_size         = 540000000  control_files            = D:\ORANT\DATABASE\ctl1orcl.ora, D:\ORANT\DATABASE\ctl2orcl.ora  compatible               = 7.3.0.0.0  log_buffer               = 327680  log_checkpoint_interval  = 1000000  db_files                 = 40  db_file_simultaneous_writes= 1280  max_rollback_segm<i style="color:transparent">本文来源gaodai$ma#com搞$代*码6网</i>ents    = 12800  _offline_rollback_segments= RB13, RB14, RB15, RB16, RB20  _corrupted_rollback_segments= RB13, RB14, RB15, RB16, RB20  sequence_cache_entries   = 100  sequence_cache_hash_buckets= 100  remote_login_passwordfile= SHARED  mts_servers              = 0  mts_max_servers          = 0  mts_max_dispatchers      = 0  audit_trail              = NONE  sort_area_retained_size  = 65536  sort_direct_writes       = AUTO  db_name                  = oracle  open_cursors             = 800  text_enable              = TRUE  snapshot_refresh_processes= 1  background_dump_dest     = %RDBMS73%\trace  user_dump_dest           = %RDBMS73%\traceMon Jun 16 16:46:57 2014PMON startedMon Jun 16 16:46:57 2014DBWR startedMon Jun 16 16:46:57 2014LGWR startedMon Jun 16 16:46:57 2014RECO startedMon Jun 16 16:46:57 2014SNP0 startedMon Jun 16 16:46:57 2014alter database  mount exclusiveMon Jun 16 16:46:58 2014Successful mount of redo thread 1.Mon Jun 16 16:46:58 2014Completed: alter database  mount exclusiveMon Jun 16 16:48:15 2014alter database openMon Jun 16 16:48:16 2014Beginning crash recovery of 1 threadsCrash recovery completed successfullyMon Jun 16 16:48:17 2014Thread 1 advanced to log sequence 9  Current log# 1 seq# 9 mem# 0: D:\ORANT\DATABASE\LOG2ORCL.ORAThread 1 opened at log sequence 9  Current log# 1 seq# 9 mem# 0: D:\ORANT\DATABASE\LOG2ORCL.ORASuccessful open of redo thread 1.Mon Jun 16 16:48:18 2014SMON: enabling cache recoveryMon Jun 16 16:48:19 2014Completed: alter database openMon Jun 16 16:48:20 2014SMON: enabling tx recoverySMON: about to recover undo segment 14SMON: mark undo segment 14 as needs recoverySMON: about to recover undo segment 15SMON: mark undo segment 15 as needs recoverySMON: about to recover undo segment 16SMON: mark undo segment 16 as needs recoverySMON: about to recover undo segment 17SMON: mark undo segment 17 as needs recoverySMON: about to recover undo segment 18SMON: mark undo segment 18 as needs recoveryMon Jun 16 16:48:20 2014Errors in file D:\ORANT\RDBMS73\trace\orclSMON.TRC:ORA-00600: internal error code, arguments: [4306], [21], [2], [], [], [], [], []

喜欢 (0)赏

[搞代码]

分享 (0)