eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« 启用Block Change Tracking-10g新特性 | Blog首页 | 使用Oracle10g Flashback database功能恢复用户错误 »

如何启用Oracle10g闪回数据库特性
modb.pro

1.确认当前模式

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

2.检查/修改恢复区设置

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.检查/修改闪回时间设置

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.重新启动数据库到Mount状态
启动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.


历史上的今天...
    >> 2013-03-29文章:
    >> 2011-03-29文章:
    >> 2007-03-29文章:

By eygle on 2005-03-29 17:07 | Comments (0) | Backup&Recovery | 226 |


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com