RMAN> restore spfile from autobackup;

Starting restore at 03-APR-19
using channel ORA_DISK_1
using channel ORA_DISK_2

channel ORA_DISK_1: looking for AUTOBACKUP on day: 20190403
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20190402
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20190401
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20190331
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20190330
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20190329
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20190328
channel ORA_DISK_1: no AUTOBACKUP in 7 days found
channel ORA_DISK_2: looking for AUTOBACKUP on day: 20190403
channel ORA_DISK_2: looking for AUTOBACKUP on day: 20190402
channel ORA_DISK_2: looking for AUTOBACKUP on day: 20190401
channel ORA_DISK_2: looking for AUTOBACKUP on day: 20190331
channel ORA_DISK_2: looking for AUTOBACKUP on day: 20190330
channel ORA_DISK_2: looking for AUTOBACKUP on day: 20190329
channel ORA_DISK_2: looking for AUTOBACKUP on day: 20190328
channel ORA_DISK_2: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/03/2019 16:27:24
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

解决方法：

RMAN> restore spfile from '/u01/app/oracle/fast_recovery_area/PROD2/autobackup/2019_04_03/o1_mf_s_1004630646_gb8t7ro3_.bkp';

Starting restore at 03-APR-19
using channel ORA_DISK_1
using channel ORA_DISK_2

channel ORA_DISK_2: skipped, AUTOBACKUP already found
channel ORA_DISK_1: restoring spfile from AUTOBACKUP /u01/app/oracle/fast_recovery_area/PROD2/autobackup/2019_04_03/o1_mf_s_1004630646_gb8t7ro3_.bkp
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 03-APR-19

原因是oracle无法识别db_recovery_file_dest参数，为避免出现以上报错，可以先设置db_recovery_file_dest参数

设置方法：

alter system set db_recovery_file_dest_size=4g;

alter system set db_recovery_file_dest='/u01/app/oracle/fast_recovery_file_dest';

2019-4-3 18:40

最新文章

1. Field 'id' doesn't have a default value（jdbc连接错误）
2. java中复制对象通过反射或序列化
3. C#编程总结（十二）断点续传
4. Ajax获得站点文件内容实例
5. Android 浅谈相机研发
6. 在MVC或WEBAPI中记录每个Action的执行时间和记录下层方法调用时间
7. UVa 900 - Brick Wall Patterns
8. iphone启动图UI切图尺寸对照保存
9. Vue结合slot插槽分发父组件内容实现高度复用、更加灵活的dialog组件
10. Caffe源码理解2：SyncedMemory CPU和GPU间的数据同步
11. NopCommerce用.net core重写ef
12. Visual Studio 2015的安装及单元测试练习
13. Java利用JNI调用C/C++写成的DLL
14. python实现简单的聊天小程序
15. <低风险投资之路>读书笔记
16. 解决neo4j @Transactional 与Spring data jpa @Transactional 冲突问题,@CreatedBy,@CreatedDate,@LastModifiedBy,@LastModifiedDate,以及解决@Version失效问题
17. 04-matplotlib-柱形图
18. POJ.3321 Apple Tree ( DFS序 线段树 单点更新 区间求和)
19. ARM Linux 驱动Input子系统之按键驱动测试
20. BUILDING ANGULAR APPS USING FLUX ARCHITECTURE

热门文章

1. PL/SQL Developer 13注册码（亲测可用）
2. ISITDTU CTF 2020 部分Web题目Writeup
3. 面试大厂必看！就凭借这份Java多线程和并发面试题，我拿到了字节和美团的offer！
4. 【MathType教学】表示分类的大括号怎么打
5. 如何灵活运用ABBYY FineReader的识别功能
6. Linux（Ubuntu16.04）下的MediaWiki的部署启动
7. python—数据类型和变量
8. 冲刺随笔——Day_Eight
9. Spring Cloud Alibaba 初体验(一) Nacos 配置中心
10. 从代码角度理解NNLM（A Neural Probabilistic Language Model）