Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

Re: [suse-oracle] RMAN - Recovery Question

Ronny Egner

2007-04-26

Replies:

Arno Seidel schrieb:
> Maxim Tkachenko schrieb:
>>
>>> recover database;
>>> rman stops after some time and says:
>>> RMAN-06025: no backup of log thread 1 seq found to restore
>>> several times ... these requested log sequences are older than 3
>>> weeks and i don?t have them any more.
>>> Why does Rman want this old logs???
>>> And how can i recover the database without these old logs?
>>>
>>> any help would be great.
>>>
>>> regards from germany
>>>
>>> Arno Seidel
>>>
>>>
>> use "restore archivelog time " or "restore archivelog sequence XXXX".
>> Number of sequence may give from backup.log or  use "list backup" on
>> rman.
>>
>>
> list backup only shows the highest missing archived_log sequwnce and
> these backupsets are marked as
> expired (they are over 3 weeks old and happend before 3 full backups of
> the database).
>
> There must be a way to tell rman to skip these verry old archived_logs.
> crosscheck backup
> and delete expired backup does not change the behavior of the recover
> command ...

I??m sorry but this behavior is completely anormal. I??ve never
seen that before.
Could you show the complete script please and the complete output?


--
Mit freundlichen Gr????en

Ronny Egner
Diplom-Ingenieur (BA)
Systeme & Service
Oracle DBA

Telefon: +49 381 2524-422
Telefax: +49 381 2524-399


mailto:ronny.egner@(protected)
http://www.siv.de

SIV.AG - Service f??r Informationsverarbeitung AG
Hauptsitz: Konrad-Zuse-Str. 1, 18184 Roggentin
Handelsregister: Amtsgericht Rostock, HRB 8677, Ust.-IdNr.: DE 137477226
Vorstand: J??rg Sinnig (Vorsitzender), Andreas Lehmann, Arno Weichbrodt
Aufsichtsratsvorsitzender: Peter Gronemeier
***************************************************************************************
Aus Rechtsgr??nden ist die in dieser E-Mail gegebene Information nicht
rechtsverbindlich. Eine rechtsverbindliche Best??tigung reichen wir Ihnen
auf
Anforderung in schriftlicher Form nach. Diese Nachricht ist
ausschlie??lich f??r den
bezeichneten Adressaten oder dessen Vertreter bestimmt.

The information contained in this email is not legally binding. At your
request,
we will provide you with a legally binding confirmation in written form.
This
message is intended solely for the addressee, entity to which the email
is addressed or the authorised agent.
***************************************************************************************


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.