Finished recover at 2012-06-07 09:34:15
2.5 打开数据库
SQL> alter database open resetlogs;
Database altered.
2.6 查看恢复后的表
SQL> conn ql/ql;
Connected.
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
TBL_SNS_ATTENTION TABLE
TBL_SNS_BLOG TABLE
TBL_SNS_BLOGREAD TABLE
TBL_SNS_BLOGREPLY TABLE
TBL_SNS_BLOGTRANFER TABLE
TBL_SNS_IMPTBLOG TABLE
TBL_SNS_MAIL TABLE
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
TBL_USER_ADMIN TABLE
TBL_USER_EXPERT TABLE
TBL_USER_INFO TABLE
TBL_USER_PARENT TABLE
TBL_USER_STARPRINCIPAL TABLE
TBL_USER_STARTEACHER TABLE
TBL_USER_STUDENT TABLE
TBL_USER_TEACHER TABLE
TBL_USER_TRANFER TABLE
3. 后续操作
3.1 马上备份数据库
RMAN> backup database;
Starting backup at 2012-06-07 09:36:21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=129 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/opt/oracle/11g/oradata/orcl/undotb
input datafile file number=00002 name=/opt/oracle/11g/oradata/orcl/sysaux
input datafile file number=00001 name=/opt/oracle/11g/oradata/orcl/system
input datafile file number=00004 name=/opt/oracle/11g/oradata/orcl/users0
input datafile file number=00005 name=/opt/oracle/11g/oradata/orcl/exampl
input datafile file number=00006 name=/opt/oracle/11g/software/dbs/rman_t
channel ORA_DISK_1: starting piece 1 at 2012-06-07 09:36:22
channel ORA_DISK_1: finished piece 1 at 2012-06-07 09:37:17
piece handle=/opt/oracle/11g/flash_recovery_area/ORCL/backupset/2012_06_0bkp tag=TAG20120607T093621 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
Finished backup at 2012-06-07 09:37:17
Starting Control File and SPFILE Autobackup at 2012-06-07 09:37:17
piece handle=/opt/oracle/11g/flash_recovery_area/ORCL/autobackup/2012_06_NONE
Finished Control File and SPFILE Autobackup at 2012-06-07 09:37:18
3.2 回收ql删除表的权限