如果是单独的system数据文件损坏,那么不必创建控制文件,
执行运行下面的
-bash-3.2$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Mar 13 11:18:10 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: DEV02 (DBID=3591414394, not open)
RMAN> Run{
2> ALLOCATE CHANNEL ch00 TYPE sbt parms 'ENV=(ob_media_family=zone04-mf)';
3> restore datafile 1;
4> recover datafile 1;
5> RELEASE CHANNEL ch00;
6> }
using target database control file instead of recovery catalog
allocated channel: ch00
channel ch00: SID=551 device type=SBT_TAPE
channel ch00: Oracle Secure Backup
Starting restore at 13-MAR-13
channel ch00: starting datafile backup set restore
channel ch00: specifying datafile(s) to restore from backup set
channel ch00: restoring datafile 00001 to /export/zones/zone04/root/uat_data/DEV02/apps_st/data/system01.dbf
channel ch00: reading from backup piece bk_4_1_809884168
channel ch00: piece handle=bk_4_1_809884168 tag=HOT_DB_BK_LEVEL0
channel ch00: restored backup piece 1
channel ch00: restore complete, elapsed time: 00:03:15
Finished restore at 13-MAR-13
Starting recover at 13-MAR-13
starting media recovery
archived log for thread 1 with sequence 5 is already on disk as file /export/zones/zone04/root/uat_data/DEV02/apps_st/archlog_dev/1_5_809863429.dbf
archived log for thread 1 with sequence 6 is already on disk as file /export/zones/zone04/root/uat_data/DEV02/apps_st/archlog_dev/1_6_809863429.dbf
archived log for thread 1 with sequence 7 is already on disk as file /export/zones/zone04/root/uat_data/DEV02/apps_st/archlog_dev/1_7_809863429.dbf
archived log for thread 1 with sequence 8 is already on disk as file /export/zones/zone04/root/uat_data/DEV02/apps_st/archlog_dev/1_8_809863429.dbf
archived log file name=/export/zones/zone04/root/uat_data/DEV02/apps_st/archlog_dev/1_5_809863429.dbf thread=1 sequence=5
media recovery complete, elapsed time: 00:00:01
Finished recover at 13-MAR-13
released channel: ch00
RMAN> alter database open;
database opened
RMAN>
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/24862808/viewspace-756547/ ,如需转载,请注明出处,否则将追究法律责任。