首页 / ORACLE / Oracle备份时发生断电的对策
Oracle备份时发生断电的对策
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Oracle备份时发生断电的对策,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2812字,纯文字阅读大概需要5分钟。
内容图文
![Oracle备份时发生断电的对策](/upload/InfoBanner/zyjiaocheng/549/06f16c53c9b8431b948f4739e9c4ece9.jpg)
SQLgt; alter database begin backup; --开始备份数据库 Database altered. SQLgt; host cp /u01/Oracle/oradata/ORCL/*
Oracle备份时发生断电的对策
[日期:2012-12-20] 来源:Linux社区 作者:kaixin1998 [字体:]
SQL> alter database begin backup; --开始备份数据库
Database altered.
SQL> host cp /u01/Oracle/oradata/ORCL/*.dbf /u01/oracle/dump1/ --还没执行完毕就断电关机了,,abort
在重启数据库的时候,出现的问题
[root@station88 ~]# su - oracle
[oracle@station88 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Sat Dec 15 07:51:29 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 373293056 bytes
Fixed Size 1267572 bytes
Variable Size 104859788 bytes
Database Buffers 264241152 bytes
Redo Buffers 2924544 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/oracle/oradata/ORCL/system01.dbf'
解决方法是:恢复数据文件
SQL> recover datafile '/u01/oracle/oradata/ORCL/system01.dbf' --恢复数据文件
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: '/u01/oracle/oradata/ORCL/undotbs01.dbf'
SQL> recover datafile '/u01/oracle/oradata/ORCL/undotbs01.dbf'
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3: '/u01/oracle/oradata/ORCL/sysaux01.dbf'
SQL> recover datafile '/u01/oracle/oradata/ORCL/sysaux01.dbf'
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: '/u01/oracle/oradata/ORCL/users01.dbf'
SQL> recover datafile '/u01/oracle/oradata/ORCL/users01.dbf'
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/u01/oracle/oradata/ORCL/example01.dbf'
SQL> recover datafile '/u01/oracle/oradata/ORCL/example01.dbf'
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 6 needs media recovery
ORA-01110: data file 6: '/u01/oracle/oradata/ORCL/plsql01.dbf'
SQL> recover datafile '/u01/oracle/oradata/ORCL/plsql01.dbf'
Media recovery complete.
SQL> recover datafile '/u01/oracle/oradata/ORCL/dmptest01.dbf'
Media recovery complete.
SQL> alter database open;
Database altered.
数据库open来就可以了
说明:本实验oracle的版本是10.2.0.4.0
Oracle Database Partition 技术
Oracle数据库导入导出时,ORA-39083;ORA-00439错误解决思路
内容总结
以上是互联网集市为您收集整理的Oracle备份时发生断电的对策全部内容,希望文章能够帮你解决Oracle备份时发生断电的对策所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。