RMAN恢复案例之–不完全恢复错误案例

RMAN恢复案例之–不完全恢复错误案例

RMAN恢复案例：

不完全恢复，由于在先前的数据文件备份有误，导致恢复失败。

[oracle@rh6 ~]$ rman target /Recovery Manager: Release 11.2.0.1.0 - Production on Sat Sep 20 15:54:25 2014Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.connected to target database: TEST1 (DBI<i>本文来源gaodai$ma#com搞$代*码*网</i>D=1195893416)RMAN> run {2> shutdown immediate;3> startup mount;4> set until time '2014-09-20 15:49:36';5> restore database;6> recover database ;7> alter database open resetlogs;8> sql'alter system switch logfile';9> }using target database control file instead of recovery catalogdatabase closeddatabase dismountedOracle instance shut downconnected to target database (not started)Oracle instance starteddatabase mountedTotal System Global Area     175767552 bytesFixed Size                     1335276 bytesVariable Size                142606356 bytesDatabase Buffers              29360128 bytesRedo Buffers                   2465792 bytesexecuting command: SET until clauseStarting restore at 20-SEP-14allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=18 device type=DISKflashing back control file to SCN 9601534channel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/test1/sysaux01.dbfchannel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/test1/users01.dbfchannel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/test1/perfs.dbfchannel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/test1/undotbs2.dbfchannel ORA_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/test1/index01.dbfchannel ORA_DISK_1: reading from backup piece /dsk1/backup/test1/TEST1_240.bakchannel ORA_DISK_1: piece handle=/dsk1/backup/test1/TEST1_240.bak tag=TAG20140920T152720channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:35channel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00013 to /u01/app/oracle/oradata/test1/tbs_16.dbfchannel ORA_DISK_1: reading from backup piece /dsk1/backup/test1/TEST1_241.bakchannel ORA_DISK_1: piece handle=/dsk1/backup/test1/TEST1_241.bak tag=TAG20140920T152720channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:01channel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/test1/system01.dbfchannel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/test1/test1.dbfchannel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/test1/dict1.dbfchannel ORA_DISK_1: reading from backup piece /dsk1/backup/test1/TEST1_239.bakchannel ORA_DISK_1: piece handle=/dsk1/backup/test1/TEST1_239.bak tag=TAG20140920T152720channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:45Finished restore at 20-SEP-14Starting recover at 20-SEP-14using channel ORA_DISK_1starting media recovery

搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]‍，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：RMAN恢复案例之–不完全恢复错误案例

Hi，您需要填写昵称和邮箱！