How to change Flash Recovery Area to a new location ? (文档 ID 305651.1)
来源:互联网 发布:欧文16年数据 编辑:程序博客网 时间:2024/05/16 09:27
APPLIES TO:
Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterInformation in this document applies to any platform.
***Checked for relevance on 14-Oct-2013***
GOAL
This document shows how to change the Flash Recovery Area destination and
how to move the files from old area to new area.
SOLUTION
How to change Flash Recovery Area to a new location ?
-----------------------------------------------------
If you need to move the Flash Recovery Area of your database to a new location,
invoke SQL*Plus to change the DB_RECOVERY_FILE_DEST initialization parameter.
For example:
After you change this parameter, all new Flash Recovery Area files will be
created in the new location.
The permanent files (control files and online redolog files), flashback logs
and transient files can be left in the old Flash Recovery Area location. The
database will delete the transient files from the old Flash Recovery Area
location as they become eligible for deletion.
For the FLASHBACK logfiles to be able to to pick up the new 'db_recovery_file_dest' location,
the flashback option needs to be toggled off and on.
This can be done like this:
SQL> shutdown immediate
- Startup mount the Database:
SQL> startup mount;
- Drop the garanteed restore points
SQL> select * from v$restore_point;
drop restore point <name>;
- Toggle the Flashback off:
SQL> alter database flashback off;
- Toggle the Flashback on:
SQL> alter database flashback on;
- Open the Database:
SQL> alter database open;
If you need to actually move your current permanent files, transient files, to the new Flash Recovery Area, then follow the following steps:
1) To move the existing backupsets and archived redo log files,use the following command:
RMAN> BACKUP DEVICE TYPE DISK BACKUPSET ALL DELETE INPUT;
2) To move the datafile copies. Run the below command for each datafile copy:
where the <name> is the datafilecopy name in the old recovery area.
3) To move the controlfile from the old Flash Recovery Area to new one.
Change the location in the parameter CONTROL_FILES to the new location
and restart the instance in NOMOUNT.
4) To move the online redo logs. Use the commands to add a a log file stored in
the new Flash Recovery Area and drop the logfile in the old Flash Recovery Area
for each redo log group.
SQL> alter database drop logfile '<name of the old redo log>';
Oracle will clean up transient files remaining in the old Flash Recovery Area
location as they become eligible for deletion.
REFERENCES
NOTE:833663.1 - Flash Recovery Area - FAQNOTE:460145.1 - Space Usage Figures in V$flash_recovery_area_usage Misleading When FRA Location is Changed
- Oracle Database Products > Oracle Database > Oracle Database > Oracle Database - Enterprise Edition > Flashback Recovery > Flash Recovery Area
- How to change Flash Recovery Area to a new location ? (文档 ID 305651.1)
- What is a Flash Recovery Area and how to configure it ? (文档 ID 305648.1)
- What is a Flash Recovery Area and how to configure it ? (文档 ID 305648.1)
- Flash Recovery Area - FAQ (文档 ID 833663.1)
- how to change official rom to support a new language
- How is the space pressure managed in the Flash Recovery Area - An Example. (文档 ID 315098.1)
- How to flash the recovery
- Migrating the Flash Recovery Area to ASM
- Flash Recovery Area Full - Database Fails to Open ORA-16038 [ID 337258.1]
- Space issue in Flash Recovery Area( FRA ) (文档 ID 829755.1)
- HOW TO ADD A NEW A WIDGET AREA TO YOUR WORDPRESS THEME
- gparted and how to change /home directory to a new partition
- How to Recreate a Controlfile (文档 ID 735106.1)
- How to change the filenames queque to new filenames
- JDev: How to change SVN Repository location in JDev?
- RESTORE DATAFILE TO A NEW LOCATION
- How to get new record's id
- Career Change: Tips on How to Look for a New Job
- 接上篇,通过JQuery获取网页中图片的宽度和高度---示例
- Mount Options for Oracle files when used with NFS on NAS devices (文档 ID 359515.1)
- ENGLISH资料收集(28)-男女不应有别
- Cognos入门教程(一)- powerplay client安装
- C++类型转换
- How to change Flash Recovery Area to a new location ? (文档 ID 305651.1)
- LA3135——Argus(优先队列)
- Sizeof与Strlen的区别与联系
- 思考跨域
- Linux多线程,基本概念
- 最大后验估计(MAP)
- Stl vector,map set简单用法
- Xerces C++ 学习笔记
- tiny6410编译u-boot