Help - Search - Members - Calendar
Full Version: rman problem
Oracle DBA Forums > Oracle > Oracle Forum
shay_b
Hi
i try to do backup my database (on RAC) with rman and i get error on archive file

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 07/08/2008 12:02:56
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /clkp/arc2/clkp_1_23055_622580590.arc
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3



The ls -lrt on this file give

$ ls -lt /clkp/arc2/clkp_1_23055_622580590.arc*
-rw-r----- 1 oracle dba 5059210 Jul 5 06:02 /clkp/arc2/clkp_1_23055_622580590.arc.gz
$

and in list backup of archive log from recovery catlog i get this .

RMAN> list backup of archivelog all;

List of Archived Logs in backup set 1427044
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 23055 1059802031 05-JUL-2008 05:32:11 1059907295 05-JUL-2008 06:02:09
1 23056 1059907295 05-JUL-2008 06:02:09 1060013017 05-JUL-2008 06:32:11
1 23057 1060013017 05-JUL-2008 06:32:11 1060125795 05-JUL-2008 07:02:10
1 23058 1060125795 05-JUL-2008 07:02:10 1060244946 05-JUL-2008 07:32:10
1 23059 1060244946 05-JUL-2008 07:32:10 1060355649 05-JUL-2008 08:02:10
1 23060 1060355649 05-JUL-2008 08:02:10 1060458832 05-JUL-2008 08:32:09
1 23061 1060458832 05-JUL-2008 08:32:09 1060589902 05-JUL-2008 09:02:05
1 23062 1060589902 05-JUL-2008 09:02:05 1060689630 05-JUL-2008 09:32:05
1 23063 1060689630 05-JUL-2008 09:32:05 1060803942 05-JUL-2008 10:02:05
1 23064 1060803942 05-JUL-2008 10:02:05 1060924324 05-JUL-2008 10:32:05
1 23065 1060924324 05-JUL-2008 10:32:05 1061042589 05-JUL-2008 11:02:04
1 23066 1061042589 05-JUL-2008 11:02:04 1061163537 05-JUL-2008 11:32:06
1 23067 1061163537 05-JUL-2008 11:32:06 1061286778 05-JUL-2008 12:02:05
1 23068 1061286778 05-JUL-2008 12:02:05 1061401735 05-JUL-2008 12:32:04
1 23069 1061401735 05-JUL-2008 12:32:04 1061515794 05-JUL-2008 13:02:03
1 23070 1061515794 05-JUL-2008 13:02:03 1061635882 05-JUL-2008 13:32:04


This script was runing ,

connect target xxxxxxxxxxxxxx;
connect rcvcat xxxxxxxxxxxxxxx;
run
{
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
allocate channel t3 type 'SBT_TAPE';
allocate channel t4 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=legato,NSR_DATA_VOLUME_POOL=Daily)';
backup full format '/instance_%s_%p/' (database);
crosscheck archivelog all;
backup archivelog all;
delete archivelog all completed before 'sysdate - 5';
release channel t1;
release channel t2;
release channel t3;
release channel t4;
}


why is need this file was backed up ?


Thanks
dave
uncompress the file and it will be backed up
shay_b
hi
i know that uncompress file resolve the problem

my ask is why is need this file if i see the file in list backup of archivelog all .

thanks
dave
because you havent asked for it to be deleted once backed up, so it will back it up every time
shay_b
"because you havent asked for it to be deleted once backed up, so it will back it up every time"


you mean in this command

delete archivelog all completed before 'sysdate - 5';

I asked to delete the archive file before 5 day and this file is befor 2 day ,

I can"t understand the logic in this .

i will thank you for explain .
dave
the command is right after you try to back it up - and it cant back it up beciase the file isnt there - so you get error
shay_b
but i see the file in list archivelog

RMAN> list backup of archivelog all;

List of Archived Logs in backup set 1427044
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 23055 1059802031 05-JUL-2008 05:32:11 1059907295 05-JUL-2008 06:02:09


it is not say that the file was backed up?

what i need to write in script ?
dave
if the file is there, it will try to back it up everytime until it is deleted
shay_b
but the file is not there the name of file is clkp_1_23055_622580590.arc.gz


how to fix it witout uncomress to file ?

what is your advise to backup archive log and delete ?

Thanks
dave
just uncompress the damn file and let the database back it up!!!!!
shay_b
if i do this it is work yo right.


why is not fail again for another file that compress.
i do comressto file all 24H back.

how to fix this in script?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.