误删system04.dbf 报:ORA-01…
来源:互联网 发布:玩具机械战警如何编程 编辑:程序博客网 时间:2024/06/04 23:20
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bitProduction
OS:
Oracle Linux 5.7
非归档模式:
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 625
Current log sequence 627
SQL> alter tablespace system add datafile'/u01/oracle/oradata/yoon/system04.dbf' size 100m;
Tablespace altered.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/u01/oracle/oradata/yoon/system01.dbf
/u01/oracle/oradata/yoon/sysaux01.dbf
/u01/oracle/oradata/yoon/undotbs01.dbf
/u01/oracle/oradata/yoon/users01.dbf
/u01/oracle/oradata/yoon/vpro.dbf
/u01/oracle/oradata/yoon/yoon01.dbf
/u01/oracle/oradata/yoon/svrmg1_oid.dbf
/u01/oracle/oradata/yoon/system02.dbf
/u01/oracle/oradata/yoon/system03.dbf
/u01/oracle/oradata/yoon/system04.dbf
[oracle@yoon yoon]$ mv system04.dbf system04.dbf.bak
SQL> shutdown immediate
ORA-03113: end-of-file on communication channel
Process ID: 9775
Session ID: 1 Serial number: 5
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real ApplicationTesting options
[oracle@yoon ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 27 00:05:022013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 3340451840 bytes
Fixed Size 2232960 bytes
Variable Size 2499808640 bytes
Database Buffers 822083584 bytes
Redo Buffers 16326656 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 10 - see DBWR tracefile
ORA-01110: data file 10:'/u01/oracle/oradata/yoon/system04.dbf'
SQL> startup mount
ORACLE instance started.
Total System Global Area 3340451840 bytes
Fixed Size 2232960 bytes
Variable Size 2499808640 bytes
Database Buffers 822083584 bytes
Redo Buffers 16326656 bytes
Database mounted.
SQL> alter database create datafile'/u01/oracle/oradata/yoon/system04.dbf';
Database altered.
SQL> recover datafile'/u01/oracle/oradata/yoon/system04.dbf';
Media recovery complete.
SQL> alter database open;
Database altered.
- 误删system04.dbf 报:ORA-01…
- impdp报ora-39001 ora-39000&…
- 11g 重建EM 报ORA-20001…
- RMAN 报:ORA-19504 ORA-27038
- ASCP刷快照报错 ORA-27477: "SYS.I…
- ORA-16014,接着 …
- Error: ORA-1505…
- ORA-03137: TTC …
- 强制删除DBF文件导致数据库报“ORA-01033: ORACLE 正在初始化或关闭”错误
- ORA-00700: soft internal error, …
- ORA-00600: internal er…
- 错误:ORA-28002: the …
- ORA-00265: instance re…
- ORA-00494: enqueue [CF…
- ORA-16433 The database…
- ORA-12709: error while…
- ORA-00245: control fil…
- ORA-16179: incremental&nbsp…
- MYSQL 配置slave故障
- socket编程之C语言一个简单监听程序
- RMAN 完全恢复
- show engine innodb status\G
- Oracle11g Install Bbed
- 误删system04.dbf 报:ORA-01…
- mysql无法创建数据库
- 删除redo所有日志,数据库无法启动
- 删除undotbs后,数据库无法启动
- 使用strace工具跟踪系统调用和信号
- ORACLE RAC crs 无法启动
- 5-渗透攻击之旅
- Linux 挂载硬盘方法
- Oracle数据迁移至MySQL