RMAN恢复案例之--不完全恢复错误案例
发表于：2025-02-01 作者：千家信息网编辑
千家信息网最后更新 2025年02月01日，RMAN恢复案例之--不完全恢复错误案例RMAN恢复案例：不完全恢复，由于在先前的数据文件备份有误，导致恢复失败。[oracle@rh7 ~]$ rman target /Recovery Manag
千家信息网最后更新 2025年02月01日RMAN恢复案例之--不完全恢复错误案例
RMAN恢复案例之--不完全恢复错误案例
RMAN恢复案例：
不完全恢复，由于在先前的数据文件备份有误，导致恢复失败。
[oracle@rh7 ~]$ 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 (DBID=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 recoveryrecover 失败......
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/20/2014 15:59:01
RMAN-20505: create datafile during recovery
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until time 'SEP 20 2014 15:49:36'
ORA-00283: recovery session canceled due to errors
ORA-01244: unnamed datafile(s) added to control file by media recovery
ORA-01110: data file 8: '/u01/app/oracle/oradata/test1/tbs2.dbf'
查看备份信息：
RMAN> list backup of database;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------229 Full 158.89M DISK 00:01:18 20-SEP-14 BP Key: 229 Status: AVAILABLE Compressed: NO Tag: TAG20140920T152720 Piece Name: /dsk1/backup/test1/TEST1_240.bak List of Datafiles in backup set 229 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 2 Full 9601534 20-SEP-14 /u01/app/oracle/oradata/test1/sysaux01.dbf 4 Full 9601534 20-SEP-14 /u01/app/oracle/oradata/test1/users01.dbf 5 Full 9601534 20-SEP-14 /u01/app/oracle/oradata/test1/perfs.dbf 7 Full 9601534 20-SEP-14 /u01/app/oracle/oradata/test1/undotbs2.dbf 10 Full 9601534 20-SEP-14 /u01/app/oracle/oradata/test1/index01.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------230 Full 1.06M DISK 00:00:01 20-SEP-14 BP Key: 230 Status: AVAILABLE Compressed: NO Tag: TAG20140920T152720 Piece Name: /dsk1/backup/test1/TEST1_241.bak List of Datafiles in backup set 230 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 13 Full 9601534 20-SEP-14 /u01/app/oracle/oradata/test1/tbs_16.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------231 Full 609.73M DISK 00:01:32 20-SEP-14 BP Key: 231 Status: AVAILABLE Compressed: NO Tag: TAG20140920T152720 Piece Name: /dsk1/backup/test1/TEST1_239.bak List of Datafiles in backup set 231 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 9601534 20-SEP-14 /u01/app/oracle/oradata/test1/system01.dbf 3 Full 9601534 20-SEP-14 /u01/app/oracle/oradata/test1/test1.dbf 6 Full 9601534 20-SEP-14 /u01/app/oracle/oradata/test1/dict1.dbf 8 Full 9601534 20-SEP-14 /u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00008
在备份中发现:
'/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00008',而在数据库中并没有这个数据文件！
解决方法：
将datafile offline，open数据库：
16:02:43 SYS@ test1 >alter database datafile 8 offline;Database altered.
recover database跳过此表空间：
RMAN> recover database skip tablespace tbs2;
Starting recover at 20-SEP-14using channel ORA_DISK_1Executing: alter database datafile 8 offlinestarting media recoverymedia recovery complete, elapsed time: 00:00:30Finished recover at 20-SEP-14
查看告警日志：
alter database datafile 8 offlineCompleted: alter database datafile 8 offlinealter database recover datafile list clearCompleted: alter database recover datafile list clearalter database recover datafile list 1 , 2 , 3 , 4 , 5 , 6 , 7 , 10 , 13Completed: alter database recover datafile list 1 , 2 , 3 , 4 , 5 , 6 , 7 , 10 , 13alter database recover if needed startMedia Recovery StartSerial Media Recovery startedRecovery of Online Redo Log: Thread 1 Group 5 Seq 15 Reading mem 0 Mem# 0: /dsk1/oradata/test1/redo05a.logSat Sep 20 16:06:51 2014Media Recovery Complete (test1)Completed: alter database recover if needed start
打开数据库删除此表空间：
16:04:42 SYS@ test1 >conn /as sysdba;Connected.16:10:10 SYS@ test1 >alter database open;Database altered.Elapsed: 00:00:21.6316:10:54 SYS@ test1 >select name from v$datafile;NAME--------------------------------------------------/u01/app/oracle/oradata/test1/system01.dbf/u01/app/oracle/oradata/test1/sysaux01.dbf/u01/app/oracle/oradata/test1/test1.dbf/u01/app/oracle/oradata/test1/users01.dbf/u01/app/oracle/oradata/test1/perfs.dbf/u01/app/oracle/oradata/test1/dict1.dbf/u01/app/oracle/oradata/test1/undotbs2.dbf/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00008/u01/app/oracle/oradata/test1/index01.dbf/u01/app/oracle/oradata/test1/tbs_16.dbf10 rows selected.16:11:10 SYS@ test1 >drop tablespace tbs2 including contents and datafiles;Tablespace dropped.16:11:32 SYS@ test1 >select name from v$datafile;NAME--------------------------------------------------/u01/app/oracle/oradata/test1/system01.dbf/u01/app/oracle/oradata/test1/sysaux01.dbf/u01/app/oracle/oradata/test1/test1.dbf/u01/app/oracle/oradata/test1/users01.dbf/u01/app/oracle/oradata/test1/perfs.dbf/u01/app/oracle/oradata/test1/dict1.dbf/u01/app/oracle/oradata/test1/undotbs2.dbf/u01/app/oracle/oradata/test1/index01.dbf/u01/app/oracle/oradata/test1/tbs_16.dbf9 rows selected.
对数据库做重新做全备，再次做数据恢复！
恢复过程又出错：
RMAN> run {2> shutdown immediate;3> startup mount;4> set until time '2014-09-20 16:19:30';5> restore database;6> recover database;7> alter database open resetlogs;8> }database 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 9603237RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 09/20/2014 16:21:46RMAN-06085: must use SET NEWNAME command to restore datafile /u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00008查看备份信息：
RMAN> list backup;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------233 Full 164.45M DISK 00:01:04 20-SEP-14 BP Key: 233 Status: AVAILABLE Compressed: NO Tag: TAG20140920T161544 Piece Name: /dsk1/backup/test1/TEST1_244.bak List of Datafiles in backup set 233 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 2 Full 9603220 20-SEP-14 /u01/app/oracle/oradata/test1/sysaux01.dbf 5 Full 9603220 20-SEP-14 /u01/app/oracle/oradata/test1/perfs.dbf 7 Full 9603220 20-SEP-14 /u01/app/oracle/oradata/test1/undotbs2.dbf 10 Full 9603220 20-SEP-14 /u01/app/oracle/oradata/test1/index01.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------234 Full 1.06M DISK 00:00:02 20-SEP-14 BP Key: 234 Status: AVAILABLE Compressed: NO Tag: TAG20140920T161544 Piece Name: /dsk1/backup/test1/TEST1_245.bak List of Datafiles in backup set 234 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 13 Full 9603220 20-SEP-14 /u01/app/oracle/oradata/test1/tbs_16.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------235 Full 613.10M DISK 00:01:28 20-SEP-14 BP Key: 235 Status: AVAILABLE Compressed: NO Tag: TAG20140920T161544 Piece Name: /dsk1/backup/test1/TEST1_243.bak List of Datafiles in backup set 235 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 9603220 20-SEP-14 /u01/app/oracle/oradata/test1/system01.dbf 3 Full 9603220 20-SEP-14 /u01/app/oracle/oradata/test1/test1.dbf 4 Full 9603220 20-SEP-14 /u01/app/oracle/oradata/test1/users01.dbf 6 Full 9603220 20-SEP-14 /u01/app/oracle/oradata/test1/dict1.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------236 Full 11.33M DISK 00:00:05 20-SEP-14 BP Key: 236 Status: AVAILABLE Compressed: NO Tag: TAG20140920T161714 Piece Name: /dsk4/backup/TEST1/autobackup/2014_09_20/o1_mf_s_858788041_b1tg0gds_.bkp SPFILE Included: Modification time: 03-SEP-14 SPFILE db_unique_name: TEST1 Control File Included: Ckp SCN: 9603237 Ckp time: 20-SEP-14
restore controlfile：
RMAN> list backup of controlfile;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------236 Full 11.33M DISK 00:00:05 20-SEP-14 BP Key: 236 Status: AVAILABLE Compressed: NO Tag: TAG20140920T161714 Piece Name: /dsk4/backup/TEST1/autobackup/2014_09_20/o1_mf_s_858788041_b1tg0gds_.bkp Control File Included: Ckp SCN: 9603237 Ckp time: 20-SEP-14 RMAN> shutdown immediate;database dismountedOracle instance shut downRMAN> startup nomount;connected to target database (not started)Oracle instance startedTotal System Global Area 175767552 bytesFixed Size 1335276 bytesVariable Size 142606356 bytesDatabase Buffers 29360128 bytesRedo Buffers 2465792 bytesRMAN> restore controlfile from autobackup;Starting restore at 20-SEP-14allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=19 device type=DISKrecovery area destination: /dsk4/backupdatabase name (or database unique name) used for search: TEST1channel ORA_DISK_1: AUTOBACKUP /dsk4/backup/TEST1/autobackup/2014_09_20/o1_mf_s_858788041_b1tg0gds_.bkp found in the recovery areachannel ORA_DISK_1: looking for AUTOBACKUP on day: 20140920channel ORA_DISK_1: restoring control file from AUTOBACKUP /dsk4/backup/TEST1/autobackup/2014_09_20/o1_mf_s_858788041_b1tg0gds_.bkpchannel ORA_DISK_1: control file restore from AUTOBACKUP completeoutput file name=/u01/app/oracle/oradata/test1/control01.ctloutput file name=/dsk1/oradata/test1/control02.ctloutput file name=/dsk2/oradata/test1/control03.ctlFinished restore at 20-SEP-14
重新做恢复：
RMAN> run {2> shutdown immediate;3> startup mount;4> set until time '2014-09-20 16:19:30';5> restore database;6> recover database;7> alter database open resetlogs;8> }Oracle 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-14Starting implicit crosscheck backup at 20-SEP-14allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=18 device type=DISKCrosschecked 3 objectsFinished implicit crosscheck backup at 20-SEP-14Starting implicit crosscheck copy at 20-SEP-14using channel ORA_DISK_1Finished implicit crosscheck copy at 20-SEP-14searching for all files in the recovery areacataloging files...cataloging doneList of Cataloged Files=======================File Name: /dsk4/backup/TEST1/autobackup/2014_09_20/o1_mf_s_858788041_b1tg0gds_.bkpFile Name: /dsk4/backup/TEST1/autobackup/2014_09_14/o1_mf_s_858262943_b1bf156d_.bkpFile Name: /dsk4/backup/TEST1/autobackup/2014_09_14/o1_mf_s_858259416_b1b9lv2j_.bkpFile Name: /dsk4/backup/TEST1/autobackup/2014_09_14/o1_mf_s_858261087_b1bc76lg_.bkpFile Name: /dsk4/backup/TEST1/autobackup/2014_09_14/o1_mf_s_858260002_b1bb58sq_.bkpFile Name: /dsk4/backup/TEST1/autobackup/2013_11_10/o1_mf_s_831135549_97ycp30c_.bkpFile Name: /dsk4/backup/TEST1/autobackup/2013_11_10/o1_mf_s_831134795_97yc0vk0_.bkpFile Name: /dsk4/backup/TEST1/autobackup/2013_11_10/o1_mf_s_831136532_97ydnsbl_.bkpFile Name: /dsk4/backup/TEST1/autobackup/2013_11_10/o1_mf_s_831135962_97yd2z3r_.bkpusing channel ORA_DISK_1channel 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 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_244.bakchannel ORA_DISK_1: piece handle=/dsk1/backup/test1/TEST1_244.bak tag=TAG20140920T161544channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:25channel 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_245.bakchannel ORA_DISK_1: piece handle=/dsk1/backup/test1/TEST1_245.bak tag=TAG20140920T161544channel 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 00004 to /u01/app/oracle/oradata/test1/users01.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_243.bakchannel ORA_DISK_1: piece handle=/dsk1/backup/test1/TEST1_243.bak tag=TAG20140920T161544channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:55Finished restore at 20-SEP-14Starting recover at 20-SEP-14using channel ORA_DISK_1starting media recoveryarchived log for thread 1 with sequence 17 is already on disk as file /dsk1/oradata/test1/redo04a.logarchived log for thread 1 with sequence 18 is already on disk as file /dsk1/oradata/test1/redo05a.logarchived log file name=/dsk1/oradata/test1/redo04a.log thread=1 sequence=17archived log file name=/dsk1/oradata/test1/redo05a.log thread=1 sequence=18media recovery complete, elapsed time: 00:00:08Finished recover at 20-SEP-14Starting recover at 20-SEP-14using channel ORA_DISK_1starting media recoveryarchived log for thread 1 with sequence 17 is already on disk as file /dsk1/oradata/test1/redo04a.logarchived log for thread 1 with sequence 18 is already on disk as file /dsk1/oradata/test1/redo05a.logarchived log file name=/dsk1/oradata/test1/redo04a.log thread=1 sequence=17archived log file name=/dsk1/oradata/test1/redo05a.log thread=1 sequence=18media recovery complete, elapsed time: 00:00:08Finished recover at 20-SEP-14database opened@至此，不完全恢复成功！
数据
备份
数据库
案例
信息
文件
空间
错误
成功
再次
数据恢复
方法
日志
至此
过程
全备
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
tcm数据库
屏幕录像服务器
办公用品数据库
服务器糸统
用互联网思维打造自考科技派
某一个字段删除重复的数据库
网站服务器安全巡检
LUM数据库考试前一天
际缘互联网科技工资待遇
服务器都有哪些工具
软件开发电力行业
网络安全形势受到各国高度关注
找不到数据库启动句柄
数据库设置锁
磁盘数据恢复软件开发
软件开发的三个里程碑
抄车牌如何上传数据库
mapgis数据库
云综合安防管理平台服务器
快宝网络技术有限公司股东
金融软件开发工资待遇
db2 查看当前数据库
中美部长级会谈网络安全
连界互联网科技广州
网络安全华为
盐田区新一代网络技术开发工艺
tbf网络安全大赛
数据库如何修改
江苏质量软件开发现价
南京数据网络技术服务电话
