Thanks,
We have located the problem. The archive log file seq 4936 does not exist
physically on the disk. It has been earlier deleted using the OS rm
command. Its reference from the recovery catalog has not been re,moved.
When we take a fresh backup, it validates from logseq 4958 onwards which
are currently existing but for the previous files, it should remove their
reference from the recovery catalog. We are using the "change archivelog
all validate;" command in the backup script.
Infact, it is for the first backup that has started from logseq 4958. No
backups of this database were taken before that. Can you help me figure out
why it is not able to remove the old log references.
The backup format in use is -
sql "alter system switch logfile";
backup
format 'ar%d_t%t_s%s_p%p'
(archivelog all);
Please note that we are using Oracle 8.0.6.
Thanks,
Anuj
On Mon, 8 Mar 2004 14:54:50 +0100, Uwe Weber <uwe.weber AT teleos-web DOT de>
wrote :
> Anuj Mediratta schrieb:
> > after checking all the files, it returns back with error -
> >
> > RMAN-06025: no backup of log thread 1 seq 4936 scn 628893 found to
> > restore
>
> Oracle has: oerr RMAN 6025
> 6025, 1, "no backup of log thread %d seq %d scn %s found to restore"
> // *Cause: An archive log restore restore could not proceed
> // because no backup of the indicated archived log was found.
> // It may be the case that a backup of this file exists but
> // does not satisfy the criteria specified in the user's
> restore
> // operands.
> // *Action: None - this is an informational message. See message 6026
> for
> // further details.
>
> My guess is that rman still catalogues a backup piece which is not
> on networker media anymore. Run crosscheck archivelog all.
>
> Regards,
> uwe
>
>
>
--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
|
