备份与恢复:用user_command方式基于时间的不完全恢复

SQL> select * from test;

        IDITPUB个人空间y3R8C ^*fW%~E)mA7\
----------
,x'}
u#bh2sc%po0         1

SQL> shutdown immediate;ITPUB个人空间/?w F%Me
Database closed.
/x*z L6CHA|(Q0Database dismounted.
Q#mv.PJR1QE0ORACLE instance shut down.

这时备份所有数据文件
`:Iv8Z3lr-n
W0SQL> startupITPUB个人空间&wIB1uq
ORACLE instance started.

Total System Global Area  546382300 bytesITPUB个人空间w3}/VzX
Fixed Size                   455132 bytesITPUB个人空间4g!xm&h'dM0i2u
Variable Size             520093696 bytesITPUB个人空间'^t3{L o+S
Database Buffers           25165824 bytesITPUB个人空间'Y} p-^7d,Wx
Redo Buffers                 667648 bytes
E9QAYaLuR0Database mounted.
k(c}%aWgZ(s0Database opened.ITPUB个人空间ql X@/{.A3y
SQL> insert into test values(2);

1 row created.

SQL> commit;

Commit complete.

SQL> select sysdate from dual;

SYSDATE
8YsR?,KHk5f6N1\M9q:f0---------ITPUB个人空间S&QIS0Lgm ^
09-APR-08

SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi;ss';

Session altered.

SQL> select sysdate from dual;

SYSDATEITPUB个人空间9J ?1B]S)T
-------------------ITPUB个人空间.SZml)jK#hsg
2008-04-09 09:44;37      --基于这个时间点之前的

SQL> drop table test;

Table dropped.

SQL> shutdown immediate;
OO y
NRk7_`h`7Y0Database closed.
.}&E0Y&Dn+]T0Database dismounted.
5D'A+o ern b
x0ORACLE instance shut down.

把备份的所有数据文件拷贝回来ITPUB个人空间[ nyDO+X/Es
SQL> startup mount;ITPUB个人空间N-q3KcB0?9L
ORACLE instance started.

Total System Global Area  546382300 bytes
K@N7n9RQy0Fixed Size                   455132 bytes
0Q!TSm@\B;{"|p0Variable Size             520093696 bytesITPUB个人空间x a~4r%a3rR
Database Buffers           25165824 bytes
mSf s t;W.]0Redo Buffers                 667648 bytesITPUB个人空间(v2R q T
O6F,Y%r-co
Database mounted.ITPUB个人空间7C2Y&d{%XYV5Y
SQL>recover database until time '2008-04-09 09:44:37';  做基于时间的不完全恢复
eX0co{%{QmT0Media recovery complete.
4Y;T2f#]C:H Lvi0SQL> alter database open resetlogs;

Database altered.

SQL> select * from test;

        ID
{h&A~n0----------ITPUB个人空间%G&r|r(u3c y-K
         1ITPUB个人空间 y h;YYvV
         2

SQL>