oracle 10g rman备份与恢复之五(五)
5:10 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: WOLF (DBID=3753890021, not open)
RMAN> restore database;
Starting restore at 22-4月 -13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 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/app/oracle/oradata/wolf/system01.dbf
restoring datafile 00002 to /opt/app/oracle/oradata/wolf/undotbs01.dbf
restoring datafile 00003 to /opt/app/oracle/oradata/wolf/sysaux01.dbf
restoring datafile 00004 to /opt/app/oracle/oradata/wolf/users01.dbf
restoring datafile 00005 to /opt/app/oracle/oradata/wolf/wolfblock01.dbf
restoring datafile 00006 to /opt/app/oracle/oradata/wolf/wolf01
restoring datafile 00007 to /opt/app/oracle/oradata/wolf/rman_wolf.dbf
channel ORA_DISK_1: reading from backup piece /opt/app/oracle/flash_recovery_area/WOLF/backupset/2013_04_22/o1_mf_nnndf_TAG20130422T091128_8qbfr0t1_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/opt/app/oracle/flash_recovery_area/WOLF/backupset/2013_04_22/o1_mf_nnndf_TAG20130422T091128_8qbfr0t1_.bkp tag=TAG20130422T091128
channel ORA_DISK_1: restore complete, elapsed time: 00:05:03
Finished restore at 22-4月 -13
RMAN> recover database;
Starting recover at 22-4月 -13
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:19
Finished recover at 22-4月 -13
RMAN> alter database open;
database opened
查看日志信息
Additional information: 3
Mon Apr 22 10:07:20 2013
Full restore complete of datafile 4 /opt/app/oracle/oradata/wolf/users01.dbf. Elapsed time: 0:00:10
checkpoint is 762512
Mon Apr 22 10:07:38 2013
Full restore complete of datafile 6 /opt/app/oracle/oradata/wolf/wolf01. Elapsed time: 0:00:30
checkpoint is 762512
Mon Apr 22 10:07:52 2013
Full restore complete of datafile 7 /opt/app/oracle/oradata/wolf/rman_wolf.dbf. Elapsed time: 0:00:44
checkpoint is 762512
Mon Apr 22 10:09:11 2013
Full restore complete of datafile 2 /opt/app/oracle/oradata/wolf/undotbs01.dbf. Elapsed time: 0:02:04
checkpoint is 762512
Mon Apr 22 10:09:26 2013
Full restore complete of datafile 5 /opt/app/oracle/oradata/wolf/wolfblock01.dbf. Elapsed time: 0:02:19
checkpoint is 762512
Mon Apr 22 10:11:13 2013
Full restore complete of datafile 3 /opt/app/oracle/oradata/wolf/sysaux01.dbf. Elapsed time: 0:04:08
checkpoint is 762512
Mon Apr 22 10:11:52 2013
Full restore complete of datafile 1 /opt/app/oracle/oradata/wolf/system01.dbf. Elapsed time: 0:04:47
checkpoint is 762512
Mon Apr 22 10:18:43 2013
db_recovery_file_dest_size of 3072 MB is 19.94% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Apr 22 10:24:40 2013
alter database recover datafile list clear
Mon Apr 22 10:24:40 2013
Completed: alter database recover datafile list clear