使用进行基于表空间的恢复物业

示范案例，仅供参考:

1.察看备份文件

$ rman target / Recovery Manager: Release 10.1.0.2.0 - 64bit Production Copyright (c) 1995, 2004, Oracle. All rights reserved. connected to target database: EYGLE (DBID=) RMAN list backup of datafile 1; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 17 Full 131M DISK 00:01:50 29-MAR-05 BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAGT065513 Piece Name: /data5/flash_recovery_area/EYGLE/backupset/ 2005_03_29/o1_mf_nnndf_TAGT065513_14k2tmx7_.bkp List of Datafiles in backup set 17 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 29-MAR-05 /opt/oracle/oradata/eygle/f

unt数据库

RMAN startup mount; connected to target database (not started) Oracle instance started database mounted Total System Global Area bytes Fixed Size bytes Variable Size bytes Database Buffers bytes Redo Buffers bytes

还有副作用 3.恢复数据文件

RMAN restore datafile 1; Starting restore at 30-MAR-05 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=160 devtype=DISK channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /opt/oracle/oradata/eygle/f channel ORA_DISK_1: restored backup piece 1 piece handle=/data5/flash_recovery_area/EYGLE/backupset/2005_03_29/ o1_mf_nnndf_TAGT065513_14k2tmx7_.bkp tag=TAGT065513 channel ORA_DISK_1: restore complete Finished restore at 30-MAR-05

查看本文来源