【控制文件丢失-恢复-1】(二)
pt的，所以只能是shutdown abort;
SQL> shutdown immediate
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/oracle/oradata/jadl10g/control01.ctl'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> shutdown abort
ORACLE instance shut down.
部分性丢失拷贝存在的为丢失的文件，不需要rman做恢复：
[oracle@oracle ~]$ cp /u01/oracle/flash_recovery_area/jadl10g/control02.ctl /u01/oracle/oradata/jadl10g/control01.ctl
[oracle@oracle ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Thu Nov 6 10:47:13 2014
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 599785472 bytes
Fixed Size 2098112 bytes
Variable Size 163580992 bytes
Database Buffers 427819008 bytes
Redo Buffers 6287360 bytes
Database mounted.
Database opened.
2.全部丢失
删除所有的控制文件：
[oracle@oracle ~]$ rm /u01/oracle/oradata/jadl10g/control01.ctl
[oracle@oracle ~]$ rm /u01/oracle/flash_recovery_area/jadl10g/control02.ctl
[oracle@oracle ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Thu Nov 6 10:50:22 2014
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine
and Real Application Testing options
SQL> shutdown immediate ---不能一致性关闭数据库
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/oracle/oradata/jadl10g/control01.ctl'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL>
shutdown abort ---只能这样关闭数据库
ORACLE instance shut down.
连接到rman：
[oracle@oracle ~]$ rman target /
Recovery Manager: Release 10.2.0.5.0 - Production on Thu Nov 6 10:52:18 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database (not started)
RMAN> startup nomount --启动数据库到nomount阶段
Oracle instance started
Total System Global Area 599785472 bytes
Fixed Size 2098112 bytes
Variable Size 163580992 bytes
Database Buffers 427819008 bytes
Redo Buffers 6287360 bytes
RMAN> restore controlfile from autobackup; ---该命令只能在打开了自动备份的情况下执行；
Starting restore at 06-NOV-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
recovery area destination: /u01/oracle/flash_recovery_area
database name (or database unique name) used for search: JADL10G
channel ORA_DISK_1: no autobackups found in the recovery area
autobackup search outside recovery area not attempted because DBID was not set
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/06/2014 10:52:59
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
---出错是由于没有打开自动备份
RMAN> exit
Recovery Manager complete.
找到文件的备份集：
[oracle@oracle ~]$ ls /u01/oracle/flash_recovery_area/JADL10G/backupset/
2014_11_05 2014_11_06
[oracle@oracle ~]$ ls /