Re: Missing archive in hot backup

You can also
Issue Checkpoints,Archive log all,Switch Log file and then temporarily stop the Archiving Process and generate the list of Archived Redolog files from the Os and then Start the Archiving Process and then Backup the Files...

This way you would not miss any file...

-Thiru

nixond_at_my-deja.com wrote:

> We are running into a picular situaton on a Oracle 7.3.4 database
> running on HP/UX 10.20. If anyone has any insights on to what is going
> on, I would be interested in your comments.
>
> We are running into an occasional problem with our online(hot) backup.
> This script has run with very little problems for years and then all of
> a sudden on one system it started having this problem.
>
> We do the usual steps of putting the tablespaces into backup mode, etc.
> At end we cycle through the redo logs to create the archives need for
> recovery we capture the last sequence number and check in v$log that it
> is archived and the status is inactive. We then build a list of via the
> "ls" command of all the present archive logs and copy then to our nline
> backup directory. Has worked for years with out a hitch, and now the
> very last archive occasionally doesn't show up in the list of archives
> to be copied. I put in some debugging statements and the timestamps in
> the dumps, alert.log and backup.log all show are all in sync with when
> the archive log should have been created.
>
> My questions is, according to the Oracle Archiver Best Practice (Note:
> 45042.1) the ufs archive file is created before the controlfile and
> redo log status is changed. If this is correct, the file should
> exist before we ever create the list of archive files. Is this ccurate?
> Are there some other circumstances that may cause this file to be
> written or finished being written to before the file can be seen at the
> OS level?
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Aug 02 1999 - 13:01:15 CDT