[Oracle] oracle 禁用fast recovery area


本文总阅读量

1、如果数据库开启了flashback database需要禁用

alter database flashback off;

2、修改log_archive_dest_n参数,将其值修改为非fast recovery area

未修改之前:
LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'
(LOCATION=USE_DB_RECOVERY_FILE_DEST配置fast recovery area,该参数值为 DB_RECOVERY_FILE_DEST初始化参数指定的值)
修改为非FRA:
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=/ORACLE/DBS/';

3、之后禁用fra初始化参数

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='';

目录
  1. 1. 1、如果数据库开启了flashback database需要禁用
  2. 2. 2、修改log_archive_dest_n参数,将其值修改为非fast recovery area
  3. 3. 3、之后禁用fra初始化参数

Proudly powered by Hexo and Theme by Lap
本站访客数人次
© 2020 zeven0707's blog