分类:
2008-10-17 13:25:39
$ rman target /
![]()
Recovery Manager: Release 10.1.0.2.0 - 64bit Production
![]()
Copyright (c) 1995, 2004, . All rights reserved.
![]()
connected to target database: EYGLE (DBID=1337390772)
![]()
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: TAG20050329T065513
Piece Name: /data5/flash_recovery_area/EYGLE/backupset/
2005_03_29/o1_mf_nnndf_TAG20050329T065513_14k2tmx7_.bkp
List of Datafiles in backup set 17
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 10605717 29-MAR-05 /opt/oracle/oradata/eygle/system01.dbf
RMAN> startup mount; connected to target database (not started) instance started database mounted Total System Global Area 314572800 bytes Fixed Size 1301704 bytes Variable Size 261890872 bytes Database Buffers 50331648 bytes Redo Buffers 1048576 bytes
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/system01.dbf channel ORA_DISK_1: restored backup piece 1 piece handle=/data5/flash_recovery_area/EYGLE/backupset/2005_03_29/ o1_mf_nnndf_TAG20050329T065513_14k2tmx7_.bkp tag=TAG20050329T065513 channel ORA_DISK_1: restore complete Finished restore at 30-MAR-05