首页 > Linux操作系统 > Linux操作系统 > Oracle 10G恢复实战
[oracle@RHEL5 oradata]$ rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jun 13 14:59:16 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database (not started)
RMAN> restore spfile from '/home/oracle/software/app/oracle/flash_recovery_area/ORCL/autobackup/2011_06_13/o1_mf_s_753718540_6zcbrfm3_.bkp';
Starting restore at 13-JUN-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=36 devtype=DISK
channel ORA_DISK_1: autobackup found: /home/oracle/software/app/oracle/flash_recovery_area/ORCL/autobackup/2011_06_13/o1_mf_s_753718540_6zcbrfm3_.bkp
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 13-JUN-11
RMAN> run
2> {
3> startup nomount;
4> }
Oracle instance started
Total System Global Area 1241513984 bytes
Fixed Size 1267212 bytes
Variable Size 318769652 bytes
Database Buffers 905969664 bytes
Redo Buffers 15507456 bytes
RMAN> restore controlfile from autobackup;
Starting restore at 13-JUN-11
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: /home/oracle/software/app/oracle/flash_recovery_area
database name (or database unique name) used for search: ORCL
channel ORA_DISK_1: autobackup found in the recovery area
channel ORA_DISK_1: autobackup found: /home/oracle/software/app/oracle/flash_recovery_area/ORCL/autobackup/2011_06_13/o1_mf_s_753718540_6zcbrfm3_.bkp
channel ORA_DISK_1: control file restore from autobackup complete
output filename=……/oradata/orcl/control01.ctl
output filename=……/oradata/orcl/control02.ctl
output filename=……/oradata/orcl/control03.ctl
Finished restore at 13-JUN-11
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> list backup;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-697846/ ,如需转载,请注明出处,否则将追究法律责任。