控制文件的恢复(一)
DB:Oracle 11g 11.2.0.3.0 X86_64,OS RHEL 6.3 X86_64,未使用Recovery Catalog
一、利用在线镜像备份恢复
理想的情况下控制文件已经跨磁盘、跨驱动器做了在线镜像备份,只要不是所有的控制文件损害,可以使用在线镜像备份轻松的恢复,例如:
SYS@orcl>show parameter control_files ---查看所有控制文件保存的位置
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u01/app/oracle/oradata/orcl/c
ontrol01.ctl, /u01/app/oracle/
fast_recovery_area/orcl/contro
l02.ctl, /u01/app/oracle/orada
ta/orcl/control03.ctl
SYS@orcl>host rm /u01/app/oracle/fast_recovery_area/orcl/control02.ctl ---为测试删除control02.ctl
SYS@orcl>create tablespace testts datafile '/u01/app/oracle/oradata/testts01.dbf' size 10m; ---必须所有的控制文件都正确才行,只要有一个控制文件损坏就报错
create tablespace testts datafile '/u01/app/oracle/oradata/testts01.dbf' size 10m
*
ERROR at line 1:
ORA-00227: corrupt block detected in control file: (block 1, # blocks 1)
ORA-00202: control file:
'/u01/app/oracle/fast_recovery_area/orcl/control02.ctl'
SYS@orcl>shutdown immediate; ---此时不能用shutdown immediate命令关闭数据库
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/fast_recovery_area/orcl/control02.ctl'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
ORACLE instance shut down.
---查看警告日志和trace文件可以查看更详细的信息
[oracle@ora ~]$ vi /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.
DB:Oracle 11g 11.2.0.3.0 X86_64,OS RHEL 6.3 X86_64,未使用Recovery Catalog
一、利用在线镜像备份恢复
理想的情况下控制文件已经跨磁盘、跨驱动器做了在线镜像备份,只要不是所有的控制文件损害,可以使用在线镜像备份轻松的恢复,例如:
SYS@orcl>show parameter control_files ---查看所有控制文件保存的位置
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u01/app/oracle/oradata/orcl/c
ontrol01.ctl, /u01/app/oracle/
fast_recovery_area/orcl/contro
l02.ctl, /u01/app/oracle/orada
ta/orcl/control03.ctl
SYS@orcl>host rm /u01/app/oracle/fast_recovery_area/orcl/control02.ctl ---为测试删除control02.ctl
SYS@orcl>create tablespace testts datafile '/u01/app/oracle/oradata/testts01.dbf' size 10m; ---必须所有的控制文件都正确才行,只要有一个控制文件损坏就报错
create tablespace testts datafile '/u01/app/oracle/oradata/testts01.dbf' size 10m
*
ERROR at line 1:
ORA-00227: corrupt block detected in control file: (block 1, # blocks 1)
ORA-00202: control file:
'/u01/app/oracle/fast_recovery_area/orcl/control02.ctl'
SYS@orcl>shutdown immediate; ---此时不能用shutdown immediate命令关闭数据库
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/fast_recovery_area/orcl/control02.ctl'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORACLE instance shut down.
---查看警告日志和trace文件可以查看更详细的信息
[oracle@ora ~]$ vi /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.