Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1061881
  • 博文数量: 239
  • 博客积分: 10
  • 博客等级: 民兵
  • 技术积分: 3618
  • 用 户 组: 普通用户
  • 注册时间: 2012-11-12 13:17
文章分类

全部博文(239)

文章存档

2021年(1)

2016年(1)

2015年(30)

2014年(91)

2013年(116)

分类: LINUX

2014-10-25 16:42:42

SQL> show parameter DB_RECOVERY_FILE_DEST
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest     string /u01/oracle/fast_recovery_area
db_recovery_file_dest_size     big integer 4122M
SQL> ALTER SYSTEM SET db_recovery_file_dest_size=3g SCOPE=BOTH;
System altered.
SQL> ALTER SYSTEM SET db_recovery_file_dest='/u01/oracle/fast' SCOPE=BOTH;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size    2228784 bytes
Variable Size  989859280 bytes
Database Buffers  603979776 bytes
Redo Buffers    7344128 bytes
Database mounted.
SQL> ALTER DATABASE FLASHBACK OFF;
Database altered.
SQL> ALTER DATABASE FLASHBACK ON;
Database altered.
SQL> alter database open;
Database altered.
SQL> show parameter DB_RECOVERY_FILE_DEST
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest     string /u01/oracle/fast
db_recovery_file_dest_size     big integer 3G
阅读(4916) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~