為什么80%的碼農(nóng)都做不了架構(gòu)師？>>>

1.確認(rèn)當(dāng)前模式

SYS AS SYSDBA on 29-MAR-05 >select flashback_on from v$database;

FLA

---

NO

2.檢查/修改恢復(fù)區(qū)設(shè)置

SYS AS SYSDBA on 29-MAR-05 >show parameter db_recovery_file_dest

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest string /data5/flash_recovery_area

db_recovery_file_dest_size big integer 10G

3.檢查/修改閃回時間設(shè)置

SYS AS SYSDBA on 29-MAR-05 >show parameter db_flashback_retention_target

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_flashback_retention_target integer 60

SYS AS SYSDBA on 29-MAR-05 >alter system set db_flashback_retention_target=1440;

System altered.

4.重新啟動數(shù)據(jù)庫到Mount狀態(tài)

啟動flashback database選項。

SYS AS SYSDBA on 29-MAR-05 >shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SYS AS SYSDBA on 29-MAR-05 >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 database flashback on;

Database altered.

SYS AS SYSDBA on 29-MAR-05 >alter database open;

Database altered.

總結(jié)

以上是生活随笔為你收集整理的oracle 启用闪回数据库,如何启用Oracle10g闪回数据库特性的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。