ORA-01123: cannot start online backup; media recovery not enabled
来源:互联网 发布:湖南第五届网络文化节 编辑:程序博客网 时间:2024/05/16 07:32
问题描述
当使用SQL进行备份操作时,出现下面的错误,提示不能启动在线备份,具体错误信息如下:
SYS@orcl _SQL>alter tablespace users begin backup;alter tablespace users begin backup*ERROR at line 1:ORA-01123: cannot start online backup; media recovery not enabled
解决办法
出现此种问题的原因是数据库处于非归档模式,不能在线进行备份,只能在数据库处于归档模式时,方可执行在线SQL备份,具体演示如下:
SYS@orcl _SQL>archive log list;Database log mode No Archive Mode----->数据库处于非归档模式Automatic archival DisabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 106Current log sequence 108SYS@orcl _SQL>shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SYS@orcl _SQL>startup mountORACLE instance started.Total System Global Area 778387456 bytesFixed Size 1374808 bytesVariable Size 520095144 bytesDatabase Buffers 251658240 bytesRedo Buffers 5259264 bytesDatabase mounted.SYS@orcl _SQL>alter database archivelog;---->启用数据库归档模式Database altered.SYS@orcl _SQL>alter database open;Database altered.SYS@orcl _SQL>alter tablespace users begin backup;Tablespace altered.SYS@orcl _SQL>host copy E:\APP\ALEN.LIU\ORADATA\ORCL\USERS01.DBF e:\USERS01.DBF已复制 1 个文件。SYS@orcl _SQL>alter tablespace users end backup;Tablespace altered.SYS@orcl _SQL>
阅读全文
0 0
- ORA-01123: cannot start online backup; media recovery not enabled
- ORA-01123: cannot start online backup; media recovery not enabled
- ORA-38706: Cannot turn on FLASHBACK DATABASE logging.ORA-38709: Recovery Area is not enabled.
- ORA-38706: Cannot turn on FLASHBACK DATABASE logging.ORA-38709: Recovery Area is not enabled.
- ORA-38709: Recovery Area is not enabled.
- ORA-01145: offline immediate disallowed unless media recovery enabled问题解决
- Media recovery not enabled or manual archival only 0x10000
- Media Recovery Not Enabled Or Manual Archival OnlY
- Media recovery not enabled or manual archival only 0x10000
- ORA-01618: redo thread 2 is not enabled - cannot mount
- ORA-01618: redo thread 2 is not enabled - cannot mount
- ORA-10456: cannot open standby database; media recovery session may be in progress
- ORA-10456: cannot open standby database; media recovery session may be in
- ORA-10456: cannot open standby database; media recovery session may be in progress
- ORA-10456: cannot open standby database; media recovery session may be in progress
- 闪回命令出错 ORA-08189: cannot flashback the table because row movement is not enabled
- ORA-01618: redo thread 2 is not enabled - cannot mount 错误
- ORA-01618: redo thread 2 is not enabled - cannot mount 错误
- Ubuntu 命令积累
- Failed to execute goal org.springframework.boot:spring-boot-maven-plugin:1.0
- 2017 ACM-ICPC Asia Regional Shenyang Online spfa+最长路
- Linux常用命令学习
- 事务
- ORA-01123: cannot start online backup; media recovery not enabled
- API汇集
- 设计模式大总结(四):原型模式
- 4、redis的五大数据类型
- Spring AOP造成的@Controller注册失败
- Httpclint 4.x 的用法
- jq/js–ajax局部刷新的陷阱
- 蓝桥杯 真题 打印十字图 java
- Java获取一个文件夹内的所有文件(包括所有子文件夹内的)