闪回区大小的更改和闪回的启用 RAC11g

节点1：

停止数据库：shutdown immediate

更改闪回去大小：

启动到mout状态：startup mount;

查看闪回区大小：show parameter db_recovery_file_dest;

修改闪回去大小：ALTER SYSTEM SET db_recovery_file_dest_size=4G scope=both;

打开数据库：alter database open;

 

节点2：

shutdown immediate

startup

 

启用闪回：

alterdatabase flashback off [on]

查看是否在闪回模式：

selectflashback_on from v$database

showparameter flash

selectoldest_flashback_scn,oldest_flashback_time from $flashback_database_log ;

修改闪回时间：

showparameter db_flashback_retention_target

altersystem set db_flashback_retention_target=1440

 

 

 

遇到的报错

ORA-19809: limitexceeded for recovery files问题解决

参考：

http://blog.csdn.net/smstong/article/details/10339193

今天查看数据库管理器出错日志oradim.log 发现如下报警信息：

ORA-16038: log 3sequence# 472 cannot be archived

ORA-19809: limitexceeded for recovery files

ORA-00312: online log3 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\CHEP\REDO03.LOG'

查了一下错误信息

ORA-19809: limitexceeded for recovery files

Cause: The limit forrecovery files specified by the DB_RECOVERY_FILE_DEST_SIZE was exceeded.

Action: The error isaccompanied by 19804. See message 19804 for further details.

ORA-19804: cannotreclaim string bytes disk space from string limit

Cause: Oracle cannotreclaim disk space of specified bytes from the DB_RECOVERY_FILE_DEST_SIZElimit.

Action: There are fivepossible solutions:

1) Take frequentbackup of recovery area using RMAN.

2) Consider changingRMAN retention policy.

3) Consider changingRMAN archivelog deletion policy.

4) Add disk space andincrease DB_RECOVERY_FILE_DEST_SIZE.

5) Delete files fromrecovery area using RMAN.

oracle10g在默认情况下，归档日志是保存在闪回恢复区的，如果你建库的时候用的默认设置，

闪回恢复区应该是2G，空间被占满了以后就无法再归档了

你可以用下面的命令查看其大小和存储位置

SQL> show parameterdb_recovery_file_dest;

NAME                                 TYPE        VALUE

----------------------------------------------- ------------------------------

db_recovery_file_dest                string     C:\oracle\product\10.2.0/flash_recovery_area

db_recovery_file_dest_size           big integer 2G

 

解决方法：

1.增大闪回恢复区。

su - oracle;

sqlplus /nolog;

connect / as sysdba;

startup unmount;

 

ALTER SYSTEM SETdb_recovery_file_dest_size=4g scope=both;

startup;

2.将归档设置到其他目录，修改alter system set log_archive_dest = 其他路径

可事先用show parameter log_archive_dest查看

3.转移或者删除闪回恢复区里的归档日志。