RMAN异机恢复遭遇ORA-01547、ORA-01152、ORA-01110错误案例[原创]_MySQL, Oracle及数据库讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛_联动北方技术论坛  
网站首页 | 关于我们 | 服务中心 | 经验交流 | 公司荣誉 | 成功案例 | 合作伙伴 | 联系我们 |
联动北方-国内领先的云技术服务提供商
»  游客             当前位置:  论坛首页 »  自由讨论区 »  MySQL, Oracle及数据库讨论区 »
总帖数
1
每页帖数
101/1页1
返回列表
0
发起投票  发起投票 发新帖子
查看: 4779 | 回复: 0   主题: RMAN异机恢复遭遇ORA-01547、ORA-01152、ORA-01110错误案例[原创]        下一篇 
潇湘隐者
注册用户
等级:少校
经验:871
发帖:52
精华:2
注册:2014-3-29
状态:离线
发送短消息息给潇湘隐者 加好友    发送短消息息给潇湘隐者 发消息
发表于: IP:您无权察看 2014-4-3 21:19:36 | [全部帖] [楼主帖] 楼主

测试环境:

 操作系统 : Red Hat Enterprise Linux ES release 4 (Nahant Update 4) VMWARE
 数据库 : Oracle Database 10g Release 10.2.0.4.0 - Production
 简要介绍,一台服务器A位于虚拟机VMWARE上,由于测试需要,在VMWARE上克隆了该系统作为服务器B,过了一段时间,由于数据变更,需要将服务器A上的ORACLE数据库还原恢复到服务器B上。
案例介绍:
 由于这两台服务器的数据库实例名称相同、以及对应的环境基本一致(恢复目录相同,数据文件、控制文件都是一致),所以虽然是RMAN异机备份,但是这种异机恢复相对而言比较简单,不需要修改实例名称、数据库名称、指定数据文件位置等等。一般来说,这种环境的恢复还原基本没啥问题。下面介绍操作过程以及解决方法。
Step 1:通过FTP将对应的备份文件以及归档日志放置到相应的目录位置。
Step 2:还原数据库的spfile文件。

[oracle@DB-Server 2014_04_01]$ rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Wed Apr 2 11:30:48 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: EPPS (not mounted)
RMAN> restore spfile to pfile '/u01/app/oracle/product/10.2.0/db_1/dbs/initEPPS.ora'
from '/u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnsnf_TAG20140401T020919_9mmctjx8_.bkp';
Starting restore at 02-APR-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK
channel ORA_DISK_1: autobackup found: /u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnsnf_TAG20140401T020919_9mmctjx8_.bkp
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 02-APR-14


Step3:关闭数据库后,利用还原spfile的初始化文件启动数据库

RMAN> shutdown immediate;
Oracle instance shut down
RMAN> startup nomount pfile=/u01/app/oracle/product/10.2.0/db_1/dbs/initEPPS.ora
connected to target database (not started)
Oracle instance started
Total System Global Area 1258291200 bytes
Fixed Size 1267236 bytes
Variable Size 822086108 bytes
Database Buffers 419430400 bytes
Redo Buffers 15507456 bytes


Step4:恢复数据库控制文件。

RMAN> restore controlfile from '/u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_ncnnf_TAG20140401T020918_9mmctgpn_.bkp';
Starting restore at 02-APR-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output filename=/u01/app/oracle/oradata/EPPS/control01.ctl
output filename=/u01/app/oracle/oradata/EPPS/control02.ctl
output filename=/u01/app/oracle/oradata/EPPS/control03.ctl
Finished restore at 02-APR-14


Step5:将数据库启动到mount状态

RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1


Step6���restore数据库(中间太多数据文件restore,使用.....替代)

