oracle 10g rman备份与恢复之四(三)
e
RMAN>set dbid 3778783462 （直接启动如果有问题，再设置一下dbid）
RMAN>startup
RMAN> shutdown immediate
database closed
database dismounted
Oracle instance shut down
RMAN> startup nomount
connected to target database (not started)
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/ora10g/product/10.2.0/db_1/dbs/initwolf.ora'
starting Oracle instance without parameter file for retrival of spfile
Oracle instance started
Total System Global Area 159383552 bytes
Fixed Size 1218268 bytes
Variable Size 54528292 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
RMAN> set dbid 3778783462
executing command: SET DBID
RMAN> restore spfile from autobackup;
Starting restore at 21-4月 -13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=36 devtype=DISK
channel ORA_DISK_1: looking for autobackup on day: 20130421
channel ORA_DISK_1: looking for autobackup on day: 20130420
channel ORA_DISK_1: looking for autobackup on day: 20130419
channel ORA_DISK_1: looking for autobackup on day: 20130418
channel ORA_DISK_1: looking for autobackup on day: 20130417
channel ORA_DISK_1: looking for autobackup on day: 20130416
channel ORA_DISK_1: looking for autobackup on day: 20130415
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/21/2013 10:02:43
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
RMAN>
RMAN> restore spfile from '/oracle/ora10g/flash_recovery_area/WOLF/backupset/2013_04_21/o1_mf_ncsnf_TAG20130421T095042_8q7vtb8b_.bkp';
Starting restore at 21-4月 -13
using channel ORA_DISK_1
channel ORA_DISK_1: autobackup found: /oracle/ora10g/flash_recovery_area/WOLF/backupset/2013_04_21/o1_mf_ncsnf_TAG20130421T095042_8q7vtb8b_.bkp
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 21-4月 -13
（[root@redhat dbs]# ls
hc_wolf.dat init.ora lkWOLF snapcf_wolf.f spfilewolf.ora.bak
initdw.ora lkDUMMY orapwwolf spfilewolf.ora
）
RMAN> shutdown immediate
Oracle instance shut down
RMAN> startup
connected to target database (not started)
Oracle instance started
database mounted
database opened
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 92276304 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
RMAN>