Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> oldest online log file

oldest online log file

From: NeilC <neilc-olops_at_btinternet.com>
Date: Tue, 25 Jan 2000 14:34:50 +0000
Message-ID: <388DB48A.FD15F230@btinternet.com>


Hi,

has anyone got a piece of code that determines the oldest online log sequence number (as given by Archive log list command in svrmgrl), and is able to use this to pick up the start Archive log file to backup as part of a hot backup. I guess it would have to also know the log_archive_format to know where abouts in the archive log filename this number appears.
Or is there an easier way to make sure you have a list of all the archive log files required as part of a hot backup ? This is running under unix by the way (HP or solaris) and V7.3.4 to 8.1.5

Thanks

NeilC Received on Tue Jan 25 2000 - 08:34:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US