Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2087807
  • 博文数量: 1647
  • 博客积分: 80000
  • 博客等级: 元帅
  • 技术积分: 9980
  • 用 户 组: 普通用户
  • 注册时间: 2008-10-13 15:15
文章分类

全部博文(1647)

文章存档

2011年(1)

2008年(1646)

我的朋友

分类:

2008-10-28 18:29:24


  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.
【责编:admin】

--------------------next---------------------

阅读(307) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~