3,490
社区成员
发帖
与我相关
我的任务
分享
再看一下备份集
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
1 22.89M DISK 00:00:03 2009-07-14 19:09:29
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20090714T190926
Piece Name: /backup/rman_bk/SINGLE_1_1.bak
List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 11 173335 2009-07-13 15:55:13 180113 2009-07-14 19:09:23
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2 Full 356.73M DISK 00:00:41 2009-07-14 19:10:12
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20090714T190930
Piece Name:
/database/oracle/flash_recovery_area/SINGLE/backupset/2009_07_14/o1_mf_nnndf_TAG20090714T190
930_55rsvcg8_.bkp
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 180120 2009-07-14 19:09:31 /database/oracle/oradata/single/system01.dbf
2 Full 180120 2009-07-14 19:09:31 /database/oracle/oradata/single/undotbs01.dbf
3 Full 180120 2009-07-14 19:09:31 /database/oracle/oradata/single/sysaux01.dbf
4 Full 180120 2009-07-14 19:09:31 /database/oracle/oradata/single/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
3 Full 6.77M DISK 00:00:01 2009-07-14 19:10:17
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20090714T190930
Piece Name:
/database/oracle/flash_recovery_area/SINGLE/backupset/2009_07_14/o1_mf_ncnnf_TAG20090714T190
930_55rsws06_.bkp
Control File Included: Ckp SCN: 180141 Ckp time: 2009-07-14 19:10:16
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
4 11.00K DISK 00:00:01 2009-07-14 19:10:19
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20090714T191018
Piece Name: /backup/rman_bk/SINGLE_4_1.bak
List of Archived Logs in backup set 4
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 12 180113 2009-07-14 19:09:23 180144 2009-07-14 19:10:18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
5 Full 6.80M DISK 00:00:01 2009-07-14 19:10:21
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20090714T191020
Piece Name:
/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_07_14/o1_mf_s_692219420_55rswxkm
_.bkp
Control File Included: Ckp SCN: 180150 Ckp time: 2009-07-14 19:10:20
SPFILE Included: Modification time: 2009-07-14 19:06:08
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
6 Full 386.41M DISK 00:00:42 2009-08-15 06:24:27
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20090815T062345
Piece Name: /backup/rman_bk/SINGLE_6_1.bak
List of Datafiles in backup set 6
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 265852 2009-08-15 06:23:45 /database/oracle/oradata/single/system01.dbf
2 Full 265852 2009-08-15 06:23:45 /database/oracle/oradata/single/undotbs01.dbf
3 Full 265852 2009-08-15 06:23:45 /database/oracle/oradata/single/sysaux01.dbf
4 Full 265852 2009-08-15 06:23:45 /database/oracle/oradata/single/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
7 Full 6.80M DISK 00:00:02 2009-08-15 06:24:34
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20090815T062432
Piece Name:
/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694938272_58cs11tf
_.bkp
Control File Included: Ckp SCN: 265880 Ckp time: 2009-08-15 06:24:32
SPFILE Included: Modification time: 2009-08-15 06:17:15
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
8 Incr 0 386.62M DISK 00:00:41 2009-08-15 06:30:55
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063014
Piece Name: /backup/rman_bk/0_SINGLE_8_1.bak
List of Datafiles in backup set 8
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 0 Incr 266106 2009-08-15 06:30:15 /database/oracle/oradata/single/system01.dbf
2 0 Incr 266106 2009-08-15 06:30:15 /database/oracle/oradata/single/undotbs01.dbf
3 0 Incr 266106 2009-08-15 06:30:15 /database/oracle/oradata/single/sysaux01.dbf
4 0 Incr 266106 2009-08-15 06:30:15 /database/oracle/oradata/single/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
9 Full 6.80M DISK 00:00:00 2009-08-15 06:37:41
BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063741
Piece Name:
/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939061_58cssp0n
_.bkp
Control File Included: Ckp SCN: 266935 Ckp time: 2009-08-15 06:37:41
SPFILE Included: Modification time: 2009-08-15 06:17:15
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
10 Full 6.80M DISK 00:00:00 2009-08-15 06:39:22
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063922
Piece Name:
/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939162_58cswv6x
_.bkp
Control File Included: Ckp SCN: 267025 Ckp time: 2009-08-15 06:39:22
SPFILE Included: Modification time: 2009-08-15 06:17:15
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
11 Full 6.80M DISK 00:00:00 2009-08-15 06:31:02
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063102
Piece Name:
/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694938662_58csf6hn
_.bkp
Control File Included: Ckp SCN: 266133 Ckp time: 2009-08-15 06:31:02
SPFILE Included: Modification time: 2009-08-15 06:17:15
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
12 Incr 2 624.00K DISK 00:00:00 2009-08-15 06:37:16
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063715
Piece Name: /backup/rman_bk/2_SINGLE_12_1.bak
List of Datafiles in backup set 12
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 2 Incr 266922 2009-08-15 06:37:16 /database/oracle/oradata/single/system01.dbf
2 2 Incr 266922 2009-08-15 06:37:16 /database/oracle/oradata/single/undotbs01.dbf
3 2 Incr 266922 2009-08-15 06:37:16 /database/oracle/oradata/single/sysaux01.dbf
4 2 Incr 266922 2009-08-15 06:37:16 /database/oracle/oradata/single/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
13 Incr 0 6.77M DISK 00:00:00 2009-08-15 06:31:00
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063014
Piece Name: /backup/rman_bk/0_SINGLE_9_1.bak
Control File Included: Ckp SCN: 266129 Ckp time: 2009-08-15 06:31:00
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
14 Incr 2 6.77M DISK 00:00:00 2009-08-15 06:36:27
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063626
Piece Name: /backup/rman_bk/2_SINGLE_11_1.bak
Control File Included: Ckp SCN: 266897 Ckp time: 2009-08-15 06:36:27
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
15 Incr 2 320.00K DISK 00:00:00 2009-08-15 06:38:56
BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063856
Piece Name: /backup/rman_bk/2_SINGLE_14_1.bak
List of Datafiles in backup set 15
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 2 Incr 266977 2009-08-15 06:38:56 /database/oracle/oradata/single/system01.dbf
2 2 Incr 266977 2009-08-15 06:38:56 /database/oracle/oradata/single/undotbs01.dbf
3 2 Incr 266977 2009-08-15 06:38:56 /database/oracle/oradata/single/sysaux01.dbf
4 2 Incr 266977 2009-08-15 06:38:56 /database/oracle/oradata/single/users01.dbf
全都有了,开始恢复操作
RMAN> run {
2> restore database;
3> recover database;
4> sql 'alter database open';
5> }
先看一下备份集都有什么
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
1 22.89M DISK 00:00:03 2009-07-14 19:09:29
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20090714T190926
Piece Name: /backup/rman_bk/SINGLE_1_1.bak
List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 11 173335 2009-07-13 15:55:13 180113 2009-07-14 19:09:23
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2 Full 356.73M DISK 00:00:41 2009-07-14 19:10:12
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20090714T190930
Piece Name:
/database/oracle/flash_recovery_area/SINGLE/backupset/2009_07_14/o1_mf_nnndf_TAG20090714T190
930_55rsvcg8_.bkp
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 180120 2009-07-14 19:09:31 /database/oracle/oradata/single/system01.dbf
2 Full 180120 2009-07-14 19:09:31 /database/oracle/oradata/single/undotbs01.dbf
3 Full 180120 2009-07-14 19:09:31 /database/oracle/oradata/single/sysaux01.dbf
4 Full 180120 2009-07-14 19:09:31 /database/oracle/oradata/single/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
3 Full 6.77M DISK 00:00:01 2009-07-14 19:10:17
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20090714T190930
Piece Name:
/database/oracle/flash_recovery_area/SINGLE/backupset/2009_07_14/o1_mf_ncnnf_TAG20090714T190
930_55rsws06_.bkp
Control File Included: Ckp SCN: 180141 Ckp time: 2009-07-14 19:10:16
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
4 11.00K DISK 00:00:01 2009-07-14 19:10:19
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20090714T191018
Piece Name: /backup/rman_bk/SINGLE_4_1.bak
List of Archived Logs in backup set 4
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 12 180113 2009-07-14 19:09:23 180144 2009-07-14 19:10:18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
5 Full 6.80M DISK 00:00:01 2009-07-14 19:10:21
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20090714T191020
Piece Name:
/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_07_14/o1_mf_s_692219420_55rswxkm
_.bkp
Control File Included: Ckp SCN: 180150 Ckp time: 2009-07-14 19:10:20
SPFILE Included: Modification time: 2009-07-14 19:06:08
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
6 Full 386.41M DISK 00:00:42 2009-08-15 06:24:27
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20090815T062345
Piece Name: /backup/rman_bk/SINGLE_6_1.bak
List of Datafiles in backup set 6
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 265852 2009-08-15 06:23:45 /database/oracle/oradata/single/system01.dbf
2 Full 265852 2009-08-15 06:23:45 /database/oracle/oradata/single/undotbs01.dbf
3 Full 265852 2009-08-15 06:23:45 /database/oracle/oradata/single/sysaux01.dbf
4 Full 265852 2009-08-15 06:23:45 /database/oracle/oradata/single/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
7 Full 6.80M DISK 00:00:02 2009-08-15 06:24:34
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20090815T062432
Piece Name:
/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694938272_58cs11tf
_.bkp
Control File Included: Ckp SCN: 265880 Ckp time: 2009-08-15 06:24:32
SPFILE Included: Modification time: 2009-08-15 06:17:15
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
8 Incr 0 386.62M DISK 00:00:41 2009-08-15 06:30:55
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063014
Piece Name: /backup/rman_bk/0_SINGLE_8_1.bak
List of Datafiles in backup set 8
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 0 Incr 266106 2009-08-15 06:30:15 /database/oracle/oradata/single/system01.dbf
2 0 Incr 266106 2009-08-15 06:30:15 /database/oracle/oradata/single/undotbs01.dbf
3 0 Incr 266106 2009-08-15 06:30:15 /database/oracle/oradata/single/sysaux01.dbf
4 0 Incr 266106 2009-08-15 06:30:15 /database/oracle/oradata/single/users01.dbf
没有增量备份,追加一下
RMAN> catalog start with '/backup/rman_bk';
Starting implicit crosscheck backup at 2009-08-15 06:58:14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK
Crosschecked 8 objects
Finished implicit crosscheck backup at 2009-08-15 06:58:15
Starting implicit crosscheck copy at 2009-08-15 06:58:15
using channel ORA_DISK_1
Crosschecked 1 objects
Finished implicit crosscheck copy at 2009-08-15 06:58:16
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name:
/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939061_58cssp0n
_.bkp
File Name:
/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939162_58cswv6x
_.bkp
File Name:
/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694938662_58csf6hn
_.bkp
searching for all files that match the pattern /backup/rman_bk
List of Files Unknown to the Database
=====================================
File Name: /backup/rman_bk/2_SINGLE_12_1.bak
File Name: /backup/rman_bk/0_SINGLE_9_1.bak
File Name: /backup/rman_bk/2_SINGLE_11_1.bak
File Name: /backup/rman_bk/2_SINGLE_14_1.bak
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /backup/rman_bk/2_SINGLE_12_1.bak
File Name: /backup/rman_bk/0_SINGLE_9_1.bak
File Name: /backup/rman_bk/2_SINGLE_11_1.bak
File Name: /backup/rman_bk/2_SINGLE_14_1.bak
SINGLE (DBID=3664176175)
原库的ID
RMAN> backup incremental level 0 format='/backup/rman_bk/0_%d_%s_%p.bak'
2> database include current controlfile;
Starting backup at 2009-08-15 06:30:14
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/database/oracle/oradata/single/system01.dbf
input datafile fno=00002 name=/database/oracle/oradata/single/undotbs01.dbf
input datafile fno=00003 name=/database/oracle/oradata/single/sysaux01.dbf
input datafile fno=00004 name=/database/oracle/oradata/single/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2009-08-15 06:30:15
channel ORA_DISK_1: finished piece 1 at 2009-08-15 06:31:00
piece handle=/backup/rman_bk/0_SINGLE_8_1.bak tag=TAG20090815T063014 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:46
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 2009-08-15 06:31:00
channel ORA_DISK_1: finished piece 1 at 2009-08-15 06:31:01
piece handle=/backup/rman_bk/0_SINGLE_9_1.bak tag=TAG20090815T063014 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2009-08-15 06:31:01
Starting Control File and SPFILE Autobackup at 2009-08-15 06:31:02
piece
handle=/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694938662_5
8csf6hn_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2009-08-15 06:31:03
RMAN> sql 'alter system archive log current';
sql statement: alter system archive log current
RMAN> backup incremental level 2 format='/backup/rman_bk/2_%d_%s_%p.bak'
2> database ;
Starting backup at 2009-08-15 06:37:15
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 2 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/database/oracle/oradata/single/system01.dbf
input datafile fno=00002 name=/database/oracle/oradata/single/undotbs01.dbf
input datafile fno=00003 name=/database/oracle/oradata/single/sysaux01.dbf
input datafile fno=00004 name=/database/oracle/oradata/single/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2009-08-15 06:37:16
channel ORA_DISK_1: finished piece 1 at 2009-08-15 06:37:41
piece handle=/backup/rman_bk/2_SINGLE_12_1.bak tag=TAG20090815T063715 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 2009-08-15 06:37:41
Starting Control File and SPFILE Autobackup at 2009-08-15 06:37:41
piece
handle=/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939061_5
8cssp0n_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2009-08-15 06:37:44
RMAN> sql 'alter system archive log current';
sql statement: alter system archive log current
RMAN> backup incremental level 2 format='/backup/rman_bk/2_%d_%s_%p.bak'
2> database ;
Starting backup at 2009-08-15 06:38:56
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 2 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/database/oracle/oradata/single/system01.dbf
input datafile fno=00002 name=/database/oracle/oradata/single/undotbs01.dbf
input datafile fno=00003 name=/database/oracle/oradata/single/sysaux01.dbf
input datafile fno=00004 name=/database/oracle/oradata/single/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2009-08-15 06:38:56
channel ORA_DISK_1: finished piece 1 at 2009-08-15 06:39:21
piece handle=/backup/rman_bk/2_SINGLE_14_1.bak tag=TAG20090815T063856 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26
Finished backup at 2009-08-15 06:39:22
Starting Control File and SPFILE Autobackup at 2009-08-15 06:39:22
piece
handle=/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939162_5
8cswv6x_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2009-08-15 06:39:25
RMAN> sql 'alter system archive log current';
sql statement: alter system archive log current
0级备份和2级增量备份都有了
之后我用dbca把原库删掉,这个跟你的条件基本一样了
然后我重建了init文件
看下我的备份目录都有什么
-bash-3.1$ ls -l /backup/rman_bk
total 830772
-rw-r----- 1 oracle dba 405405696 Aug 15 06:30 0_SINGLE_8_1.bak
-rw-r----- 1 oracle dba 7110656 Aug 15 06:31 0_SINGLE_9_1.bak
-rw-r----- 1 oracle dba 7110656 Aug 15 06:36 2_SINGLE_11_1.bak
-rw-r----- 1 oracle dba 647168 Aug 15 06:37 2_SINGLE_12_1.bak
-rw-r----- 1 oracle dba 335872 Aug 15 06:39 2_SINGLE_14_1.bak
-rw-r----- 1 oracle dba 24004096 Jul 14 19:09 SINGLE_1_1.bak
-rw-r----- 1 oracle dba 11776 Jul 14 19:10 SINGLE_4_1.bak
-rw-r----- 1 oracle dba 405184512 Aug 15 06:24 SINGLE_6_1.bak
之后我用rman连接
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Aug 15 06:48:50 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database (not started)
RMAN> startup nomount
Oracle instance started
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 83888372 bytes
Database Buffers 79691776 bytes
Redo Buffers 2973696 bytes
RMAN> set dbid=3664176175
executing command: SET DBID
RMAN> restore controlfile from '/backup/rman_bk/0_SINGLE_9_1.bak';
Starting restore at 2009-08-15 06:55:24
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
output filename=/database/oracle/oradata/single/control01.ctl
output filename=/database/oracle/oradata/single/control02.ctl
output filename=/database/oracle/oradata/single/control03.ctl
Finished restore at 2009-08-15 06:55:29
RMAN> sql 'alter database mount';
sql statement: alter database mount
released channel: ORA_DISK_1
RMAN>startup nomount
RMAN>set dbid=你库的id
RMAN>run {
2>allocate channel m1 type disk;
3>restore controlfile from '你知道的备份控制文件的那个备份片';
4>}