channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /opt/oracle/oradata/orcl/system01.dbf restoring datafile 00002 to /opt/oracle/oradata/orcl/undotbs01.dbf restoring datafile 00003 to /opt/oracle/oradata/orcl/sysaux01.dbf restoring datafile 00004 to /opt/oracle/oradata/orcl/users01.dbf restoring datafile 00005 to /opt/oracle/oradata/orcl/example01.dbf restoring datafile 00006 to /opt/oracle/oradata/db/reporter.dbf restoring datafile 00007 to /opt/oracle/oradata/db/sm_db.dbf restoring datafile 00008 to /opt/oracle/product/10g/dbs/nhnmcc_data.data channel ORA_DISK_1: reading from backup piece /opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_nnndf_TAG20091022T143121_5fzz1t8k_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_nnndf_TAG20091022T143121_5fzz1t8k_.bkp tag=TAG20091022T143121 channel ORA_DISK_1: restore complete, elapsed time: 00:02:38
Finished restore at 2009-10-22 17:26:09
RMAN> recover database until time '2009-10-22 14:37:00';
Starting recover at 2009-10-22 17:26:58
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:05
Finished recover at 2009-10-22 17:27:04
最后，alter database open resetlogs;
注：备份时archivelog状态，恢复时候mount状态；
可能用到的命令sql>alter session set NLS_date_format = 'YYYY-MM-DD HH24:MI:SS'
责任编辑：小草
您现在的位置： 