RMAN> restore database;
Starting restore at 02-APR-14
Starting implicit crosscheck backup at 02-APR-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
Crosschecked 33 objects
Finished implicit crosscheck backup at 02-APR-14
Starting implicit crosscheck copy at 02-APR-14
using channel ORA_DISK_1
Finished implicit crosscheck copy at 02-APR-14
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76642_9mnmw75n_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76656_9mo3y8c8_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76756_9moly3n8_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76723_9mol3mb6_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76757_9mom3dos_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76745_9molbj09_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76692_9mohyjn3_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76702_9moj2xw6_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76731_9mol8glj_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76721_9mol2oxy_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76705_9mojsjsk_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76704_9mojrgtj_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76755_9molxt45_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76648_9mnn3ldq_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76673_9moh0v00_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76715_9mol0kby_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76722_9mol34vs_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76729_9mol83qs_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76629_9mn45g0s_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76678_9mohhts2_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76701_9moj2sy7_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76660_9mo3zhy5_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76671_9mogy2cl_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76738_9mol9kdl_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76733_9mol8ry2_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76634_9mn5th48_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76640_9mngcxd4_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76662_9moddhtr_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76647_9mnn3j6h_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76728_9mol7wfx_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76712_9mokz4yp_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76711_9mokvo53_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76654_9mo0f04s_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76713_9mokzopc_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76646_9mnn1kch_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76674_9moh19m2_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76644_9mnn0mwj_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76717_9mol1971_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76726_9mol7n4q_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76657_9mo3yjhg_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76709_9mokmvll_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76743_9molb6tq_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76666_9mof202r_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76643_9mnmx6s3_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76725_9mol56d7_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76679_9mohj0oh_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76623_9mmctn48_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76741_9mol9ym3_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76751_9molqocb_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76689_9mohxlfo_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76627_9mn3s6ct_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76719_9mol217r_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76665_9mof032d_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76681_9mohjgq6_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76697_9moj1txh_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76675_9moh2b2x_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76632_9mn5f3bt_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76727_9mol7r4p_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76686_9mohvmv4_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76710_9moknkdm_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76668_9mofcnh0_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76736_9mol974r_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76735_9mol921f_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76658_9mo3yr7l_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76685_9mohn2mt_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76700_9moj2qd5_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76720_9mol2bjb_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76747_9molbryw_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76682_9mohkws7_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76683_9mohlk5b_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76652_9mnwb1px_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76688_9mohx46t_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76734_9mol8xfh_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76707_9mok51fn_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76753_9molx5xk_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76706_9mok4rp6_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76744_9molbc3r_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76636_9mn7bomq_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76624_9mmxzxo2_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76691_9mohyg1l_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76714_9mol03c5_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76667_9mof24b2_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76649_9mnn3qhj_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76749_9molq49h_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76742_9molb3sk_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76630_9mn4xrw7_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76628_9mn43xlb_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76659_9mo3z42k_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76696_9moj1hf2_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76669_9mogx1o5_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76732_9mol8mcw_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76698_9moj2j58_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76684_9mohmf4d_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76750_9molqhrt_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76650_9mnn4gsd_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76695_9mohyv15_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76645_9mnn1497_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76680_9mohj8cw_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76737_9mol9d51_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76693_9mohym8g_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76626_9mn3rdpf_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76653_9mnztso1_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76739_9mol9own_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76664_9modzxr9_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76687_9mohvsxg_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76690_9mohy2kq_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76631_9mn4z1y8_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76716_9mol0x7b_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76638_9mnc29tb_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76703_9mojfodt_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76746_9molbn6l_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76699_9moj2nrf_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76694_9mohyr9w_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76663_9modynm5_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76752_9molszrj_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76672_9mogymcx_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76639_9mndryr1_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76661_9mo450yy_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76708_9mokm1gj_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76718_9mol1mlf_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76633_9mn5nobq_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76677_9mohhn4l_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76740_9mol9tp9_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76641_9mnh8m4b_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76754_9molxjjr_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76635_9mn6goh1_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76651_9mntl22o_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76748_9molbzjk_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76670_9mogxo5p_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76676_9moh3b45_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76637_9mn80ps9_.arc
File Name: /u03/flash_recovery_area/EPPS/archivelog/2014_04_01/o1_mf_1_76730_9mol892v_.arc
File Name: /u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnsnf_TAG20140401T020919_9mmctjx8_.bkp
File Name: /u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_ncnnf_TAG20140401T020918_9mmctgpn_.bkp
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u01/app/oracle/oradata/EPPS/undotbs01.dbf
restoring datafile 00005 to /u02/oradata/EPPS/escmowner_d01.dbf
channel ORA_DISK_1: reading from backup piece /u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mm9jwmb_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mm9jwmb_.bkp tag=FULLBACKUP
channel ORA_DISK_1: restore complete, elapsed time: 00:05:46
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00006 to /u01/app/oracle/oradata/EPPS/escmowner_x01.dbf
restoring datafile 00009 to /u02/oradata/EPPS/invsubmat_d01.dbf
channel ORA_DISK_1: reading from backup piece /u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmb6073_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmb6073_.bkp tag=FULLBACKUP
channel ORA_DISK_1: restore complete, elapsed time: 00:04:26
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00007 to /u02/oradata/EPPS/gmtinv_d01.dbf
restoring datafile 00021 to /u01/app/oracle/oradata/EPPS/inv_month_d01.dbf
restoring datafile 00024 to /u02/oradata/EPPS/wipowner_d01.dbf
restoring datafile 00028 to /u02/oradata/EPPS/invsubmat_d02.dbf
channel ORA_DISK_1: reading from backup piece /u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmbnkjl_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmbnkjl_.bkp tag=FULLBACKUP
channel ORA_DISK_1: restore complete, elapsed time: 00:03:15
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00008 to /u01/app/oracle/oradata/EPPS/gmtinv_x01.dbf
restoring datafile 00013 to /u02/oradata/EPPS/ppcegm_d01.dbf
restoring datafile 00017 to /u02/oradata/EPPS/ppcuser_d01.dbf
restoring datafile 00019 to /u02/oradata/EPPS/ppc_hist_d01.dbf
restoring datafile 00020 to /u02/oradata/EPPS/rmantbs_01.dbf
restoring datafile 00023 to /u01/app/oracle/oradata/EPPS/inv_month_x01.dbf
channel ORA_DISK_1: reading from backup piece /u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmbxgvy_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmbxgvy_.bkp tag=FULLBACKUP
channel ORA_DISK_1: restore complete, elapsed time: 00:03:16
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00010 to /u01/app/oracle/oradata/EPPS/invsubmat_x01.dbf
restoring datafile 00011 to /u02/oradata/EPPS/ppccheck_d01.dbf
restoring datafile 00015 to /u02/oradata/EPPS/ppcsub_d01.dbf
restoring datafile 00026 to /u02/oradata/EPPS/escmowner_d02.dbf
channel ORA_DISK_1: reading from backup piece /u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmc8881_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmc8881_.bkp tag=FULLBACKUP
channel ORA_DISK_1: restore complete, elapsed time: 00:03:16
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00025 to /u01/app/oracle/oradata/EPPS/wipowner_x01.dbf
restoring datafile 00027 to /u01/app/oracle/oradata/EPPS/escmowner_x02.dbf
channel ORA_DISK_1: reading from backup piece /u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmcm1l9_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmcm1l9_.bkp tag=FULLBACKUP
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oracle/oradata/EPPS/system01.dbf
restoring datafile 00022 to /u01/app/oracle/oradata/EPPS/inv_month_d02.dbf
channel ORA_DISK_1: reading from backup piece /u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmco2qy_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmco2qy_.bkp tag=FULLBACKUP
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /u01/app/oracle/oradata/EPPS/sysaux01.dbf
restoring datafile 00004 to /u01/app/oracle/oradata/EPPS/users01.dbf
restoring datafile 00012 to /u01/app/oracle/oradata/EPPS/ppccheck_x01.dbf
restoring datafile 00016 to /u01/app/oracle/oradata/EPPS/ppcsub_x01.dbf
channel ORA_DISK_1: reading from backup piece /u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmcq43g_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmcq43g_.bkp tag=FULLBACKUP
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00014 to /u01/app/oracle/oradata/EPPS/ppcegm_x01.dbf
channel ORA_DISK_1: reading from backup piece /u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmcrv3h_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmcrv3h_.bkp tag=FULLBACKUP
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00018 to /u01/app/oracle/oradata/EPPS/ppcuser_x01.dbf
channel ORA_DISK_1: reading from backup piece /u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmct88k_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u03/flash_recovery_area/EPPS/backupset/2014_04_01/o1_mf_nnndf_FULLBACKUP_9mmct88k_.bkp tag=FULLBACKUP
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 02-APR-14
Step 7 : recover database
RMAN> recover database;
Starting recover at 02-APR-14
using channel ORA_DISK_1
starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/EPPS/system01.dbf'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/02/2014 12:03:29
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 76757 lowscn 14312652139 found to restore
RMAN-06025: no backup of log thread 1 seq 76756 lowscn 14312646489 found to restore
RMAN-06025: no backup of log thread 1 seq 76755 lowscn 14312646378 found to restore
RMAN-06025: no backup of log thread 1 seq 76754 lowscn 14312646262 found to restore
RMAN-06025: no backup of log thread 1 seq 76753 lowscn 14312644427 found to restore
RMAN-06025: no backup of log thread 1 seq 76752 lowscn 14312642030 found to restore
RMAN-06025: no backup of log thread 1 seq 76751 lowscn 14312640281 found to restore
RMAN-06025: no backup of log thread 1 seq 76750 lowscn 14312638600 found to restore
RMAN-06025: no backup of log thread 1 seq 76749 lowscn 14312637270 found to restore
RMAN-06025: no backup of log thread 1 seq 76748 lowscn 14312636566 found to restore
RMAN-06025: no backup of log thread 1 seq 76747 lowscn 14312635786 found to restore
RMAN-06025: no backup of log thread 1 seq 76746 lowscn 14312634976 found to restore
RMAN-06025: no backup of log thread 1 seq 76745 lowscn 14312634196 found to restore
RMAN-06025: no backup of log thread 1 seq 76744 lowscn 14312633426 found to restore
RMAN-06025: no backup of log thread 1 seq 76743 lowscn 14312632650 found to restore
RMAN-06025: no backup of log thread 1 seq 76742 lowscn 14312631880 found to restore
RMAN-06025: no backup of log thread 1 seq 76741 lowscn 14312631120 found to restore
RMAN-06025: no backup of log thread 1 seq 76740 lowscn 14312630358 found to restore
RMAN-06025: no backup of log thread 1 seq 76739 lowscn 14312629580 found to restore
RMAN-06025: no backup of log thread 1 seq 76738 lowscn 14312628812 found to restore
RMAN-06025: no backup of log thread 1 seq 76737 lowscn 14312628019 found to restore
RMAN-06025: no backup of log thread 1 seq 76736 lowscn 14312627239 found to restore
RMAN-06025: no backup of log thread 1 seq 76735 lowscn 14312626460 found to restore
RMAN-06025: no backup of log thread 1 seq 76734 lowscn 14312625692 found to restore
RMAN-06025: no backup of log thread 1 seq 76733 lowscn 14312624924 found to restore
RMAN-06025: no backup of log thread 1 seq 76732 lowscn 14312624157 found to restore
RMAN-06025: no backup of log thread 1 seq 76731 lowscn 14312623377 found to restore
RMAN-06025: no backup of log thread 1 seq 76730 lowscn 14312622598 found to restore
RMAN-06025: no backup of log thread 1 seq 76729 lowscn 14312621836 found to restore
RMAN-06025: no backup of log thread 1 seq 76728 lowscn 14312621062 found to restore
RMAN-06025: no backup of log thread 1 seq 76727 lowscn 14312620313 found to restore
RMAN-06025: no backup of log thread 1 seq 76726 lowscn 14312618674 found to restore
RMAN-06025: no backup of log thread 1 seq 76725 lowscn 14312607258 found to restore
MAN-06025: no backup of log thre
RMAN>


