When we are trying to connect to database then getting below error message.
Database 10gr1
SQL> conn system/oracle@orcl
ORA-00257: archiver error. Connect internal only, until freed.
Note: When check alert_sid.log file and come to know flash_recovery_area is full.
then increase "db_recovery_file_dest_size" parameter value
SQL> alter system set db_recovery_file_dest_size =6g;
System altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16038: log 1 sequence# 20351 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\REDO01.LOG'
Note: After increase "db_recovery_file_dest_size" parameter value getting above error.
So need to check flash_recovery_area V$recovery_file_dest for how much space needed.
NAME SPACE USED
---------------------------------------- ---------- ----------
D:\oracle\product\10.1.0\Flash_recovery 6144 8603
Note: need to increase more 3 gb size in flash_recovery_area.
SQL> alter system set db_recovery_file_dest_size = 10g;
System altered.
SQL> alter database open;
Database altered.
6 comments:
Nice dispatch and this fill someone in on helped me alot in my college assignement. Thank you on your information.
THANK YOU DUDE..ITS WORKING FOR ME..
Thank you so much boss.
I tried for this since 1 hour.But with your tip I did it in 1 minute
Thank you so much......
Thanks for your information .
Most of the blogger user this command "alter system set db_recovery_file_dest_size=30GB;"
but its occurs error,
alter system set db_recovery_file_dest_size=30GB;
Most of the blogger use this commands
but its wrong
Post a Comment