Re: Missing archive in hot backup

First of all, don't get the sequence number from v$log. Issue the svrmgrl command 'archive log list' instead.

After you have put each of the tablespaces into hot backup mode, copied it and then returned the tablespace to normal mode, issue the 'archive log list' command and then issue the 'alter system switch logfile' command. If you don't do that then the current log will not be written out as an archived log.

For a good discussion of this, see the Oracle Press book 'ORACLE Backup & Recovery Handbook 7.3 Edition".

Ken

nixond_at_my-deja.com wrote:

> 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?
>
Received on Mon Aug 02 1999 - 12:04:27 CDT