（2）进行了一堆操作和日志切换：

1. SQL> alter system switch logfile;
3. System altered.
5. SQL> create table a as select * from tabs;
7. Table created.
9. SQL> alter system switch logfile;
11. System altered.
13. SQL> create table b as select * from a;
15. Table created.
17. SQL> alter system switch logfile;

当前的日志序列：

1. SQL> select sequence# from v$log;
3. SEQUENCE#
4. ----------
5. 24
6. 22
7. 23

（3）关闭数据库，模拟故障：

1. SQL> shutdown abort;
2. ORACLE instance shut down

删除控制文件。

（4）启动数据库，因为没有控制文件，所以只能打开到nomount状态，这也是恢复所必须的状态：

1. SQL> startup
2. ORACLE instance started.
4. Total System Global Area 3221225472 bytes
5. Fixed Size 2024200 bytes
6. Variable Size 637537528 bytes
7. Database Buffers 2566914048 bytes
8. Redo Buffers 14749696 bytes
9. ORA-00205: error in identifying control file,
   check alert log for more info

（5）恢复控制文件：

1. [oracle@dbs cindytest]$ rman target /
3. Recovery Manager: Release 10.2.0.1.0 - Production
   on Wed Apr 13 11:38:56 2011
5. Copyright (c) 1982, 2005, Oracle. All rights reserved.
7. connected to target database: ctest (not mounted)
9. RMAN> restore controlfile from '/oracle/product/
   10G_single/dbs/c-539593454-20110413-00';
11. Starting restore at 13-APR-11
12. using target database control file instead of recovery catalog
13. allocated channel: ORA_DISK_1
14. channel ORA_DISK_1: sid=2486 devtype=DISK
16. channel ORA_DISK_1: restoring control file
17. channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
18. output filename=/zxm/cindytest/control01.ctl
19. Finished restore at 13-APR-11

把数据库打开到mount状态：

1. SQL> select status from v$instance;
3. STATUS
4. ------------
5. STARTED
7. SQL> alter database mount;
9. Database altered.
11. SQL> select sequence# from v$log;
13. SEQUENCE#
14. ----------
15. 21
16. 20
17. 19 David备注：v$log是从control file中提取的，备份时control file中的redo log序号最大还在21，备份后又做了三次log switch，因此上面查到的是22-24，这里查到的是19-21.

（6）恢复数据库，如果不用using子句，rman会提示：