Microsoft Windows [版本 6.1.7600]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

C:\Users\Administrator>sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on 星期三 3月 7 11:22:34 2012

连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create tablespace test datafile 'D:\app\Administrator\oradata\orcl\test01.d
bf' size 10M;

表空间已创建。

SQL> create table scott.t(id number,name varchar2(50))tablespace test;

表已创建。

SQL> insert into scott.t values(1,'pp');

已创建 1 行。

SQL> insert into scott.t values(11,'p');

已创建 1 行。

SQL> commit;

提交完成。

SQL> shutdown abort
ORACLE 例程已经关闭。
SQL> exit

从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options(情
况复杂) 断开

C:\Users\Administrator>sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on 星期三 3月 7 11:26:17 2012

连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS NOARCHIVELOG
2      MAXLOGFILES 16
3      MAXLOGMEMBERS 3
4      MAXDATAFILES 100
5      MAXINSTANCES 8
6      MAXLOGHISTORY 292
7 LOGFILE
8    GROUP 1 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG' SIZE 50M,
9    GROUP 2 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG' SIZE 50M,
10    GROUP 3 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG' SIZE 50M
11 -- STANDBY LOGFILE
12 DATAFILE
13    'D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF',
14    'D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF',
15    'D:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF',
16    'D:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01.DBF',
17    'D:\APP\ADMINISTRATOR\ORADATA\ORCL\EXAMPLE01.DBF'
18 CHARACTER SET ZHS16GBK
19 ;

控制文件已创建。

SQL> alter session set nls_date_format='yyyymmdd hh24:mi:ss';

会话已更改。

SQL> recover database until time '20120307 11:25:04';
ORA-00283: ??????????
ORA-01244: ????????????????????
ORA-01110: ???? 6: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\TEST01.DBF'

SQL> alter database create datafile 6 as 'D:\app\Administrator\oradata\orcl\test
01.dbf';

数据库已更改。

SQL> recover database;
完成介质恢复。
SQL> alter database open;

数据库已更改。

SQL> select * from scott.t;

        ID NAME
---------- --------------------------------------------------
         1 pp
        11 p

SQL>

ITPub博客

模拟丢失控制文件和数据文件shutdown abort

最新文章