admin 管理员组

文章数量: 887021

oracle ora 01152,ORA

所有控制文件和数据文件丢失，使用rman从备份集中恢复：

SQL> startup;

ORACLE instance started.

Total System Global Area  218103808 bytes

Fixed Size                  1218604 bytes

Variable Size              62916564 bytes

Database Buffers          150994944 bytes

Redo Buffers                2973696 bytes

ORA-00205: error in identifying control file, check alert log for more info

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  218103808 bytes

Fixed Size                  1218604 bytes

Variable Size              62916564 bytes

Database Buffers          150994944 bytes

Redo Buffers                2973696 bytes

[oracle@centos ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Apr 9 06:01:06 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: orcl (not mounted)

RMAN>set dbid 1337758187-- 设置DBID

executing command: SET DBID

RMAN>restore controlfile from'/u01/app/oracle/flash_recovery_area/ORCL/autobackup/2013_04_08/o1_mf_s_812177402_8p3pzv19_.bkp';-- 恢复控制文件

Starting restore at 09-APR-13

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=155 devtype=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output filename=/u01/app/oracle/oradata/orcl/control01.ctl

output filename=/u01/app/oracle/oradata/orcl/control02.ctl

output filename=/u01/app/oracle/oradata/orcl/control03.ctl

本文标签： oracle ora 01152 ORA

版权声明：本文标题：oracle ora 01152,ORA 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.freenas.com.cn/free/1699467551h356025.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。