用Flashback database功能恢复用户错误

核心提示： （4）下面我们来进行闪回操作SYS AS SYSDBA on 2005-03-29 17:03:43 >shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SYS AS SY

（4）下面我们来进行闪回操作

SYS AS SYSDBA on 2005-03-29 17:03:43 >shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS AS SYSDBA on 2005-03-29 17:04:04 >startup mount;
ORACLE instance started.
Total System Global Area　314572800 bytes
Fixed Size　　　　　　　　　1301704 bytes
Variable Size　　　　　　 261890872 bytes
Database Buffers　　　　　 50331648 bytes
Redo Buffers　　　　　　　　1048576 bytes
Database mounted.
SYS AS SYSDBA on 29-MAR-05 >alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
Session altered.
SYS AS SYSDBA on 2005-03-29 17:05:31 >select * from V$FLASHBACK_DATABASE_LOG;
OLDEST_FLASHBACK_SCN OLDEST_FLASHBACK_TI RETENTION_TARGET FLASHBACK_SIZE ESTIMATED_FLASHBACK_SIZE
-------------------- ------------------- ----------------
　　　　　　10642627 2005-03-29 17:01:02　　　　　　 1440　　　　8192000　　　　　　　　　　　　0
SYS AS SYSDBA on 2005-03-29 17:06:38 >flashback database to timestamp
　2　to_timestamp ('2005-03-29 17:02:28','yyyy-mm-dd hh24:mi:ss');
Flashback complete.

（5）只读打开，验证数据

SYS AS SYSDBA on 2005-03-29 17:06:58 >alter database open read only;
Database altered.
SYS AS SYSDBA on 2005-03-29 17:07:07 >desc t3　　
ERROR:
ORA-04043: object t3 does not exist
SYS AS SYSDBA on 2005-03-29 17:07:39 >desc t1
ERROR:
ORA-04043: object t1 does not exist