Oracle 11g: Flashback Data Archive 

SQL> create tablespace FDA1 datafile '/s01/app/oracle/oradata/DB11G/FDA01.dbf' size 50M;

Tablespace created.

SQL> create flashback archive fla1 tablespace FDA1 retention 1 MONTH;

Flashback archive created.

SQL> col FLASHBACK_ARCHIVE_NAME for a30
SQL> select FLASHBACK_ARCHIVE_NAME,status from dba_flashback_archive
  2  /

FLASHBACK_ARCHIVE_NAME         STATUS
------------------------------ -------
FLA1

SQL> alter flashback archive fla1 set default;

Flashback archive altered.

SQL> select FLASHBACK_ARCHIVE_NAME,status from dba_flashback_archive
  2  /

FLASHBACK_ARCHIVE_NAME         STATUS
------------------------------ -------
FLA1                           DEFAULT

 

posted @ 2013-04-10 10:56  码尔代夫iimax  阅读(225)  评论(0)  编辑  收藏  举报