| ORA-00257: archiver error. Connect internal only, until freed. [message #331040] |
Wed, 02 July 2008 03:49  |
bravo13
Messages: 18
Registered: July 2008
|
Junior Member |
|
|
Hi,
I am getting the error ORA-00257: archiver error. Connect internal only, until freed.
I am able to solve it for now by increasing the DB_RECOVERY_FILE_DEST_SIZE .
How can I do it without increasing the DB_RECOVERY_FILE_DEST_SIZE.
SQL> show parameter db_recovery_file_dest;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /data0/app/oracle/flash_recovery_area
db_recovery_file_dest_size big integer 6G
SQL> SELECT * FROM V$RECOVERY_FILE_DEST;
NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
/data0/app/oracle/flash_recovery_area
6442450944 4449029120 0 94
I delete some files from /data0/app/oracle/flash_recovery_area but still that is not reduced from SPACE_USED.
How can this be done.
Thanks in advance..
|
|
|
|
|
|
| Re: ORA-00257: archiver error. Connect internal only, until freed. [message #331133 is a reply to message #331040] |
Wed, 02 July 2008 06:03  |
bravo13
Messages: 18
Registered: July 2008
|
Junior Member |
|
|
Hi,
I have deleted the archivelog using the following commands.
$rman target /
RMAN>delete archivelog until time 'SYSDATE-1';
before doing this i deleted some files manually us "rm -rf" Oracle still shows that space as occupied, as those files are not properly deleted is there any way i can reclaim the space.
SQL> SELECT * FROM V$RECOVERY_FILE_DEST;
NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
/data0/app/oracle/flash_recovery_area
6442450944 2449565696 0 53
while total number of files is not 53 in the filesystem .
|
|
|
|
|
|
| Re: ORA-00257: archiver error. Connect internal only, until freed. [message #331355 is a reply to message #331040] |
Thu, 03 July 2008 02:06 |
bravo13
Messages: 18
Registered: July 2008
|
Junior Member |
|
|
Hi,
The output of crosscheck command is shown below(not full output).
RMAN> crosscheck archivelog all;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=140 devtype=DISK
validation failed for archived log
archive log filename=/data0/app/oracle/flash_recovery_area/ORCL/archivelog/2008_06_20/o1_mf_1_264_45qptdd2_.arc recid=1 stamp=657928871
validation failed for archived log
archive log filename=/data0/app/oracle/flash_recovery_area/ORCL/archivelog/2008_06_21/o1_mf_1_265_45r1oj89_.arc recid=2 stamp=657939979
validation failed for archived log
archive log filename=/data0/app/oracle/flash_recovery_area/ORCL/archivelog/2008_06_21/o1_mf_1_266_45rf9g69_.arc recid=3 stamp=657951881
validation failed for archived log
archive log filename=/data0/app/oracle/flash_recovery_area/ORCL/archivelog/2008_06_21/o1_mf_1_267_45rlxpj1_.arc recid=4 stamp=657957649
validation failed for archived log
archive log filename=/data0/app/oracle/flash_recovery_area/ORCL/archivelog/2008_06_21/o1_mf_1_268_45rv681w_.arc recid=5 stamp=657966113
validation failed for archived log
archive log filename=/data0/app/oracle/flash_recovery_area/ORCL/archivelog/2008_06_21/o1_mf_1_269_45s6hmbn_.arc recid=6 stamp=657977676
I am getting error "validation failed for archived log" for the files which I have deleted using "rm -rf" . that space still remains claimed as used by oracle.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
