数据库|mysql教程
oracle备份恢复,无归档,无备份,rm误删除所数据文件
数据库-mysql教程
网站克隆系统源码,vscode怎么同时输入,ubuntu突然注销,src显示tomcat图片,爬虫 免责,php插入数据库乱码,建筑seo优化案例收录,精美网站源 码,苹果cms美化模板lzw
恢复的原理，请查看关于该恢复主题的第一篇博文：http://fly1116./8301004/1337681恢复过程使用的fly.sh脚本，及其他脚本的简..
gom注册机源码,vscode 自动触发,ubuntu SFP,tomcat 定时关机,sqlite 列格式化,口红机公众号插件,微信网页用什么前端框架,怎么解决淘宝的反爬虫,php是java吗,上海seo提高口碑,做高端网站的网络公司,网页视频悬浮播放代码,响应式app网站模板下载lzw
如何搭建时时彩网站源码,ubuntu软件手册,tomcat无法添加项目中,茶树爬虫图片,微信模版消息php,吉林特定seo优化价格比较lzw
恢复的原理，请查看关于该恢复主题的第一篇博文：
恢复过程使用的fly.sh脚本，及其他脚本的简要介绍，请看关于该恢复主题的第二篇博文：
在数据库非归档状态，没有任何的备份情况下，通过操作系统命令rm，误删除了所有数据文件，要如何恢复呢
1、数据库版本11.1.0.7.0和数据库处于非归档状态
SQL> select * from v$version;
BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
PL/SQL Release 11.1.0.7.0 – Production
CORE 11.1.0.7.0
Production
TNS for Linux: Version 11.1.0.7.0 – Production
NLSRTL Version 11.1.0.7.0 – Production
SQL> archive log list;
Database log mode
No Archive Mode
Automatic archival
Disabled
Archive destination
/archivelog
Oldest online log sequence
45
Current log sequence
47
SQL>
2、在fly用户下创建fly表,表记录为：2256800
SQL> conn fly/fly
Connected.
SQL> create table fly as select * from dba_objects;
Table created.
SQL> insert into fly select * from fly;
70525 rows created.
SQL> /
141050 rows created.
SQL> /
282100 rows created.
SQL> /
564200 rows created.
SQL> /
1128400 rows created.
SQL> commit;
Commit complete.
SQL> select count(*) from fly;
COUNT(*)
———-
2256800
3、查看所有数据文件，以及删除所有数据文件
oracle@fly007:~> cat fly.sh
#!/bin/bash
rman target sys/oracle</dev/null
crosscheck archivelog all;
delete noprompt expired archivelog all;
quit
EOF
if [ -f fly_datafile.sh ];then
rm fly_datafile.sh
fi
sqlplus /nolog< cat fly.sql
set echo on
col file_name format a80
col name format a100
set linesize 200
select file_name from dba_data_files;
select name from v$archived_log where name is not null;
set echo off
set heading off
set newpage none
set feedback off
set termout off
set trimspool on
spool fly_datafile.sh
select ‘rm’||’ ‘||file_name from dba_data_files;
select ‘rm’||’ ‘||name from v$archived_log where name is not null;
spool off
quit
oracle@fly007:~> ./fly.sh
SQL*Plus: Release 11.1.0.7.0 – Production on Mon Dec 9 21:11:29
Copyright (c) 1982, , Oracle. All rights reserved.
SQL> Connected.
SQL> SQL> col file_name format a80
SQL> col name format a100
SQL> set linesize 200
SQL> select file_name from dba_data_files;
FILE_NAME
——————————————————————————–
/home/oracle/oradata/fly/datafiles/fly01.dbf
/home/oracle/oradata/APPLE/datafile/users02.dbf
/home/oracle/oradata/APPLE/datafile/o1_mf_users_8mfvsbdd_.dbf
/home/oracle/oradata/APPLE/datafile/o1_mf_undotbs1_8mfvsbbx_.dbf
/home/oracle/oradata/APPLE/datafile/o1_mf_sysaux_8mfvsb9t_.dbf
/home/oracle/oradata/APPLE/datafile/o1_mf_system_8mfvsb5r_.dbf
/home/oracle/oradata/APPLE/datafile/o1_mf_example_8mfvwlmk_.dbf
/home/oracle/oradata/APPLE/datafile/example02.dbf
/home/oracle/oradata/APPLE/datafile/example03.dbf
/home/oracle/oradata/APPLE/datafile/example04.dbf
/home/oracle/oradata/APPLE/datafile/example05.dbf
/home/oracle/oradata/APPLE/datafile/system03.dbf
/home/oracle/oradata/APPLE/datafile/sysaux03.dbf
13 rows selected.
SQL> select name from v$archived_log where name is not null;
no rows selected
SQL> set echo off
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
oracle@fly007:~> cat fly_datafile.sh
rm /home/oracle/oradata/fly/datafiles/fly01.dbf
rm /home/oracle/oradata/APPLE/datafile/users02.dbf
rm /home/oracle/oradata/APPLE/datafile/o1_mf_users_8mfvsbdd_.dbf
rm /home/oracle/oradata/APPLE/datafile/o1_mf_undotbs1_8mfvsbbx_.dbf
rm /home/oracle/oradata/APPLE/datafile/o1_mf_sysaux_8mfvsb9t_.dbf
rm /home/oracle/oradata/APPLE/datafile/o1_mf_system_8mfvsb5r_.dbf
rm /home/oracle/oradata/APPLE/datafile/o1_mf_example_8mfvwlmk_.dbf
rm /home/oracle/oradata/APPLE/datafile/example02.dbf
rm /home/oracle/oradata/APPLE/datafile/example03.dbf
rm /home/oracle/oradata/APPLE/datafile/example04.dbf
rm /home/oracle/oradata/APPLE/datafile/example05.dbf
rm /home/oracle/oradata/APPLE/datafile/system03.dbf
rm /home/oracle/oradata/APPLE/datafile/sysaux03.dbf
oracle@fly007:~> ./fly_datafile.sh
oracle@fly007:~>
4、fly用户创建表报错
oracle@fly007:~> sqlplus /nolog
SQL*Plus: Release 11.1.0.7.0 – Production on Mon Dec 9 21:11:52
Copyright (c) 1982, , Oracle. All rights reserved.
SQL> conn sys/oracle as sysdba
Connected.
SQL> conn fly/fly
Connected.
SQL> create table fly008 as select * from dba_objects;
create table fly008 as select * from dba_objects
*
ERROR at line 1:
ORA-01116: error in opening database file 7
ORA-01110: data file 7: ‘/home/oracle/oradata/fly/datafiles/fly01.dbf’
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
