实战:Oracle10.2.0.4异机迁移并升级到Oracle11.2.0.4(七)

2015-01-22 21:28:33 · 作者: · 浏览: 32
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日志
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