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

SQL> select * from test;

        ID
gu9m/z paf+r0----------ITPUB个人空间P R"iL'U
         1ITPUB个人空间1v(A1so8y0?2vz5`
         2

SQL> shutdown immediate;ITPUB个人空间"mXc%G8FuFY2~
Database closed.
n6_"`p1~)E&S1[0Database dismounted.
Z?l1f|g#D#e0ORACLE instance shut down.

备份cp 所有数据文件
#[#Al&Y#R.{H0SQL> startupITPUB个人空间yZt)I.i8Lk]N#rX
ORACLE instance started.

Total System Global Area  546382300 bytes
~Qw7H9|%[0Fixed Size                   455132 bytes

J/r
n0Iv"y%O0Variable Size             520093696 bytesITPUB个人空间8B!Fm }6R:z!A
Database Buffers           25165824 bytesITPUB个人空间'`;? eL4a}uN&N{
Redo Buffers                 667648 bytesITPUB个人空间 B1[0\A2|'u
Database mounted.
"V.GNM0T0Database opened.ITPUB个人空间2P,ogbU!~I
SQL> select * from test;

        IDITPUB个人空间4z~~5B!b2K!rY^;p'Z5s
----------ITPUB个人空间J }K$l
\%j Q
         1ITPUB个人空间9I\'U#xqP
         2

SQL> insert into test values(3);

1 row created.

SQL> commit;

Commit complete.

SQL> select dbms_flashback.get_system_change_number from dual;   --查出scn号

GET_SYSTEM_CHANGE_NUMBER
.oF\G t r
|h{0------------------------ITPUB个人空间 w%@ vb9wl
O
                 1219138

SQL> drop table test;

Table dropped.

SQL> shutdown immediate;ITPUB个人空间K:v"\P S,sTs_
Database closed.ITPUB个人空间$g0Q#Z)UJ$JD
Database dismounted.
V:g2f R4CU\$r0ORACLE instance shut down.

恢复备份的所有数据文件ITPUB个人空间0D@N0r4@4elO1_
SQL> startup mount
N#g!izi5v0o{:}x0ORACLE instance started.

Total System Global Area  546382300 bytesITPUB个人空间S|
[F$V,d\
Fixed Size                   455132 bytesITPUB个人空间y%Z d o!_
MW^/|8`
Variable Size             520093696 bytes
[ K0jd Ogr0Database Buffers           25165824 bytes
hzN|(t!Q%c`0Redo Buffers                 667648 bytes
%Dn%C-`(ZVP%PB$p*l0Database mounted.ITPUB个人空间)_z&D1Be A3O u?J
SQL>recover database until change 1219138;    --基于scn的不完全恢复
5K w#m%BNQw0Media recovery complete.
g e0oP~Z"l0SQL> alter database open resetlogs;

Database altered.

SQL> select * from test;

        ID
4lP7`p6[s8uxZs0----------
CR,g(Ne)GS0         1
!mc'g o|q0         2ITPUB个人空间+hG^H!md$AB
         3

SQL>