Completed: alter database mount Thu Dec 11 17:29:16 2014 Checker run found 10 new persistent data failures Thu Dec 11 17:32:38 2014 Full restore complete of datafile 6 /home/oracle/oradata/orcl/system02.dbf. Elapsed time: 0:03:21 checkpoint is 645792 Full restore complete of datafile 8 /home/oracle/oradata/orcl/sysaux02.dbf. Elapsed time: 0:03:25 checkpoint is 645792 Full restore complete of datafile 7 /home/oracle/oradata/orcl/undotbs02.dbf. Elapsed time: 0:03:25 checkpoint is 645792 Full restore complete of datafile 9 /home/oracle/oradata/orcl/ex.dbf. Elapsed time: 0:03:25 checkpoint is 645792 Full restore complete of datafile 4 /home/oracle/oradata/orcl/users01.dbf. Elapsed time: 0:00:01 checkpoint is 645792 Thu Dec 11 17:32:49 2014 Full restore complete of datafile 2 /home/oracle/oradata/orcl/undotbs01.dbf. Elapsed time: 0:03:35 checkpoint is 645792 last deallocation scn is 642787 Thu Dec 11 17:33:08 2014 Full restore complete of datafile 5 /home/oracle/oradata/orcl/example01.dbf. Elapsed time: 0:03:50 checkpoint is 645792 last deallocation scn is 617217 Thu Dec 11 17:33:38 2014 Full restore complete of datafile 3 /home/oracle/oradata/orcl/sysaux01.dbf. Elapsed time: 0:04:22 checkpoint is 645792 last deallocation scn is 635554 Thu Dec 11 17:33:55 2014 Full restore complete of datafile 1 /home/oracle/oradata/o
实战:Oracle10.2.0.4异机迁移并升级到Oracle11.2.0.4(七)
acle/oradata/orcl/control03.ctl
Finished restore at 11-DEC-14
RMAN> sql 'alter database mount';
sql statement: alter database mount
released channel: ORA_DISK_1
RMAN> restore database;
Starting restore at 11-DEC-14
Starting implicit crosscheck backup at 11-DEC-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 device type=DISK
Crosschecked 1 objects
Finished implicit crosscheck backup at 11-DEC-14
Starting implicit crosscheck copy at 11-DEC-14
using channel ORA_DISK_1
Finished implicit crosscheck copy at 11-DEC-14
searching for all files in the recovery area
cataloging files...
no files cataloged
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /home/oracle/oradata/orcl/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /home/oracle/oradata/orcl/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /home/oracle/oradata/orcl/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /home/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /home/oracle/oradata/orcl/example01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /home/oracle/oradata/orcl/system02.dbf
channel ORA_DISK_1: restoring datafile 00007 to /home/oracle/oradata/orcl/undotbs02.dbf
channel ORA_DISK_1: restoring datafile 00008 to /home/oracle/oradata/orcl/sysaux02.dbf
channel ORA_DISK_1: restoring datafile 00009 to /home/oracle/oradata/orcl/ex.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/bak/full_orcl_01pq07r8_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bak/full_orcl_01pq07r8_1_1 tag=TAG20141212T161015
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:04:45
Finished restore at 11-DEC-14
RMAN>
alter日志