rchive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 13
Next log sequence to archive 15
Current log sequence 15
sys@ORCL> select force_logging,flashback_on from v$database;
FOR FLASHBACK_ON
--- ------------------
YES YES
㈡ 测试
[sql]
hr@ORCL> select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
731867
hr@ORCL> truncate table t2;
www.2cto.com
Table truncated.
hr@ORCL> conn / as sysdba
Connected.
sys@ORCL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@ORCL> startup mount
ORACLE instance started.
Total System Global Area 419430400 bytes
Fixed Size 1219760 bytes
Variable Size 83886928 bytes
Database Buffers 331350016 bytes
Redo Buffers 2973696 bytes
Database mounted.
sys@ORCL> flashback database to scn 731867;
Flashback complete.
sys@ORCL> alter database open resetlogs;
www.2cto.com
Database altered.
sys@ORCL> select count(*) from hr.t2;
COUNT(*)
----------
19