Oracle Flashback--oracle Data Flashback, and recovers data to a specified timestamp--timestamp

Microsoft Windows [version 6.1.7601] Copyright (c) Microsoft Corporation. All rights reserved. C:\users\ckz>sqlplus ZZJD/[EMAIL PROTECTED]/ORCL as SYSDBA;  Sql*plus:release 11.2.0.1.0 Production on Wednesday May 17:00:46 2015Copyright (c) 1982, Oracle.  All rights reserved. Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-productionwith The partitioning, OLAP, Data Mining and Real application testing optionssql> SHUTDOWN IMMEDIATE; the database is closed. The database has been uninstalled. The ORACLE routine has been closed. Sql> startup Mount;oracle Routine has been started. Total System Global area 1071333376 bytesfixed size 1375792 bytesvariable size 713032144 byte Sdatabase buffers 352321536 Bytesredo buffers 4603904 bytes database loaded. Sql> Flashback database to SCN 119272598; Flashback complete. sql> alter Open;alter database open* 1th Row error: ORA-01589: To open the database you must use the Resetlogs or Noresetlogs option sql> alter D Atabase Open Noresetlogs;alter Database open noresetlogs* 1th line error: ORA-01610: Recovery with BACKUP controlfile option must be completedsql> ALTER DATABASE open resetlogs; Sql>

To view the recoverable timestamp or SCN point, execute the following SQL statement:

Select Scn,to_char (TIME_DP, ' Yyyy-mm-dd hh24:mi:ss ') from Sys.smon_scn_time Order by To_char (TIME_DP, ' Yyyy-mm-dd hh24: Mi:ss ') desc;

It is not recommended to use this method to recover data.

Method Two:

Empty the data table you want to recover before you manipulate the recovery data table to avoid data conflicts when recovering

Oracle Flashback--oracle Data Flashback, and recovers data to a specified timestamp--timestamp