Delete archivelog

[Marcio Souza]

Hello everyone,

I only left the 18th of the 18th to this day), but as I expected Oracle or made aware of it and the rhombus continues. Then I gave CrossCheck Archivelog All, after suing a list he displayed that he checked 198 objects, but still I still did not have the space released.

How can I tell Oracle that this archive no longer exist?

Thanks for the help of all,


Márcio Souza

[gilbertoca]

Your answer is in this discussion: [url=http://forums.oracle.com/forums/thread. ... dID=389408]link
In summary: Download and lift the bank. If you do not solve, delete obsolete files:

Select all

crosscheck archivelog all; 
delete obsolete; 

Gilberto

[Marcio Souza]

I have already performed these two procedures, but then q squeeze the Crosscheck Archive Log All, it accuses fails to validate some files, in fact this fault occurs with most files. What can this be?

Hugs,


Márcio Souza

[gilbertoca]

Post the mistakes!

[Marcio Souza]

This is the return I have after giving Crosscheck Archivelog All; At the RMAN prompt, he lists the 199 objects, but I did not find it necessary to play all this list here, since the message is the same. Follow message:

Select all

validaþÒo bem-sucedida no log arquivado 
nome do arquivo de log de arquivamento=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_A 
REA\DBSIGA\ARCHIVELOG\2007_10_18\O1_MF_1_262_3KGC1W9C_.ARC id reg.=359 marcaþÒo= 
636277793 
validaþÒo bem-sucedida no log arquivado 
nome do arquivo de log de arquivamento=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_A 
REA\DBSIGA\ARCHIVELOG\2007_10_19\O1_MF_1_263_3KJYO1HV_.ARC id reg.=360 marcaþÒo= 
636363400 
validaþÒo bem-sucedida no log arquivado 
nome do arquivo de log de arquivamento=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_A 
REA\DBSIGA\ARCHIVELOG\2007_10_20\O1_MF_1_264_3KNQJHV7_.ARC id reg.=361 marcaþÒo= 
636487155 
validaþÒo bem-sucedida no log arquivado 
nome do arquivo de log de arquivamento=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_A 
REA\DBSIGA\ARCHIVELOG\2007_10_22\O1_MF_1_265_3KS455L8_.ARC id reg.=362 marcaþÒo= 
636631176 
validaþÒo bem-sucedida no log arquivado 
nome do arquivo de log de arquivamento=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_A 
REA\DBSIGA\ARCHIVELOG\2007_10_22\O1_MF_1_266_3KSL8X3D_.ARC id reg.=363 marcaþÒo= 
636645633 
validaþÒo bem-sucedida no log arquivado 
nome do arquivo de log de arquivamento=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_A 
REA\DBSIGA\ARCHIVELOG\2007_10_23\O1_MF_1_267_3KVQGNG5_.ARC id reg.=364 marcaþÒo= 
636716471 
Fez a verificaþÒo cruzada de 199 objetos 
 
RMAN> 

Personal Thanks.

[gilbertoca]

Márcio you did not post any mistake!

Another thing, see what the View v $ recovery_file_dest returns to you.
Oracle will probably not release space, because you must have placed a long retention policy. In this case, it will use all disk space until an instance crash occurs.
http://download-uk.oracle.com/docs/cd/B ... tm#1008989

Gilberto

[Marcio Souza]

Hello Gilberto,

I ended up erasing the lines where it said which files had not been validated. Anyway I lasted the line below to try to inform the Oracle that had erased the Archivelog by Windowns:

Select all

DELETE NOPROMPT ARCHIVELOG UNTIL SEQUENCE = 300;

Now Oracle is seeing what he really has, but as nothing but nothing It was done, I imagine that in a week the space will be at your limit again. Querying the view v $ recovery_file_dest

Select all

SPACE_LIMIT SPACE_USED NUMBER_OF_FILES SPACE_RECLAIMABLE 
----------- ---------- --------------- ----------------- 
 8589934592 1678908928              36                 0

I am currently using 20% ??of the Flah recovery area, if you continue like this, in a few days I will have the same problem. With regard to retention policy, it is set as "none".

Hugs,

[gilbertoca]

You need to establish, in conjunction with the infrastructure team, an off-site backup policy. That is, what you have today is palliative. If a problem occurs with this machine, you will lose everything!
Therefore, there is a need for a tape / dvd backup, etc.

so Oracle begins to claim space and pass cleaning of obsolete files, you also need to establish what we call window-based recovery policy http://download.oracle.com/docs/cd/B193 ... #sthref629 - Recovery Window-Based Policy. That way, you say how many days the backup files should remain in the flash area. This is easy to do through dbconsole.
In this window in days, you make the offup off-site.

Gilberto

[Marcio Souza]

Good morning Gilberto,

We have a whole infra mounted for backup, with tape and now we got a storage, this for production. The problem in question is that this 10G base is development, we do and backup on DVD, but I am hampered to set up the RMAN and leave it because of her cleaning the obsolete files as you even said.


Márcio Souza

[gilbertoca]

This link http://download.oracle.com/docs/cd/B193 ... #sthref279 should help.

This discussion here http://forums.oracle.com/forums/thread. ... &tstart=45 as well.

Gilberto