Delete archivelog

DBA Geral (instalação, configuração do banco, scripts do Sql*Plus, shell scripts, batch scripts, etc...)
  

Poston Tue, 23 Oct 2007 11:11 am

Hello guys, I have the following problem, I have a baseteste with 10 g and RMAN and my area of ARCHIVELOG in FLASH_RECOVERY_AREA this bursting, has already used 93% of 8 GB, then deleted in the same hand (just left of the day 18 until today), but unsurprisingly Oracle nor took notice of it and the damage continues. So I gave the ARCHIVELOG ALL CROSSCHECK, after processing a list he exhibited who checked 198 objects, but still haven't got the space released.

How can I inform the Oracle that this arquivso no longer exist?

I appreciate everyone's help, Márcio Souza
Marcio Souza
Location: RJ

Márcio Souza

Poston Tue, 23 Oct 2007 11:38 am

Your answer lies in this discussion: [url = ://forums http . . oracle com/forums/thread . jspa? threadID = 389408] link [/url] in short: download and up the Bank. If not resolved, delete the obsolete files:
Code: Select all
crosscheck archivelog all;
delete obsolete;
Gilberto
gilbertoca
Location: Palmas - TO


Poston Tue, 23 Oct 2007 12:00 pm

I realized these two procedures, but after the squeegee crosscheck q archive all log, he accuses failed validation of some files, in fact this failure occurs with most files. What can that be?

Hugs, Márcio Souza
Marcio Souza
Location: RJ

Márcio Souza

Poston Tue, 23 Oct 2007 12:18 pm

Put the errors!
gilbertoca
Location: Palmas - TO


Poston Tue, 23 Oct 2007 1:23 pm

This is the return q I have after giving CROSSCHECK ARCHIVELOG ALL; In the RMAN PROMPT, he lists the 199 objects, but I didn't think it was necessary to play this whole list aq, since the message is the same. Next post:-------------------------------------------------------------------successful validaþÒo in archived log filename archive log = D:ORACLEPRODUCT10.2.0FLASH_RECOVERY_A READBSIGAARCHIVELOG2007_10_18O1_MF_1_262_3KGC1W9C_.ARC id = 359 reg. marcaþÒo = 636277793 validaþÒo succeed in archived log filename archive log = D:ORACLEPRODUCT10.2.0FLASH_RECOVERY_A READBSIGAARCHIVELOG2007_10_19O1_MF_1_263_3KJYO1HV_.ARC id reg. = marcaþÒo = 360 636363400 validaþÒo succeed in archived log filename archive log = D:ORACLEPRODUCT10.2.0FLASH_RECOVERY_A READBSIGAARCHIVELOG2007_10_20O1_MF_1_264_3KNQJHV7_.ARC id reg. = marcaþÒo = 361 636487155 validaþÒo to succeed in archived log filename archive log = D:ORACLEPRODUCT10.2.0FLASH_RECOVERY_A READBSIGAARCHIVELOG2007_10_22O1_MF_1_265_3KS455L8_.ARC id reg. = 362 marcaþÒo = 636631176 validaþÒo to succeed in archived log filename archive log = D:ORACLEPRODUCT10.2.0FLASH_RECOVERY_A READBSIGAARCHIVELOG2007_10_22O1_MF_1_266_3KSL8X3D_.ARC id reg. = 363 marcaþÒo = 636645633 validaþÒo to succeed in archived log filename archive log = D:ORACLEPRODUCT10.2.0FLASH_RECOVERY_A READBSIGAARCHIVELOG2007_10_23O1_MF_1_267_3KVQGNG5_.ARC id reg. = 364 = marcaþÒo 636716471 made the verificaþÒo crusade of 199 objects RMAN >-------------------------------------------------------------------thanks guys.
Marcio Souza
Location: RJ

Márcio Souza

Poston Tue, 23 Oct 2007 2:14 pm

Márcio you haven't posted any error!

Another thing, look at what the view V $ RECOVERY_FILE_DEST flashback returns to you.
Oracle probably won't release the space, because you must have placed a long retention policy. In this case, it will use all the disk space until a crash occurs.

http://download-uk.oracle.com/docs/cd/B ... tm#1008989 Gilberto
gilbertoca
Location: Palmas - TO


Poston Wed, 24 Oct 2007 1:58 pm

Hello Gilberto, I ended up erasing the lines where it says which files had not been validated. Anyway ultizei the line below to try and inform the oracle who had deleted the archivelog for windowns: DELETE NOPROMPT ARCHIVELOG UNTIL SEQUENCE = 300;

Now Oracle see what you really have, but anything beyond that was made, I imagine that within a week the space will be at its limit again. By querying the view V $ SPACE_LIMIT NUMBER_OF_FILES SPACE_RECLAIMABLE RECOVERY_FILE_DEST flashback SPACE_USED-----------------------------------------------------8589934592 36 0 1678908928 Currently I am using 20% of Flah recovery area, if it continues like this, in a few days I will have the same problem. With respect to retention policy is set to \"NONE\".

Hugs,
Marcio Souza
Location: RJ

Márcio Souza

Poston Wed, 24 Oct 2007 2:38 pm

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

For the Oracle start complaining about space and make cleaning up obsolete files, you must also establish what we call politics based on recovery window ( 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 using the dbconsole.
In this window in days, você performs the off-site backup.

Gilberto
gilbertoca
Location: Palmas - TO


Poston Thu, 25 Oct 2007 12:02 pm

Good morning Gilberto, we have an entire infrastructure set up to backup with tape and now got a storage, that for production. The issue at hand is that this base 10 g's development, we do backup on DVD and, but I'm with hampered to configure RMAN and leave on her own clean obsolete files as you said yourself.


Márcio Souza
Marcio Souza
Location: RJ

Márcio Souza

Poston Thu, 25 Oct 2007 1:37 pm

gilbertoca
Location: Palmas - TO



  • See also
    Replies
    Views
    Last Post


Return to DBA General

Who is online

Users browsing this forum: No registered users and 0 guests