|
SQL> select name from v$datafile; Variable Size 197135428 bytes
1 以MOUNT方式启动:
D:/DAVE/DAVE.DBF D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/USERS01.DBF
SQL> alter database archivelog;
6 rows selected.
1. 归档模式下。 SQL> select file#,皇冠正网开户,status,name from v$datafile; D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/SYSAUX01.DBF D:/DAVE/TEST.DBF D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/UNDOTBS01.DBF
Redo Buffers 2940928 bytes Database Buffers 373293056 bytes SQL> alter database create datafile 'D:/DAVE/TEST.DBF';
D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/USERS01.DBF ---------------------------------------------------------- 操作步骤： SQL> select name from v$datafile;
Total System Global Area 574619648 bytes 查看数据文件状况 由于只有控制文件中包括了丧失文件信息，才能够通过create datafile方法从新创建文件，通过掌握文件中记载的文件信息、SCN、检讨点等信息,皇冠投注网址，利用归档日志进行恢复，实现完整恢复.
ORACLE instance started. 表已创建,皇冠最新网址。 ALTER DATABASE DATAFILE '----' OFFLINE; ORA-01110: data file 6: 'D:/DAVE/TEST.DBF' Database mounted. Media recovery complete.
ALTER DATAFILE '----' ONLINE;
D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/SYSAUX01.DBF STARTUP MOUNT SQL> startup
Tablespace created. SQL> alter system switch logfile;
SQL> create tablespace test datafile 'D:/DAVE/test.DBF' size 5m; Database altered. SQL> alter database open; D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/SYSTEM01.DBF RECOVER DATAFILE '----'; SQL> shutdown immediate;
SQL> startup mount; SQL> create table t tablespace test as select * from dba_users;
D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/SYSTEM01.DBF
NAME 5 对新数据文件实行恢复: 4 创建一个新的节制的数据文件,皇冠新网址,要乞降原文件大小,新2足球正网,门路,皇冠足球开户,名称都雷同. 2. 使损坏的数据文件离线: 2. 数据文件在当前把持文件之后创立。 否则会报ORA-01178过错,皇冠足球投注网。 SQL> alter system switch logfile; ORA-01110: data file 5: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/USERS01.DBF' SQL> alter database create datafile 'D:/DAVE/TEST.DBF' as 'D:/DAVE/TEST.DBF'; --------------------------------------------------------------
SQL> shutdown immediate; 6 使数据文件在线: ORA-01178: file 5 created before last CREATE CONTROLFILE, cannot recreate D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/UNDOTBS01.DBF
切换归档模式 ALTER DATABASE OPEN; NAME SQL> recover datafile 'D:/DAVE/TEST.DBF'; Fixed Size 1250236 bytes 测试用例： D:/Dave>move test.dbf test.bak D:/DAVE/DAVE.DBF 体系已更改。
条件前提 系统已更改。 3 翻开数据库: ORA-01157: cannot identify/lock data file 6 - see DBWR trace file (责任编辑：admin) |