oracle back log,Oracle -- flashback database基于ARC+flashback_log还是flashback_log

测试如果没有FLASHBACK log怎么样的报错...

SQL> select current_scn from v$database;

CURRENT_SCN

-----------

9795505

SQL> drop table test;

Table dropped.

SQL> select current_scn from v$database;

CURRENT_SCN

-----------

9795553

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area  171966464 bytes

Fixed Size                   787988 bytes

Variable Size             145488364 bytes

Database Buffers           25165824 bytes

Redo Buffers                 524288 bytes

Database mounted.

SQL> flashback database to scn 9795553;

Flashback complete.

SQL> alter database open resetlogs;

Database altered.

SQL> select current_scn from v$database;

CURRENT_SCN

-----------

9795785

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area  171966464 bytes

Fixed Size                   787988 bytes

Variable Size             145488364 bytes

Database Buffers           25165824 bytes

Redo Buffers                 524288 bytes

Database mounted.

SQL> host del D:\oracle\product\10.1.0\flash_recovery_area\ORCL\FLASHBACK\*

D:\oracle\product\10.1.0\flash_recovery_area\ORCL\FLASHBACK\*, 是否确认(Y/N)? y

D:\oracle\product\10.1.0\flash_recovery_area\ORCL\FLASHBACK\O1_MF_8PZXZY1G_.FLB

另一个程序正在使用此文件，进程无法访问。

--强制删除  再闪回 报错....

SQL> flashback database to scn 9795553;

flashback database to scn 9795553

*

ERROR at line 1:

ORA-38701: Flashback database log 1 seq 1 thread 1: "D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL\FLASHBACK\O1_MF_8PZ

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) 系统找不到指定的文件。

-------------所以测试：flashback database 基于archive log+FLASHBACKlog