节点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.转移或者删除闪回恢复区里的归档日志。