Chinaunix首页 | 论坛 | 博客
  • 博客访问: 6523840
  • 博文数量: 1005
  • 博客积分: 8199
  • 博客等级: 中将
  • 技术积分: 13071
  • 用 户 组: 普通用户
  • 注册时间: 2010-05-25 20:19
个人简介

脚踏实地、勇往直前!

文章分类

全部博文(1005)

文章存档

2020年(2)

2019年(93)

2018年(208)

2017年(81)

2016年(49)

2015年(50)

2014年(170)

2013年(52)

2012年(177)

2011年(93)

2010年(30)

分类: Oracle

2012-11-10 23:09:36

环境:
OS:AIX 5.3
DB:11.2.0.1.0
 
1.备份控制文件和数据文件
cp *.ctl /oracle_bak/
cp *.dbf /oracle_bak/
 
2.删除控制文件和数据文件
[hxl:oracle:/u01/app/oracle/oradata/oracl]$rm *.ctl
[hxl:oracle:/u01/app/oracle/oradata/oracl]$ls
hxl01.dbf      redo0201.log   redo0302.log   temp01.dbf
redo0101.log   redo0202.log   sysaux01.dbf   undotbs01.dbf
redo0102.log   redo0301.log   system01.dbf   users01.dbf
[hxl:oracle:/u01/app/oracle/oradata/oracl]$rm *.dbf
 
3.尝试打开数据库
[hxl:oracle:/u01/app/oracle/oradata/oracl]$sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Sat Nov 10 21:27:23 2012
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area  626327552 bytes
Fixed Size                  2209376 bytes
Variable Size             209717664 bytes
Database Buffers          411041792 bytes
Redo Buffers                3358720 bytes
ORA-00205: error in identifying control file, check alert log for more info
 
4.查看日志文件
SQL> show parameters dump
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial
background_dump_dest                 string      /u01/app/oracle/diag/rdbms/ora
                                                 cl/oracl/trace
core_dump_dest                       string      /u01/app/oracle/diag/rdbms/ora
                                                 cl/oracl/cdump
max_dump_file_size                   string      unlimited
shadow_core_dump                     string      partial
user_dump_dest                       string      /u01/app/oracle/diag/rdbms/ora
                                                 cl/oracl/trace
alert日志文件存放目录如下:
/u01/app/oracle/diag/rdbms/oracl/oracl/trace
查看日志文件
ALTER DATABASE   MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/oracl/control03.ctl'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/oracl/control01.ctl'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: ALTER DATABASE   MOUNT...
Sat Nov 10 21:27:36 2012
Checker run found 2 new persistent data failures
如上提示控制文件不存在
 
5.恢复控制文件
[hxl/root]#cp *.ctl /u01/app/oracle/oradata/oracl/
6.尝试打开数据库
SQL> alter database mount
  2  /
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/u01/app/oracle/oradata/oracl/system01.dbf'
提示数据文件不存在
 
7.恢复数据文件
cp *.dbf /u01/app/oracle/oradata/oracl/

8.再次尝试打开数据库
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
 
9.恢复数据库
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
如上提示需要使用BACKUP CONTROLFILE选项
 
10.使用BACKUP CONTROLFILE选项恢复数据库
SQL> recover database using backup controlfile;
ORA-00279: change 1291380 generated at 11/10/2012 20:52:11 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/flash_recovery_area/ORACL/archivelog/2012_11_10/o1_mf_1_22_%u_.a
rc
ORA-00280: change 1291380 for thread 1 is in sequence #22

Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/u01/app/oracle/flash_recovery_area/ORACL/archivelog/2012_11_10/o1_mf_1_22_%u_.
arc'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log
'/u01/app/oracle/flash_recovery_area/ORACL/archivelog/2012_11_10/o1_mf_1_22_%u_.
arc'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
如上提示找不到seq=22的归档日志,因为seq=22是在线redo,还未归档,当然找不到.
 
11.使用重建控制文件的办法打开数据库
SQL>alter database backup controlfile to trace;
在/u01/app/oracle/diag/rdbms/oracl/oracl/trace目录下的trc文件中找到如下部分,注意这里选择NORESETLOGS做完全恢复
SQL>shutdown immediate
SQL>startup nomount
SQL>set sqlblanklines on
SQL>CREATE CONTROLFILE REUSE DATABASE "ORACL" NORESETLOGS  ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 (
    '/u01/app/oracle/oradata/oracl/redo0101.log',
    '/u01/app/oracle/oradata/oracl/redo0102.log'
  ) SIZE 50M BLOCKSIZE 512,
  GROUP 2 (
    '/u01/app/oracle/oradata/oracl/redo0201.log',
    '/u01/app/oracle/oradata/oracl/redo0202.log'
  ) SIZE 50M BLOCKSIZE 512,
  GROUP 3 (
    '/u01/app/oracle/oradata/oracl/redo0301.log',
    '/u01/app/oracle/oradata/oracl/redo0302.log'
  ) SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/u01/app/oracle/oradata/oracl/system01.dbf',
  '/u01/app/oracle/oradata/oracl/sysaux01.dbf',
  '/u01/app/oracle/oradata/oracl/undotbs01.dbf',
  '/u01/app/oracle/oradata/oracl/users01.dbf',
  '/u01/app/oracle/oradata/oracl/hxl01.dbf'
CHARACTER SET ZHS16GBK
;
12.打开数据库
SQL> alter database open;
Database altered.
 
-- The End --
阅读(4420) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~