截图如下所示

北京联动北方科技有限公司

关于ORA-01547的解释如下所示:

[ oracle@DB-Server dbs]$ oerr ora 1547
01547, 00000, "warning: RECOVER succeeded but OPEN RESETLOGS would get error below"
// *Cause: Media recovery with one of the incomplete recovery options ended
// without error. However, if the ALTER DATABASE OPEN RESETLOGS command
// were attempted now, it would fail with the specified error.
// The most likely cause of this error is forgetting to restore one or
// more datafiles from a sufficiently old backup before executing the
// incomplete recovery.
// *Action: Rerun the incomplete media recovery using different datafile
// backups, a different control file, or different stop criteria.


此错误的最可能的原因是执行不完全恢复前。忘记从一个足够旧的备份还原一个或多个��据文件。

Step 8:
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/02/2014 12:04:53
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/EPPS/system01.dbf'
RMAN>
RMAN> exit


关于openresetlogs选项,是指打开数据时,重置联机重做日志(onlineredolog),即将重做日志的sequence置零,为什么要重置重做日志呢?不完全恢复后,原来的联机重做日志(onlineredolog)里面包含的是未做恢复前的数据,而这些数据对于恢复后的数据库不再有效,所以数据库会要求在open之前先对联机重做日志(onlineredolog)的sequence置零。Resetlogs命令表示一个数据库逻辑生存期的结束和另一个数据库逻辑��存期的开始,每次使用Resetlogs命令的时候,SCN不会被重置,不过ORACLE会重置日志序列号,而且会重置联机重做日志内容(相当于把所有的联机日志重新“格式化”)。
解决方法
此时可以通过设置隐藏参数_allow_resetlogs_corruption之后,使数据库在Open过程中,跳过某些一致性检查,从而使数据库可能跳过不一致状态。操作步骤如下

