基于时间不完全恢复之rman篇(五)
kp tag=TAG20130731T224101 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/home/oracle/archivelog/1_3_822243364.dbf RECID=21 STAMP=822264061
Finished backup at 31-JUL-13
[oracle@node1 backupset]$ cd 2013_07_31/
[oracle@node1 2013_07_31]$ ls
o1_mf_annnn_TAG20130731T184620_8zktqws5_.bkp
o1_mf_annnn_TAG20130731T223852_8zl8cxq2_.bkp
o1_mf_annnn_TAG20130731T223852_8zl8dgfj_.bkp
o1_mf_annnn_TAG20130731T223852_8zl8dkt6_.bkp
o1_mf_annnn_TAG20130731T224101_8zl8hxw0_.bkp
o1_mf_ncsnf_TAG20130731T223917_8zl8hvz0_.bkp
o1_mf_nnndf_TAG20130731T223917_8zl8dpg6_.bkp
[oracle@node1 2013_07_31]$ ls -tl
total 1224012
-rw-r----- 1 oracle oinstall 3072 Jul 31 22:41 o1_mf_annnn_TAG20130731T224101_8zl8hxw0_.bkp
-rw-r----- 1 oracle oinstall 9830400 Jul 31 22:41 o1_mf_ncsnf_TAG20130731T223917_8zl8hvz0_.bkp
-rw-r----- 1 oracle oinstall 1080147968 Jul 31 22:40 o1_mf_nnndf_TAG20130731T223917_8zl8dpg6_.bkp--这个是数据文件的备份文件集
-rw-r----- 1 oracle oinstall 31120384 Jul 31 22:39 o1_mf_annnn_TAG20130731T223852_8zl8dkt6_.bkp
-rw-r----- 1 oracle oinstall 25585664 Jul 31 22:39 o1_mf_annnn_TAG20130731T223852_8zl8dgfj_.bkp
-rw-r----- 1 oracle oinstall 102524928 Jul 31 22:39 o1_mf_annnn_TAG20130731T223852_8zl8cxq2_.bkp
-rw-r----- 1 oracle oinstall 2908672 Jul 31 18:46 o1_mf_annnn_TAG20130731T184620_8zktqws5_.bkp
SQL> create table u2_table(id number,name varchar2(50),password varchar2(50));
Table created.
SQL> insert into u2_table(88,'cunxm','chenjian');
insert into u2_table(88,'cunxm','chenjian')
*
ERROR at line 1:
ORA-00928: missing SELECT keyword
SQL> c/table/table values;--SQL写错了,可以这样替换喔
1* insert into u2_table values(88,'cunxm','chenjian')
SQL> /
1 row created.
SQL> /
1 row created.
SQL> commit;
Commit complete.
SQL> commit;
Commit complete.
SQL> select table_name from user_tables;
TABLE_NAME
------------------------------
CJ
U2_TABLE
SQL> select * from cj;
ID NAME
---------- --------------------------------------------------
1 cj
8 cj888
SQL> drop user u2 cascade;
drop user u2 cascade
*
ERROR at line 1:
ORA-01031: insufficient privileges--权限不够,切换管理员用户操作
SQL> conn / as sysdba
Connected.
SQL> dropt user u2 cascade;--关联删除
SP2-0734: unknown command beginning "dropt user..." - rest of line ignored.
SQL> drop user u2 cascade;
User dropped.
SQL> conn u1/u1;
Connected.
SQL> drop table cj purge;--干净删除,学过闪回表之前必作的动作
Table dropped.
SQL> purge recyclebin; --清除回收站,以免误解
SQL> shutdown immediate
ORA-01031: insufficient privileges
SQL> conn / as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
[oracle@node1 2013_07_31]$ export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss';
[oracle@node1 2013_07_31]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 31 22:57:25 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
--在准备恢复之前,在删除u2用户,以及删除u1表CJ;以便认识这些不完全恢复的时间点,是不是删除的表与用户都可以,但后来u2建立的表u2_table是无法重现了,