[oracle@DB-Server 2014_04_01]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Apr 2 12:05:57 2014
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Release 10.2.0.4.0 - Production
SQL> create spfile from pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/initEPPS.ora';
File created.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1258291200 bytes
Fixed Size 1267236 bytes
Variable Size 822086108 bytes
Database Buffers 419430400 bytes
Redo Buffers 15507456 bytes
Database mounted.
SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;
System altered.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 14311145729 generated at 04/01/2014 08:57:48 needed for
thread 1
ORA-00289: suggestion :
/u03/flash_recovery_area/EPPS/archivelog/2014_04_02/o1_mf_1_76627_%u_.arc
ORA-00280: change 14311145729 for thread 1 is in sequence #76627
Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;
Database altered.
SQL> select status from v$instance;
STATUS
------------
OPEN


截图如下所示

北京联动北方科技有限公司

使用了隐藏参数_allow_resetlogs_corruption后,需要从参数文件(pfile或spfile中)移除隐藏参数,并对数据库进行导入导出比较好,不过此处都是测试数据库,重要性不是很高。在此忽略这些步骤。
参考资料:

http://zionw.blog.163.com/blog/static/9985959200911111181377/
http://blog.itpub.net/751371/viewspace-709644
http://hirtom.blog.163.com/blog/static/31182683200751204727172/


该贴被潇湘隐者编辑于2014-4-3 21:20:59
该贴被潇湘隐者编辑于2014-4-3 21:23:14

该贴由hui.chen转至本版2014-11-5 16:24:21




赞(0)    操作        顶端 
总帖数
1
每页帖数
101/1页1
返回列表
发新帖子
请输入验证码: 点击刷新验证码
您需要登录后才可以回帖 登录 | 注册
技术讨论